How can I auto populate address fields depend...

(StudentHomes Plymouth) #1

How can I auto populate address fields dependent on answer to previous question?

I’ve attempted putting Editable_if as =[Address as my permanent address]=“No”

and App formula as =if([Address as my permanent address]=“Yes”,[House name (optional)],"") and then similar for [Address1], [Address2], etc.

Whilst this populates the field and displays it when the answer is yes, I can’t get it to display the blank field for manual data entry if the initial answer was “no”.

Thought this would be simple, but have come unstuck, a steer in the right direction would be greatly appreciated. Regards, Steve

(Dinh Nguyen Nguyen) #2

@StudentHomes_Plymout Instead of using app formula, you should use Initial Value. Here’s an article explaining the difference between the two: - App Formulas and Initial Values App Formulas and Initial Values

(StudentHomes Plymouth) #3

Thank you for your prompt response and providing the link to the article I hadn’t realised the distimct difference between the two.

(StudentHomes Plymouth) #4

All done and working fine now. Apologies but relatively new user and still finding my way around! Thanks for your help.

(Dinh Nguyen Nguyen) #5

@StudentHomes_Plymout You’re welcome :slight_smile: