Discussions

Expand all | Collapse all

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

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

    Posted 02-19-2020 08:58
      |   view attached
    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
    ------------------------------


  • 2.  RE: Create a text field to show record owner on Exact Forms Plus

    Posted 02-19-2020 09:47
    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")