Display emails instead of user names in list collector variable.

[Balaram7]

Hi all,

Please help me with the variable type  which can allow requestor  to select multiple email ids of users,

from the variable value referring to "sys_user" table.

I tried many possible from list collector, there is no luck. Please help me with the best approach to achieve this.

Thank you,

Balaram.

[Ankur Bawiskar]

Hi,

you can have list collector and make user search with name and email as well by specifying the field names in the ref_ac_columns

In the variable attributes add this

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_columns_search=true

Regards
Ankur

[Ankur Bawiskar]

@Balaram 

Hope you are doing good.

Did my reply answer your question?

Would you mind closing the thread by marking appropriate response as correct so that it benefits future readers.

Regards
Ankur

[Ankur Bawiskar]

@Balaram 

Output:

Regards
Ankur

[Ankur Bawiskar]

@Balaram 

Thank you marking my response as helpful.

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

[Pranesh072]

You can create a new multi line text variable and hide it on the form. Use onchange client script on List collector field and populate the emails to multi line text variable by using glideajax on client script.