Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
8 years ago

Obtain user value from text (multiple choice) field

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

  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    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.