How do i properly use a Lookup select box to populate the value of a field on the caller's user record in a record producer?

[RBlor]

I am working on a record producer and was trying to use the lookup select box to autopopulate the caller's emp# field on the form. for some reason i only get the sysid show up. the field on the user table is a string field. . Any tips on getting this working

[Pradeep Sharma]

Hi - Update Lookup Label field with the exact column name of the field you want to show on the catalog form. Currently it looks like you have a comma separated values. Remove it with one field column name.

[RBlor]

perfect so the selection is up but is there a way to set the default value to of the user filling out the form or whatever is selected in the "open on behalf of" box?

currently in the default value it is : javascript: gs.getUserID() but i am guessing that is not right since i get the sysid with that

[Pradeep Sharma · Accepted solution]

That should work as long as the lookup value field points to sys_id field.

[RBlor]

That was it! thank you for all your help!