Get cell value from iGrid

[former_member376546]

Hello,

I want to use a value from a iGrid to use as pram for the next iGrid. How can I get that value??

I can't find in the script editor.

We use version 12.0

Sorry my experience in MII is not that high as wish I was already.

Regards Arno

[former_member376546]

Thx all,

This is the way I get it worked:

var planner;

var myGridObject = document.Grid_1.getGridObject();

planner = myGridObject.getSelectedCellValue(5);

Grid_2.getQueryObject().SetParam(1, planner);

Grid_2.Refresh();

Bedankt / Regards

Arno

[Former Member]

document.appletname.getGridObject().getCellValue(rowNum,ColNum)

or

document.appletname.getGridObject().getCellValueByName(rowNum,ColName)

or, for a selected row

document.appletname.getGridObject().getSelectedCellValue(ColNum)

or

document.appletname.getGridObject().getSelectedCellValueByName(ColName)

[former_member376546]

Thx Nick,

But I forgot to tell that I want to use the text from that cell as a param in another iGrid

The cell is a text cell and the text is variable

I don't know the column or row

regards Arno

[salvatore_castro]

Arno,

If you don't know the Column or Row then how are you identifying the value?

Sam

[former_member376546]

I want to select the value (cell) with the mouse.

[salvatore_castro]

Arno,

.getSelectedCellColumn()

as per the xMII Script Assistant. See the "for Manufacturing" section in downloads to get the Productivity Wizards if you do not have them already.

Sam

[sufw]

Once you have the value (using the JavaScript calls contributed already), assign it to the other iGrid using

document.othergrid.getQueryObject.setParam(+paramnumber+, +value+);

or to be more correct:

document.getElementById("otherGridID").getQueryObject.setParam(+paramnumber+, +value+);