Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
6 years ago

Create a text field to show record owner on Exact Forms Plus

I am trying to pickup the record owner as the name on Exact Forms Plus. When I put the record owner field on the form, I am getting a number instead of the name. I have tried to use a text formula for this but when I do that, I get the email address of the user. Is there a way to create a field to show the name.

------------------------------
Joey Zint
------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    What is the text formula you tried?

    Try using UserToName([Record Owner]) instead. If you were getting an email it should convert that over, same for the actual QuickBase user in your screenshot I believe.

    If you want the last name first you need to do it another way. UserToName([Record Owner], "LF")