Forum Discussion

JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
4 years ago

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 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
------------------------------
Formulas and functions

6 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Try 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
    ------------------------------
    • JessicaMatenga's avatar
      JessicaMatenga
      Qrew Trainee
      4 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        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
        ------------------------------