Obtain user value from text (multiple choice) field

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I have a database with two tables, projects and project team that are linked (relation).  I use the [Employee] field from the project team table as a multiple choice field in the project table.  Being that the [Employee] field is text, I want to create another field which returns the user value of the employee selected in the drop down. 

1.) What sort of formula field should I use here?

2.) Should I use a Case statement for the formula?

3.) What's the proper format of the formula statement (ToText or something else)?

Photo of Michael Sargent

Michael Sargent

  • 150 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Unfortunately, there is no formula function that will produce the User based on a name. I would strongly suggest that you setup a User field on the form instead. This will act as a drop-down for your users and produce the necessary User, which you can further utilize in Roles, Email Notifications, etc.