Convert Text of Names to User

Question

Hi there,I have a quickbase app with imported data from another system.&nbsp; Each record has a "contact" field of the person who owns the record.&nbsp; I would like to convert this text field to a User field.&nbsp; &nbsp;I have created a Formula - User field with the function ToUser([contact]) but this doesn't seem to produce any result.&nbsp; 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------------------------------

markshnier__you · Answer

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
------------------------------

troymacpherson · Answer

I understand.&nbsp; Thanks for the help Mark!------------------------------Troy MacPherson------------------------------

Forum Discussion

Convert Text of Names to User

Related Content

Converting delimited text into checkboxes

Attachment - file name

Reference Numbers Displaying Instead of Names in QuickBase

Rich-text formula button on dashboard

converting text to number