4 Replies Latest reply on Sep 1, 2013 1:52 PM by shae1725

# Help with a small Field "Case" Calculation

### Title

Help with a small Field "Case" Calculation

### Post

Hi

I am currently teaching myself how to use the Case Calculation for fields but need a little help on this one.

I have 4 fields which (If Empty) I want to populate them all  entering the data in any one of the 4 fields.

ie if I enter "100" in field(  a) then field (b c d) will also contain "100" if empty

• ###### 1. Re: Help with a small Field "Case" Calculation

Try to have each field, in their auto-enter option, this calculation:

Let (
L = List ( a ; b ; c ; d ) ;
Case (
not IsEmpty ( L ) ; Get ( ActiveFieldContents ) ;
Self
)
)

• ###### 2. Re: Help with a small Field "Case" Calculation

Thanks

The calculation works well

The only problem is I  need the calculation to only work if the ( a b c d)    fields are empty or containing 0.

i need to be able to enter a value in any of the individual fields without affecting the rest.

• ###### 3. Re: Help with a small Field "Case" Calculation

Try this other:

Let(
L = List ( a ; b ; c ; d ) ;
Case (
IsEmpty ( Self ) ; Get ( ActiveFieldContents ) ;
Self
)
)
• ###### 4. Re: Help with a small Field "Case" Calculation

That works well, I have another calculation to add to the same field! I didnt want to complicate the above calculation because i really needed to fully understand how you compiled it!

If field "X" = C (MW - WW / 2) to populate fields a;b

if field "X" = E (MH - WH /2) to populate c;d

if field "X" = R  ( a; b; c; d; Self)

I really appreciate your help. Many Thanks