Adding text to a field without replacing the old one

[Schabowicz]

Is there a way to have FileMaker Pro add text (a word or phrase) to a field across a found set of records? What I wish to do is similar to what the Replace Field Contents function does, except that instead of replacing the contents of the field, I wish to add the new text to what is already in the field. Do I need to write any kind of a scrip to perform this function? If so can you guide me how to do it?

 

[Lee Smith]

A word of warning, you can not UNDO a Replace so you should test out the answers on a copy or a demo of the file. Do not use the original file until you have it working the way you want.

 

This will replace everything in your textField in your Found Set with your new concatenation. 

 

Put the cursor in your textField and use this replace with calculated result.

 

textField  & " new text too" Note: your new text

 

You can also use a script to loop through a Found Set records.

[Russell Barlow]

You can concatenate the current value of the field using replace field contents.

 

currentFieldName & "textadded"

 

 

"textadded" & currentFieldName

[Lee Smith]

Here is an example of a script.

 

 

Go to Record/Request/Page [ First ]

Loop

    Set Field [ textField; textField & " this is your new text" ]

    Go to Record/Request/Page [ Next; Exit after last ]

End Loop 

 

textField =  your field name. and the field will have the TO name in front of it like. i.e. MyTO_name::textField.

Edited November 20, 2012 by Lee Smith
change the field name

[Schabowicz]

Thank you very much for your advice and replies Russel and Lee. I am afraid I am an absolute beginner to FM so need more time to implement the scipt and make my program work as I wish.

[Lee Smith]

Thank you very much for your advice and replies Russel and Lee. I am afraid I am an absolute beginner to FM so need more time to implement the scipt and make my program work as I wish.

 

I amended the field name in my post (Replace::textField to textField). I think my using the word Replace as my TO Name could be misleading you. See my added instructions.