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
MarkShnier__You
Qrew Legend
Qrew LegendTry this
List(" ",
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
List(" ",
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
- MarkShnier__YouCan 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
------------------------------- Hi Mark
It is a mobile number.
------------------------------
Jessica Matenga
------------------------------- MarkShnier__YouIt seems impossible for the record to have a value on the field [Labour Resource - Mobile] 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. Contact me directly.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- //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
------------------------------
