More specifically and generally, I have:
Dropdown_Field_1 -> Dropdown_Selection
with name =
X -> Y-Z
and want to update
Dropdown_Field_2 with name = Y-X
to be equal to
Dropdown_Selection with name = Z
For example, I have a dropdown field of "Subsystem" that has option "SEQ - Barcode Scanner". I want to update a new dropdown field "SEQ - Subsystem" to have the option "Barcode Scanner" filled out. I also have "OT - Pipettor", etc. that need to be transferred to "OT - Subsystem" under "Pipettor", etc.
I would like an automated way of transferring options between these dropdown field, without having to manually make a rule for each option (50+ of them).