lookup users from sys_user table that match with an existing form value

Bret Smith
Giga Guru

I want to show for selection only those users that match company with agency variable

I only want users available for selection that match "OIT" (whatever is showing in the agency variable

BretSmith_0-1712096908517.png

how can I do that with a reference qualifier

BretSmith_1-1712097153014.png

 

 

 

1 ACCEPTED SOLUTION

SanjivMeher
Kilo Patron
Kilo Patron

You reference qualifier should be javascript:'company='+current.variables.agency, provided agency variable stores the sysid of a company record.


Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

2 REPLIES 2

SanjivMeher
Kilo Patron
Kilo Patron

You reference qualifier should be javascript:'company='+current.variables.agency, provided agency variable stores the sysid of a company record.


Please mark this response as correct or helpful if it assisted you with your question.

Thank you very much.....