Help with performing an action on a field
I'm new to FileMaker mac,coming from MS Access...What I'm trying to do is this:
I have a field "To be done" that I fill with 0 for "no tasks" or 1 for "there are tasks" . I have another field, "Solved by". What I want is that when the field "Solved by" has anything in it (is not empty) the field "To be done"automatically turns to 0. How can I do this?
I assume both fields are in the same table. That said, you can configure ToBeDone to be a Calculation field that stores the following value:
If ( IsEmpty ( SolvedBy ) ; 1 ; 0 )
That reads logically as this:
"If SolvedBy is empty, set the field to 1, otherwise set it to 0."