This content has been marked as final. Show 2 replies
The calculate button is just a helper. It doesn't work when calling values contextually from a custom section that isn't loaded. It shouldn't prevent you from saving the EA. Calculate will work when calling a few out of the box methods, the system will return a specific fixed value depending on which method you are calling.
We should click button Done instead of calculate.
Edited by: 967056 on Nov 19, 2012 11:07 PM
Edited by: 967056 on Nov 19, 2012 11:58 PM
I believe you are looking for a GetMultipleValues() method.
This method returns an array of selected qualitative or qualitative lookup values. It will return an array containing one element if you have only one value selected in the cell. You can either iterate through array elements to see the values or use index notation like flute.
var flute @ GetCellInMyColumnByRowID('FLUTE').Value.GetMultipleValues();
You can use getCell function to access specific cells - just provide rowID and collumnID as parameters. In case of repeatable rows it will return the first row matching the rowID.
Hope this helps,