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 ov...
Forum Discussion
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
------------------------------
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
------------------------------
Because it is a key field, it cannot be blank when the record is created
------------------------------
Justin Torrence
------------------------------
------------------------------
Justin Torrence
------------------------------
- Hi Justin,
Could you set it to a default value and then let the Automation overwrite it? Though to be fair if it is a key field and you are using it in relationships now that you aren't able to rebuild then that would be less than helpful unfortunately. There isn't a function to pull just the UID from a user via a formula, just name or email address and as such if either changes Quick Base won't be able to update without going back to update from the source as it changes. If being able to pull the UID is something that would be helpful you can submit that as a User Voice feedback even if that wouldn't help you with your use case today. Sorry there isn't a formula function or trick I can suggest in this instance.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
