Populating Reference fields

[eromanek]

Hello,

I added a reference field (u_email_address) to the Incident form referencing the sys_user table so I can lookup/pull info from the User table's email address field (email).   I used the below attribute on the email address field on the Incident form and although the email address shows, only the name populates the email address field and not just the email address.  Any suggestions?

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name,ref_ac_columns_search=true,ref_ac_display_value=false

[Dr Atul G- LNG]

Try with @eromanek 

[servicenow us12]

Hello @eromanek ,

Kindly use below attribute for the reference field  (u_email_address) so that you will be able to see user id, email and name of the user in auto-suggestions

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name;email;name,ref_ac_columns_search=true,ref_ac_display_value=false

[servicenow us12]

hello @eromanek ,

update the attribute ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name;email;name,ref_ac_columns_search=true,ref_ac_display_value=false

[Jyoti Jadhav9]

Hi @eromanek ,

You can add email while searching using the "ref_ac_columns" attribute, but when you actually select that user, it will only show/select the name of the user in the Reference field.

If you want to show the email on selection as well, you will have to make the "email" field as Display(Display Column value = true) for the user table which is not recommended.

Please hit the like button if my suggestion has helped you in any way.
Please mark correct if my response has solved your query.

Thanks & Regards

Jyoti Jadhav