Question & Answer > View Question

Prepopulate a grid with data via Javascript

Confluence User - 03 Apr, 2018

Hi!

I have a gridForm its Id is : 'liste_coordonnes', with 3 columns : 'numero_borne', 'x', 'y'.

I want to fill it with Data via Javascript like that :

-----------------------------------------------------

//Getting the grid

var mygrid = FormUtil.getField("liste_coordonnees");

//Construct the JSON object that correspond to the item row's form

var mydata = {"numero_borne":"1", "x":"Medical", "y":"Mediacal2"};

//Calling the formGrid add methd

mygrid(mydata);

---------------------------------

but it doesn't work, any help please

forms;userviews

2

Confluence User •

04 Apr, 2018 •

confluenceUser •

•

confluenceUser •

Hi, I found this Add a new Row in Form Grid using script may be what you are looking for. Also, there is another sample app in How to do an auto calculation of grid 2 based on values from grid 1 ? quite similar to your need but it is using advanced grid. There is another sample which is using load binder in How to populate Grid using the Bean Shell Load Binder?.

Confluence User •

04 Apr, 2018 •

confluenceUser •

•

confluenceUser •

I just have a try, quite easy to do with following script in form grid.

function updateCell(fieldid, cellid, value, rowNo) {
    var element = FormUtil.getField(fieldid); 
    var row = $(element).find("tr.grid-row:eq("+(rowNo-1)+")"); //0-based
    var data = $(row).find("textarea").val();
    if (data !== "") {
        data = eval("["+data+"]")[0];
    } else {
        data = {};
    }
    data[cellid] = value;
    $(element).enterpriseformgrid("fillValue", element, row, JSON.stringify(data));
}
updateCell("grid1", "cell1", "test", 2); //row 2

1

CSV | Excel | XML | PDF

Your answer

Print

Prepopulate a grid with data via Javascript

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-07296953-b561-4191-a723-9a7a59749b0c{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-986bf592-2b85-41e2-931a-0dfa69a5d4f3{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer