Skip to main content
Question

Convert user email to user name on document

  • April 27, 2021
  • 0 replies
  • 133 views
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
------------------------------
This topic has been closed for replies.

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/
------------------------------

@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
------------------------------
Terms & ConditionsAccessibility statement