I want to be able to Script the following once I have done a find: set a field to have certain text in the whole found set. There are two things I really am unsure about - 1. How to run a script through a found set and 2. Is there a way to prompt a dialogue box to come up that allows the user to enter the text in the dialogue box and then have that be the text that is the "set field" for the set?

Any help would be much appreciated - I am getting pretty desperate!

Thanks, sarah

I forgot to mention - I don't want to REPLACE the text each time - I want to be able to store multiple "sets" (either in a portal or as a repeating field).

Here is what I would do. Create a Global Variable. Have a Custom Dialog pop up with what text they want to enter, use that variable as the field in your Dialog.

Next, create a script that does this.

After Find.

Custom Dialog

If(GlobalVar1 ? "")

Go to the first record

Loop

Set field: Field u want to set: Global Var1

Go to Record Next:Exit after last

End Loop

End If

That should take care of it for you.

If I understand correctly, you want to append text to what is in each record of the found set. You can still use the replace command with the calculation option. If your field is called MyTextField, and you want to append the data NewData, then you would use this as the replace formula:

MyTextField & " " & NewData

You can also have the new data added on separate lines in the field with this formula:

MyTextField &