Assign Record from Contact table based on user field

Question

I have a request to automate the assignment of a record based on the last modified user. I have a requests table with request updates. The user making the request update should be assigned to the request. The assigned to field is a related to an employee table and is not a user field. Is there a way to accomplish this? (The employee table does include a mandatory email field)

Thanks

------------------------------
Christine White
------------------------------

MarkShnierYou · Answer

You can make a Sync table to mirror the employees table but set the key field on the Sync table to be the userid field (in text format). Then make a formula field on the "records" of ToText(User()) and use that as the Reference field in a in a relationship to pull in the Record ID# for the current user and use that in a form rule

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community