Forum Discussion

BenjaminGolden's avatar
BenjaminGolden
Qrew Cadet
5 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 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
------------------------------
  • LauraThacker's avatar
    LauraThacker
    5 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
    ------------------------------

3 Replies

Sort By
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    5 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
    5 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
      5 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
      ------------------------------