Lookup Select Box retrieve issue.

[balaji_prusty1]

Hi All;

I have two filed, both having type "look up select box". the second filed value should to be populate based on the the 1st field value on load. The 1st field name is "manager" and 2nd one is "request_access_for". It should fetch the user record based on the manger name but it is not working. I used below in referance qualifier and attributes variable.

Reference qualifier --> javascript:'active=true^manager='+current.variables.manager;

Variable attributes  --> ref_qual_elements=manager.

My instance is in Sandiego. I refer few old article and try to fix but same issue. Can someone please help me if they have solution for this. 

Thanks

Balaji Prusty

[Michael Jones - · Accepted solution]

Is the manager field a reference field, or a string field you are populating onload with the name of the submitter? I am assuming the lookup select box is a reference to sys_user. 

Try something like this, which would show all users where the person viewing the item is the manager: 

Reference Qualifier: javascript: 'active=true^manager=' + gs.getUserID()

I hope this helps!

If this was helpful, or correct, please be kind and mark the answer appropriately.

Michael Jones - Proud member of the GlideFast Consulting Team!

[balaji_prusty1]

Thanks Michael;

It worked perfectly as per my need.

[Muhammad Khan]

Hi Balaji,

It would be better if you share the screenshots which can be previewed over here. However, below is an example demonstrating your requirement.

Lookup Variable One

Lookup Variable Two

Working in both Native UI and Portal.

Service Portal

Hopefully, this will help you.

[balaji_prusty1]

Hi  Muhammad Khan;

This works when we change the parent field values after form load, but during load it not works. My manager field is read-only and the value of related field need to reterive during form load. 

Thanks for your help, your solution will help during field value change.

Thanks

Balaji Prusty