Skip to main content
Question

Convert Text of Names to User

  • August 3, 2021
  • 0 replies
  • 151 views
Forum|alt.badge.img+6
Hi there,

I have a quickbase app with imported data from another system.  Each record has a "contact" field of the person who owns the record.  I would like to convert this text field to a User field.   I have created a Formula - User field with the function ToUser([contact]) but this doesn't seem to produce any result.  Unfortunately I don't have email addresses for the contacts, just their names in a text box.

Any suggestions on how best to do this would be appreciated!

Mahalo,
Troy

------------------------------
Troy MacPherson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You can set up a table of users and set the Key field to be the name of the user. Then add a field for the userid.

Then make a relationship to the imported data table based on the name field where One User has many Imported records.  

Then lookop up the User field down to imported records.

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