How to populate username in reference field

[Swetha M]

When typing in the reference field, the username should get listed instead of userID. How can I achieve this?

[Teja11]

Hi @Swetha M ,

Follow these steps to modify the display value of a reference field:

1. Open the form that contains the reference field you want to modify.
2. Right-click on the reference field and select Configure -> Dictionary.
3. In the Dictionary Entry form, scroll down to the Attributes related list and click on the "Edit" button next to the "Attributes" field.
4. In the Edit Attributes form, add a new attribute with the following values:
   • Name: reference_qualifier
   • Value: sys_user.user_nameLIKE${query}^ORnameLIKE${query}
5. Save the attribute and Dictionary Entry forms.
6. Reload the form that contains the reference field. Now you can see the user names instead of user id's

Regards,

Teja

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.