Get and Set Values using Javascript in Repeating Section of a Dialog

[kingcarol]

Does anyone know the lingo for getting a value and setting a value based on the 'get' value? I looked through forum but hard to not get a zillion threads when search for this.

I'll throw out a wild made up example... if user enters Calif in a field on a repeating section row in a dialog, get that value and change it to CA

ON GRID: On a regular record row on a grid, it would be:
var varState = grid.object.getValue('G','AP_VNDR_STATE',{grid.rowNumber});
if varState == 'Calif' {
grid.object.setValue('G','AP_VNDR_STATE',{grid.rowNumber},'CA')
}

How would you do the same thing on a repeating row on a dialog?

[kingcarol]

Re: Get and Set Values using Javascript in Repeating Section of a Dialog

EDIT!!! Well, never mind on the stuff below. It works in Live Preview, but when I publish it and open it in my real IE8 browser, the set value will not stick.

Well, in case anyone stumbles across this thread, I was actually trying to find out the javascript for setting a value on a repeating row of a dialog because I was having a problem with setting a value using Xbasic on a field that has an edit combo lookup. For whatever reason, the Xbasic that Alpha suggests to use for setting a value in a field in a repeating row will not work (per Alpha) on a field with edit combo lookup. They said it needs to be set with Javascript. I have to do a callback and use Xbasic because I am executing some queries to check whether the selection the user makes is appropriate under certain conditions. If their selection is not appropriate, I need to return the original (or old) value to the field. SO, ANYWAY, I did figure out the javascript for setting a value in a dialog repeating row field, and have now successfully incorporated it into my Xbasic function as follows. This function is called by another function that executes my lookup queries and calls this one if appropriate. That first function is call by the onChange event of the field. Maybe this will help someone else out in the future:

function GL_MAIN_ACCT_NUM_SetOldValue as c (e as p)
'PURPOSE:  Return the original GL Number to the field if previous function calls this function.

dim activeRow as c = e.repeatingSectionInfo[1].activeRow 
dim i as n
i = convert_type(activeRow,"N")
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
dim oldGLNum
oldGLNum = e.oldDataSubmitted.GL_MAIN_ACCT_NUM[i]

dim js as c
js = "{dialog.object}.setValue('GL_MAIN_ACCT_NUM:" + i + "','" + oldGLNum + "');"
GL_MAIN_ACCT_NUM_SetOldValue = js

'js should end up as this: "{dialog.object}.setValue('GL_MAIN_ACCT_NUM:i','xxxx');"  'where the 4 x's represent the 4 characters of a gl number

end function