Forum Discussion

BenjaminGolden's avatar
BenjaminGolden
Qrew Cadet
6 years ago
Solved

User Fields in Exact Forms

So I have a User field in a table that I'm directly inserting into an exact form, but regardless of how I have the User displaying in QB, I can only get the username to display on the form. Is there a...
  • LauraThacker's avatar
    LauraThacker
    6 years ago
    Build a formula-text field in your table with the formula:

    UserToName([User Field])

    to convert the user-email to the text name; then use that formula-text output in your Exact Form.

    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------
XavierFan's avatar
XavierFan
Qrew Cadet
6 years ago
Yes, for a user field, make a Formula Text field to convert and display the actual name of the user on the Exact Form.

Would be nice if there was a built-in snippet to do the conversion directly - but that doesn't exist on native Exact Forms as far as I know.

------------------------------
Xavier Fan
------------------------------
  • BenjaminGolden's avatar
    BenjaminGolden
    Qrew Cadet
    6 years ago
    Thanks Laura and Xavier! Hopefully someday they'll have something native to exact forms that can do this without having an extra field, but as long as I'm using the best practice available I can't really complain.

    ------------------------------
    Benjamin Golden
    ------------------------------