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
------------------------------

MarkShnierYou · 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  convert a user field to instead show the persons name.  ------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community