Adding text to a found set

[Madwolfie]

Does anyone know how to add text to a found set of records approx 1700 of them ? The field I want to add the new text to, already has text in it that I want to keep. I am sure this was possible in the last DB I used.

Cheers

[Vaughan]

This can be done with a Looped Set Field, or a Replace with calculated Result. The calculation would be

TextField & " " & "newtext"

[transpower]

From FM Help:

1. If necessary, find, omit, or sort the records in the database file.

2. In Browse mode, in the current record, select the contents of the field you want to replace.

3. If you're replacing data with a constant value (instead of serialized numbers or a calculated result), type the value.

4. Choose Records menu > Replace Field Contents.

5. In the Replace Contents dialog box, select an option:

To replace each value with

Select

The value in the currently selected field

Replace with <value>. FileMaker Pro replaces the contents of the field for the entire found set.

A serialized number

Replace with serial numbers, then type the starting value for the serial numbers in Initial value, and the incremental value in Increment by.

If the field is defined to automatically enter a serial number, you can select Update serial number in Entry Options to reset the next value in the Options for Field dialog box.

A calculated value

Replace with calculated result, then click Specify. In the Specify Calculation dialog box, enter the calculation you want evaluated. (The result must match the field type of the replaced field.) Click OK.

6. Click Replace.

[Madwolfie]

Thanks for all the help - but I must have explained it badly. I want to ADD some text to a certain field of the found set NOT replace the text. My script run from a button is a 'InsertCalculatedResult' (below) from Vaughan, it works with a click for 1 record, I now need to add a bit more to get it do all of the found set.

Insert calculated Result ["Mailings sent","" "&", X04mailing""]

Where "Mailings Sent" is the field I wish to insert the new text into, the new text is ", X04mailing"

Hope you can help

Cheers

[transpower]

See step 5 above--A calculated value.

[Madwolfie]

Hey, did I blink ? Thanks very much - that has saved hours of work. Took me a while to get it just right, but yes it worked fine.

Cheers