1 Reply Latest reply on Apr 14, 2009 8:14 AM by philmodjunk

    Calculate if empty



      Calculate if empty


      I am importing information via an ODBC datasource.  One field, PERSON_ID, is used to look up and link other information.  The problem is this:  there are some entries in the original database where the field is blank (depending on whether a person has been validated).  This causes me a problem later, and I am wondering if there is a way to define the FileMaker Pro field to automatically generate a PERSON_ID for any instance where the field is empty after the initial import.

        • 1. Re: Calculate if empty

          You might be able to set an Auto-Enter option for your field:


          If(isempty(table::field),Expression to assign a value, table::field)


          You'd need to enable auto-entry operations during import.


          I haven't tested this, but I think it or a variation of it may work for you.