append text to existing text, on set of portal records

[GrantSymon]

Hi,

can anyone suggest the best way to go about, appending text (single word) to the existing text in a field, for a group of records which are showing in a portal?

Any/all help much appreciated! :

Grant

[hociman]

The first thing that comes to mind is to use a script that takes you to the field in question, then executes a calculation that adds the word to the field. If its always the same word, then that should make the calculation easier.

[Lee Smith]

Hi Grant,

Try something like this

Go to Layout [ original layout ]

Go to Record/Request/Page [ First ]

Loop

Set Field [ Concatenate::Donor; Concatenate::Donor & " and YourNewStuff" ]

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

End Loop

HTH

Lee

[GrantSymon]

Hi Lee,

thanks for the reply.

Will that work with records in a Portal? I thought a loop script would be on the 'actual' records themselves.

Grant

[Lee Smith]

Run the script in the file where the data resides.

Lee

[GrantSymon]

Hi Lee,

I answered the question myself. Much simpler than I'd thought. It's a 1-step script.

In the 'Replace' script step, you simply need to choose the field via it's relationship. That's all. The script runs really ... really fast, which is a big surprise.

Thanks anyway,

Grant