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

    Calculate if empty

    RGoyette

      Title

      Calculate if empty

      Post

      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
          philmodjunk
            

          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.