AnsweredAssumed Answered

Auto-Enter data

Question asked by LorenaMusser on Jan 31, 2013
Latest reply on Feb 1, 2013 by philmodjunk

Title

Auto-Enter data

Post

     I would like to create a field that auto enter's data if another field is equal to a certain value.  In my file I have a seperate tab for each:

         
  •           Home Address
  •      
  •           Work Address
  •      
  •           Church Address
  •      
  •           Mailing Address

     On the mailing tab I have field that is "Same As" set up as a radio button to choose either Home, Work or Church.  I would like the Mailing address fields to auto enter the data from the other corresponding address fields if the "Same As" field is ticked.  Otherwise I would like it to be blank so that a different address can be entered.  What is the best way to go about this?  in the Auto-Enter options I have checked the specify calculation and tried the following 2 formulas, niether of which work:

     If ( IsEmpty ( If (Same as = "Home" = Home Address 1 ; If ( Same as = "Work" ; Work Address 1 ; If ( Same as = "Church" ; Church Address 1 )))) ; "" )

     If (Same as = "Home" = Home Address 1 ; If ( Same as = "Work" ; Work Address 1 ; If ( Same as = "Church" ; Church Address 1 ; "" )))

     Any assistance would be greatly appreciated.  Thanks.

Outcomes