Combine 2 x User fields
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 ...
Forum Discussion
Hi Mark
I tried it with the Formula - User - List field type but that had an error - Expecting a List
I have changed the field type to Formula - Rich Text - this returned with the User / Site Supervisor name only. I double checked the Labour Resource - Mobile and there is numbers in this field for the related Site Supervisor.
------------------------------
Jessica Matenga
------------------------------
I tried it with the Formula - User - List field type but that had an error - Expecting a List
I have changed the field type to Formula - Rich Text - this returned with the User / Site Supervisor name only. I double checked the Labour Resource - Mobile and there is numbers in this field for the related Site Supervisor.
------------------------------
Jessica Matenga
------------------------------
//Could try UserListtoName()
//https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=185
Seems like a ticket issue, theres no reason for a text field not to return your data
------------------------------
GMacri
------------------------------
//https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=185
Seems like a ticket issue, theres no reason for a text field not to return your data
------------------------------
GMacri
------------------------------
