JustinTorrence1
6 years agoQrew Member
Static Quick Base User Name
I have a connected Quick Base table that pulls from another application table containing "Employee Profiles". I have set the key field of this connected table to a Quick Base User field (This comes over in the connected table as text type instead of user type). I then have a formula field that that converts that text to a User type "ToUser([User])". The problem is, any time a user updates their email or their username, the Quick Base User (key) field is not updated with it. That, and any records that use this connected table as a parent lose their reference. So I am in need of a way to get a text or numeric (unique) "User ID" that never changes that I can convert to and from User type using a formula. Should I lock down the user preferences menu and manually assign usernames to all new users? Or am I completely overlooking something much easier.
------------------------------
Justin Torrence
------------------------------
------------------------------
Justin Torrence
------------------------------