Get User From text field

Question

This may sound like an odd question. Is it possible to get a user from a text field. The situation I have is I have the users names in another system that may be a close match but not necessarily an exact match to the names in Quick Base. To make things worse, the source data at times has multiple variations of the name for the same person. I need a way to take that source data of the name and get to the Quick Base user. What s the best way to accomplish this?

------------------------------
Paul Peterson
------------------------------

MarkShnierYou · Answer

Way to do this would be to have a table of Names where the text name field is the key field and then you would manually need to select the user ID for each name.

Obviously you cannot translate from a random name to a unique QuickBase ID as many people on this planet have the exact same name.

Then you would have a relationship between this name table and your data table to look up the user ID based on the name on your data record

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

Sign up

Login to the community