AnsweredAssumed Answered

Updating but not overwriting fields — Filemaker import from file

Question asked by MatthewSanders on Nov 26, 2013
Latest reply on Nov 27, 2013 by philmodjunk

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

      

      

      

Outcomes