AnsweredAssumed Answered

Set Field By Name

Question asked by DavidZakary on Aug 28, 2012
Latest reply on Aug 28, 2012 by DavidZakary

I'm using Set Field By Name to swap a bunch of address fields around.

 

Background...

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?

 

Dave Zakary

Outcomes