- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 18, 2023 10:12 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 18, 2023 12:34 PM
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.
