Skip to main content
Question

Static Quick Base User Name

  • February 12, 2020
  • 0 replies
  • 71 views
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • February 13, 2020
Hi Justin,

Another way to come at this is to occasionally pull that user formula value over into a static field. For example with an Automation that when a new record is created on that table and the User formula field has a value write the value from that formula field to a static User field. That way the user at that time is captured in the field and when the user changes email addresses later it will update as a standard user field would instead of the issue you are running into with the formula field. Then that formula would just exist in the background to populate that field when the record is created. I hope that suggestion is helpful.

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Terms & ConditionsAccessibility statement