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))
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.
Try this other:Let(L = List ( a ; b ; c ; d ) ;Case (IsEmpty ( Self ) ; Get ( ActiveFieldContents ) ;Self))
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