How to display the user phone number instead of user name in catalog item

Supriya KM
Tera Contributor

Hello Everyone, 

I have a variable in the catalog item as contact number which is a reference from sys_user table. When am clicking on the search i need to display the user mobile number instead his/her name. 

I cannot make display as true in the table because it will affect globally. So anyone can help me how to achieve this.

 

 

3 REPLIES 3

Mike_R
Kilo Patron
Kilo Patron

Maybe use a lookup select box instead

Mike_R_0-1670252900486.png

 

Supriya KM
Tera Contributor

Hello Mike,

Thanks for the quick reply. With this am getting the list of phone numbers but I wont be able to select the mobile number for the user which am clicking. With this method, we wont be able to see the user names as well.

Can you please suggest any other way as it doesn't meet my requirement?

If you are OK with this format

Mike_R_0-1670254104395.png

the you can use these configs

Mike_R_1-1670254126023.png

 

 

Otherwise you will probably need to create a string field to store the phone number. E.g. they select the user from a reference field, and then the string field auto-populates with the phone number.