Skip to main content
Solved

User Fields in Exact Forms

  • September 11, 2019
  • 0 replies
  • 81 views
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 code snippet to change the format of the User in the exact form or should I just try making a new field?

Thanks,

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

Best answer by LauraThacker

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
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+12
    • LauraThacker
    • Registered
    • Answer
    • September 11, 2019
    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
    ------------------------------
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
      • XavierFan
      • Registered
      • September 11, 2019
      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
      ------------------------------
        Terms & ConditionsAccessibility statement