I'm using Set Field By Name to swap a bunch of address fields around.
I've got 4 sets of address fields. All have a unique identifier in the name (address_residence_01, address_mailing_01, address_billing_01, etc.).
Users regularly need to copy the residence address to the billing address, etc. Lots of possible combinations.
I could put 4 buttons on the layout to perform the copy, but that seems messy.
What I've done is put a drop down beside the address with the possible options to "copy from".
I can calculate the destination with the Set Field By Name eaily.
For some reason I cannot calculate the value that should be put into the destination field. I want the value to be calculated, not hard-code the field name.
My calculation for the result is "Contacts::address_" & $address_set & "_city" (for example)
The $address_set variable would be "residence", "mailing", "billing", etc.
My result is the actual field name string rather than the contents of the field. I've tried a couple things to pull the value but haven't got it yet.
My brain is fried today and I clearly missing something simple.
Can somebody wake me up and point me in the direcdtion?