Copying data following a yes or no field

[mikewb20012000]

I am trying to set fields to use the sane user input for address lines. 

I have:

billing address 1 

Billing address 2

Site address 1 

Site address 3

Also have a field 'use billing address' which is a yes/no.  

What I need to do is if the 'use billing address' is yes, then copy the billing data lines to the site address lines. However if no, then allow to have user input manually. 

Can anyone help as I have tried different expressions, but it makes the field ready only?

Thanks in advance

[SkrOYC]

---

@mikewb20012000 wrote:

I have tried different expressions

---

Use an Initial Value expression, not AppFormula

[mikewb20012000]

Thanks for your reply.

In the initial value expression, I've used in the site add1 fields:

If ([Billing Address Same?] = TRUE, [Billto Add1],"")

But I get nothing returning in site Add1 when I change the ([Billing
Address Same?] field?

Any further suggestions?

[dbaum · Accepted solution]

Consider a different approach:

• Show the site address columns only if [Billing Address Same?] is not true.
• Anywhere in your app that you need to reference the site address, use a conditional expression to reference the billing address columns if [Billing Address Same?] is true and otherwise reference the site address columns.