Get User From text field

Question

This may sound like an odd question.&nbsp; Is it possible to get a user from a text field.&nbsp; 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.&nbsp; To make things worse, the source data at times has multiple variations of the name for the same person.&nbsp; I need a way to take that source data of the name and get to the Quick Base user.&nbsp; What s the best way to accomplish this?------------------------------Paul Peterson------------------------------

markshnier__you · 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

Thank you Mark,That is what I was planning and just worked through a proof of concept in the test version of the app.&nbsp; I'll move this into production early next week.&nbsp; This will also give me the ability to do a couple other things I want to accomplish.------------------------------Paul Peterson------------------------------

paulpeterson1 · Answer

Mark, thank you!I have this part working.&nbsp; Now I want to revisit a question I asked previously.&nbsp; Now that I have the table of users, how can I use the data to populate a drop down field of users in a certain role?&nbsp; For example, say I have a widget assembly team and a widget sales team.&nbsp; How could I create a drop down of users for each team ?------------------------------Paul Peterson------------------------------

markshnier__you · Answer

You would need to have a field on the table to replicate the Roles, ie there is not a way to have the table automatically&nbsp; "know" the role(s) for each user.Once you have that then you can set the form properties for the drop-down list to use a particular report which would have a filter on it.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

I have the user role in the table I created.&nbsp; The only place I see to do this is in the multi-select, is there a way to do this with a user field?------------------------------Paul Peterson------------------------------

Forum Discussion

Get User From text field

Related Content

Get the role of a user in a user field

User field not updating

How to copy a user to another user field in a webhook?

Consolidate Field Types

Show unique parent records for current user