Add Text without Replacing

[DianeK]

I would like to know if there is an easy way to add text in a notes field to all of a found subset of records without replacing text that is already there. I've seen a few scripts here in the forum, but it's very confusing.

I've seen this:

Replace Field Contents [ YourField; Case ( not IsEmpty

( YourField ); YourField & "(.jpg)" ) ]

And this:

Find the records you want to modify, and do Replace Field Contents… with calculated result =

YourField & ¶ & "New Keyword"

[Peter (duksis3)]

If you do this via script (different staring content in field):

Loop through finded records and on each

Set field (YourField) = (YourField)&","&"Your text"

or

Set field (YourField) = (YourField)&","&Field with your text.

[DianeK]

Thanks very much for your reply. Is using a script the only way to accomplish this? I wish there was an "ADD to field contents" button.

I find the scripting very confusing -- need hand-holding through the process as I've never done it. A real world example would help.

[bruceR]

Thanks very much for your reply. Is using a script the only way to accomplish this? I wish there was an "ADD to field contents" button.

I find the scripting very confusing -- need hand-holding through the process as I've never done it. A real world example would help.

In your FileMaker application folder, there is a folder "English Extras" and inside that, a folder "Electronic Documentation". Inside that is a tutorial file.

[bcooney]

Honestly, anytime I see the request to append data to an existing text field, it points to the need for a new child table. That is, a Notes table, related to the parent table by parent ID. Then, each occurrence of a note is a new related note record in the Notes table. This will allow you to also capture the Note record's created date/time, the Account Created, etc.