Forum Discussion

JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
4 years ago

Convert user email to user name on document

Hi
I have the user field displaying on QB the user full name.

However, when I use the same field on a document it displays the user id, so I created a separate formula - text field to convert to text using -
totext([Project - Estimator])

but it returns as the users email address.  Is there a formula to display the user first & surname on the document?

------------------------------
Jessica Matenga
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    You will need to use the function UserToName instead of ToText

    UserToName([User Field])

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    / http://datablender.io/
    ------------------------------
  • JustinTorrence's avatar
    JustinTorrence
    Qrew Cadet
    4 years ago

    @Jessica Matenga

    Use the function ​UserToName() to display the user's full name in text. This Function can take either one or two arguments depending on how you would like to format it. Here is a link to some documentation: https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6#dynamic/{%22sidebar%22:[],%22searchString%22:%22usertoname%22,%22ver%22:1}



    ------------------------------
    Justin Torrence
    Quickbase Expert, Jaybird Technologies
    jtorrence@jaybirdtechnologies.com
    https://www.jaybirdtechnologies.com/#community-post
    ------------------------------
    • JessicaMatenga's avatar
      JessicaMatenga
      Qrew Trainee
      4 years ago
      Perfect!! Got it displaying correctly.  Thank you.

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