Skip to main content
Question

User IDs and ToUser function

  • December 7, 2021
  • 0 replies
  • 117 views
Forum|alt.badge.img+20
Two part question, thanks!

1. Does each user have a unique numerical ID, and if so, where can I find it?
2. Can I use the numerical ID with the ToUser function? I ask because I realized that if a user changes their email address, anywhere that I use their email address in a 'ToUser' formula, will break. I was thinking that maybe if I use the number, it would always remain the same?

------------------------------
Mike Tamoush
------------------------------

SSNJeffP
Forum|alt.badge.img+11
  • SSNJeffP
  • Quickbase Alumni
  • December 7, 2021
I don't believe you can easily change their email address without help from QB support.   That should always be a unique value per user.

------------------------------
Jeff Peterson
------------------------------
Forum|alt.badge.img+7
  • JeremyAnson
  • Quickbase Alumni
  • December 8, 2021
You can access a 'hashed ID' using UserToId() - and you can see all hashed IDs in a user export - but unfortunately there doesn't appear to be an 'IdToUser' function or any other obvious way to use the ID to get back to a user.

------------------------------
Jeremy Anson
------------------------------
Terms & ConditionsAccessibility statement