Combine 2 x User fields

Question

Hi I am trying to combine username and mobile number using the following formula -
[Project - Site Supervisor]&" "&[Labour Resource - Mobile]

But it is saying the '&' after the first field - the operator '&' can not be applied on 'user'

I want it to return as the User with their associated mobile number or is there another way to link the user to the mobile?

------------------------------
Jessica Matenga
------------------------------

markshnier__you · Answer

Try thisList(" ",UserToName([Project - Site Supervisor]), ToText([Labour Resource - Mobile]))// The list function separates the listed parameters by the separator that you specify. UserToName will &nbsp;convert a user field to instead show the persons name. &nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jessicamatenga · Answer

Hi MarkI tried it with the Formula - User - List field type but that had an error - Expecting a ListI have changed the field type to Formula - Rich Text - this returned with the User / Site Supervisor name only.&nbsp; I double checked the Labour Resource - Mobile and there is numbers in this field for the related Site Supervisor.------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

Can you tell me what is in the field for [Labour Resource - Mobile] on the record that you are on? I suspect that it is blank.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

jessicamatenga · Answer

Hi MarkIt is a mobile number.------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

It seems impossible for the record to have a value on the field [Labour Resource - Mobile]&nbsp; and yet the formula that uses that field not show the number.So, you will either need to put in a support ticket, or if you happen to be around now, I'm still working and I will have a quick look with you on a Zoom call.&nbsp; Contact me directly.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Combine 2 x User fields

6 Replies

Related Content

Sorting Combined Text Field by Record ID#

Combining AND with OR in Formula Checkbox Field

Create child records from Parent List - User field

Report Formula - Combine some, exclude some, and include others.

Convert combined text email list to list user field