Hey Guys,
I tried doing this in the admin panel but not sure if it can be done. I want to populate a person's name whenever their state is type in. Our state field is a 2 digit text field (the standard out of the box one) For example:
IL, WI, OH, IA = Dan
CA, OR, AZ = Bill
Thanks in advance!
You could have a calculated field but the formula could get quite complicated and you would end up with hardcoded values.
How about a before_save logic hook?
You could add a multiselect field in Users which stores the states for each user.
Then in the logic hook you can find the User for that state and add their username to the field in question.
This would avoid hardcoding and if someone leaves the company their replacement can be assigned their states.
HTH
FrancescaS