Capturing email address of users in a List field

[MStritt]

We have a list field on our Account table called 'Incident Contact'. Multiple users/contacts from the Account can be added to this field. So, some Accounts can have one contact and some Accounts can have multiple contacts in this field. These contacts are shown in the list as their name. I'm looking to run a report to show me all contacts that have been added to this Incident Contact field from all Accounts, and to show me their email addresses. 

[Bert_c1]

Hi MStritt,

I believe the behavior you see is due to the 'name' field on the sys_user table being used as the Display value. I believe this is default behavior when no dictionary record of the sys_user table has "Display" set to true. (number fields are sometimes used as the display value too.)  You can try setting the "Display" to true on the sys_dictionary record for sys_user.email field. But then that will affect other places where sys_user records are displayed.

Others here may other suggestions.

[MStritt]

Thanks Bert!

Yeah, not sure I want to do that. But, it's a possibility.

[Bert_c1]

Hi MStritt,

You can add 'dot-walked' fields to a report.  I believe you are referring to the 'customer_account' table.

If so, add columns like shown here in the report definition

Seems you column name is different from what I show as "Contact". Use your column name.