Discussions

Expand all | Collapse all

Combine 2 x User fields

  • 1.  Combine 2 x User fields

    Posted 04-30-2021 00:41
    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
    ------------------------------


  • 2.  RE: Combine 2 x User fields

    Posted 04-30-2021 07:29
    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
    ------------------------------



  • 3.  RE: Combine 2 x User fields

    Posted 05-01-2021 21:09
    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
    ------------------------------



  • 4.  RE: Combine 2 x User fields

    Posted 05-02-2021 17:47
    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
    ------------------------------



  • 5.  RE: Combine 2 x User fields

    Posted 05-03-2021 18:08
    Hi Mark
    It is a mobile number.

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



  • 6.  RE: Combine 2 x User fields

    Posted 05-03-2021 18:12
    It 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
    ------------------------------



  • 7.  RE: Combine 2 x User fields

    Posted 05-04-2021 09:11
    Edited by G.Macri G.Macri 05-04-2021 09:12
    //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
    ------------------------------