How to set a field by making a value choice in another
In field A a user selects from a value list of Red, Blue or Green. Upon that selection I would like field B to automatically set the team member assigned to either Red, Blue or Green. I need two fields because there are lots of other names in field B that don't ever relate to field A, but all the team names are needed here for other reports.
I have a script that works, but only when I manually select it after field A is completed but I don't want a another step like that. Can I attach a script to a field when it gets exited?
Thanks again. MaryMary