Get User From text field
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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWay 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
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
------------------------------
Thank you Mark,
That is what I was planning and just worked through a proof of concept in the test version of the app. I'll move this into production early next week. This will also give me the ability to do a couple other things I want to accomplish.
------------------------------
Paul Peterson
------------------------------
That is what I was planning and just worked through a proof of concept in the test version of the app. I'll move this into production early next week. This will also give me the ability to do a couple other things I want to accomplish.
------------------------------
Paul Peterson
------------------------------
- Mark, thank you!
I have this part working. Now I want to revisit a question I asked previously. 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? For example, say I have a widget assembly team and a widget sales team. How could I create a drop down of users for each team ?
------------------------------
Paul Peterson
------------------------------- MarkShnier__YouYou would need to have a field on the table to replicate the Roles, ie there is not a way to have the table automatically "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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- I have the user role in the table I created. 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
------------------------------