Lookup selectbox reference qualifier

surya123 · ‎10-04-2016

Hi All

I have a lookup select box and I want to write a reference qualifier which will populate the data based on data saved to requested For field.

I had earlier set this up as assigned_to =javascript:gs.getUserID();

But this just fetched record for that user. But since we can change the value of Reqested for, hw should I change the ref qual to get it work???

Abhinay Erra · ‎10-04-2016

That is incorrect. The line ref_qual_elements=.... goes in the variable attributes and the javascript one goes in the reference qual section

ref_qual_elements=Requested_For ---->This goes in the variable attributes

javascript:'assigned_to='+current.variables.Requested_For ----->This goes in the reference qual section

surya123 · ‎10-04-2016

Hi Abhinay,

Its giving a list of all assets ,not the ones assigned to the person selected in Requested For.

surya123 · ‎10-04-2016

Any other way i can get it done?

Abhinay Erra · ‎10-04-2016

What is the variable name of requested for? And it is a reference field to sys_user table right?

surya123 · ‎10-04-2016

Variable name is Requested_For and it is reference to sys_user table

randrews · ‎10-04-2016

are you sure it isn't requested_for lower case?