how do I use a reference qualifier to pull data from a record?

patricklatella · ‎05-02-2017

I have a field on a record producer called "Affected User", that when the user name is entered I want a 2nd field to populate automatically with data from a field on that user's record. In this case specifically a field for "Asset", which is the user's computer. Secondly, if the user has more than 1 asset listed in their user record (i.e. they have more than 1 computer assigned to them), I want the 2nd field to populate with all the assets for that user so that the user can select an asset to designate for the record producer. The record producer is for identifying issues with a computer for example. thanks!

victortrejo · ‎05-02-2017

ok this is what I think that you want to accomplish

If the field user name is filled then the field asset show the hardware assets assigned to that user,

To do that the field user name must be a reference to the table 'sys_user'

and the field Asset must be a reference to the table 'alm_hardware' and you can use the script for advance Ref Qual in this field like this

var user = current.variables.cur_user;

return 'assigned_to=' + user;

View solution in original post

victortrejo · ‎05-04-2017

How To Mark Answers Correct From Community Inbox

Maybe this helps and Thanks!!