1 Reply Latest reply on May 15, 2015 9:32 PM by philmodjunk

    compare content of two fields in the same layout

    JeffreyCarr

      Title

      compare content of two fields in the same layout

      Post

      Is there a way to compare the data in two different fields in a record? I want to verify that image ID numbers and object accession numbers match in my collection database.

        • 1. Re: compare content of two fields in the same layout
          philmodjunk

          There are probably more than a dozen methods:

          a) a calculation field with an expression such as: If ( Field1 ≠ Field2 ; "message here" )

          b) A conditional format can use table::Field1 ≠ table2::Field2 to change fill colors or even to make layout text visible or invisible

          c) Hide object when (FileMaker 13 or newer) can control an error message's visibility

          d) A Field Validation calculation one either field 1 or 2 or both can use a similar expression

          e) The OnObjectValidate or OnRecordCommit trigger can run a script that checks the values

          and other possibilities exist as well.