Calculation in the define fields

[kpyo]

Hi, i am trying to do a calculation on a field that validates 3 fields.

-if the first one is empty and the second is empty and the third is empty then put blank.
-if the 3 fields are full then put "A".
-if one of the field isnt full then put"P"

i tried to make more than 1 if in the calculations but it doesnt seem to work. do u know how to put more than 1 if in the calculation and is it possible for the IF to return only 1 value?

Thanks a bunch

 

[kpyo]

also i am using filemaker pro 6
i was also wondering if there was a possibility to change the value manually in the field that shows the calculation, because i wasnt able to change them even with the define value list

 

[jaco8867]

Have you tried a case statement? Works better than nesting IF statements.

 

[TStriker]

kpyo,

I'm just winging it here, I have not tried this myself but give something like this a whirl:

Case (
IsEmpty ( FirstField ) and IsEmpty ( SecondField ) and IsEmpty ( ThirdField ); "";
not IsEmpty ( FirstField ) and not IsEmpty ( SecondField ) and not IsEmpty ( ThirdField ); "A";
"P"
)

-Striker

 

[kpyo]

thanks guys, i actually decide to just run my script which works 100% instead of busting my head for no reason
thanks for ur help guys