Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Single line text into a user

Topic Labels: Formulas
964 1
cancel
Showing results for 
Search instead for 
Did you mean: 
briannenshaw071
4 - Data Explorer
4 - Data Explorer

I have a database that shows the user as a single-line text, I want to create a column that looks at that single-line text and converts it to a user that is listed in my database. Is there a way to write this formula?

1 Reply 1
CJSmith
7 - App Architect
7 - App Architect

Hi @briannenshaw071, you should be able to copy/paste the name (as long as it's spelled and formatted the same as the user profile) from the single-line text to the user field.

If you're asking to translate names in the single-line text field into names used in user profiles (for example, if the single-line text field only includes first names and you need to correlate them to their full names for the user field), you'd likely have to use a switch formula and relate them 1:1 (this could be burdensome depending on how many users you have).

Ultimately, more context may be needed in this case.