Lookup Select Box

[kirankr2061]

I am using a variable lookup select box in my catalog and the column is refering to the reference field from another table if I var a = g_form.getValue(lookup Variable) what is the value I am going to get ?

[Ankur Bawiskar]

@kirankr2061 

what do you mean by column is referring to reference field from another table?

share some screenshots etc

with this line it should give you the record sysId

g_form.getValue(lookup Variable)

If my response helped please mark it correct and close the thread so that it benefits future readers.

[kirankr2061]

column which refreing another table 

[Ankur Bawiskar · Accepted solution]

@kirankr2061 

I was wrong. It gives the sysId of the referenced record within that table.

See below, I am referring to Department table and Lookup value = Department Head (Reference to sys_user) and it gave me sysId of user

1) Variable configuration

2) alert for printing the variable value

3) sysId of user

If my response helped please mark it correct and close the thread so that it benefits future readers.