Expand all | Collapse all

Obtain user value from text (multiple choice) field

  • 1.  Obtain user value from text (multiple choice) field

    Posted 07-26-2017 14:52

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

  • 2.  RE: Obtain user value from text (multiple choice) field

    Posted 07-28-2017 20:30
    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.