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------------------------------

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------------------------------

User Fields in Exact Forms | Qrew Discussions

LauraThacker
Qrew Captain
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
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
  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
  ------------------------------

Forum Discussion

User Fields in Exact Forms