Skip to main content
Question

Obtain user value from text (multiple choice) field

  • Jul 26, 2017 6:52 PM UTC
  • 0 replies
  • 72 views

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

This topic has been closed for replies.

  • Observing
  • Jul 29, 2017 12:30 AM UTC
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.