3 Replies Latest reply on Aug 28, 2012 11:30 AM by DavidZakary

    Set Field By Name

    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