3 Replies Latest reply on Nov 27, 2013 8:35 AM by philmodjunk

    Updating but not overwriting fields — Filemaker import from file

    MatthewSanders

      Title

      Updating but not overwriting fields — Filemaker import from file

      Post

           I'm importing records from an .xls file.  The data is coming into all my fields fine, but when I update existing records with the data from the source file, it automatically overwrites the data for that field in the existing record.  I want to add incoming data to the existing data, merging them.  

           How do I import the data and just add it to the field, or merge with the existing field data?

           To illustrate, I'm importing customer orders.  I want Bill's order history to be updated but not overwritten.  So when I import the second entry, I want to see that Bob's record reflects that he has, over time, ordered all 4 shirts.

           ----------

           Date: 12/1/13

           Name: Bill Bobson

           Order: Shirt1 Shirt12

           -----------

           Date: 12/4/13

           Name: Bill Bobson

           Order: Shirt5 Shirt7