List of E-mail address to be populated for the users to select. No need of User name.

SajithM
Tera Contributor

List of E-mail address to be populated for the users to select. No need of User name.

There is a field in a Catalog form and it should show the e-mail address of all the users from User table.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@SajithM 

you can use Lookup select box variable with Lookup label as Email and it will be like this

User can select only 1 user.

If you want to select multiple then use List Collector and use variable attributes

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

AnkurBawiskar_1-1741260296998.png

 

 

AnkurBawiskar_0-1741260275605.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

3 REPLIES 3

fibssy
Tera Guru

You may want to use a variable with:
Type: Lookup Select Box.

Lookup from table: User (sys_user)

Lookup value field: Email

fibssy_1-1741260696042.png



fibssy_0-1741260665841.png

 



Please mark as helpful if this helped you.

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @SajithM 

 

We had same post yesterday,  OOTB user name will be displayed and it is not recommend to change.

 

https://www.servicenow.com/community/developer-forum/display-field-for-a-reference-variable/m-p/3196...

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@SajithM 

you can use Lookup select box variable with Lookup label as Email and it will be like this

User can select only 1 user.

If you want to select multiple then use List Collector and use variable attributes

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

AnkurBawiskar_1-1741260296998.png

 

 

AnkurBawiskar_0-1741260275605.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader