3 Replies Latest reply on Jan 22, 2017 4:49 PM by user19752

    text calculation not as expected


      trying to mark a full name with "*" if the member field is valid.  Incorrect result




      If (  IsValid ( Member ) ; "*"  & Husband_Name_First & " & " & Wife_Name & " " & Name_Last ; "" )

        • 1. Re: text calculation not as expected

          What is your definition of "Valid"?


          It might not be the same as FileMaker's definition of the same. "IsValid()" returns true if the value exists and if (for calculation fields, there's no calculation error) and (for fields with special formats such as date/time/timestamp) no data entry error.


          So if your calculation was; 25 / 0, IsValid would return false


          If you entered 13/13/2017 for a date, IsValid would return false

          • 2. Re: text calculation not as expected

            usually the goal of data input is to come back to the data layer with valid results, not coming back with data flagged as invalid. You might want to reconsider your whole data flow.


            As in



              get data into globals

              check data

              exit loop if data ok

            end loop

            • 3. Re: text calculation not as expected

              What data do you enter the Member field for valid members?

              Empty is also "valid" in FM, so if you want to treat empty as "not valid member", IsEmpty ( Member ) would be.

              1 of 1 people found this helpful