AnsweredAssumed Answered

Is there a way to append text to a matching record's field when importing a file?

Question asked by jake.swift on Oct 13, 2017
Latest reply on Oct 16, 2017 by beverly

For example, let's say I have a comments field for unique record 1234.  Let's say that it has "XXX" stored in the comments field for that record.  Later on I'm going to import a file using the "Update matching records in found set" option.  The imported file contains a matching record that has "YYY" stored in its comments field.

 

As of right now, FileMaker will simply update the field with the new comment.  This overwrites the "XXX" comment.  I want to append the "YYY" information to the comments field instead of updating/overwriting.

 

Is this possible?  Any advice/suggestions are appreciated!!

Outcomes