Reference field show email of the user it will not impact on the other table reference to user field

[Gillerla Rajesh]

Hi There,

in incident form caller field showing name it's fine, but we have cutom table that is refering to user table, and it's showing name in that filed i need to show email id in the custom table ,

but not impact on the other table's i means what are the fields refering to user table. i need t show email in the custm table fileds it's refering to user table, 

how can i achive

[Robbie]

Hi @Gillerla Rajesh,

To confirm my understanding, you actually want to change the display value on your custom table and custom field extended from the sys_user table.

This is easily achieved by navigating to the custom table and custom field and configure the 'Attributes' field by adding/editing the syntax similar to the below:

ref_ac_columns=name;email

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Slava Savitsky]

The only effect this is going to have is that email will be displayed as an additional column in the autocomplete box. This is not going to change anything in terms of the value displayed in the reference field as such.

[Robbie]

Hi @Slava Savitsky - Thanks for the sense check. I did ask and clarify my question at the start....

You're right and upon re-reading, if it's simply the fact to display the email address of a selected user (and not just when typing to search for the user), it's a case of - (keeping to OOB configuration), display the dot walked field on the form. Thanks.

(Thinking out loud I was contemplating dictionary overrides etc, but that won't do it... )

Cheers

Thanks

[Slava Savitsky]

A dictionary override won't help either. With a dictionary override, you can configure a different display field for a child table of User table (e.g. Contact table in CSM), but this is not what is needed in this case. The question is about how to achieve different display values depending on which table the referenced field is on, not which table it is pointing to.