That's what replace field contents is supposed to do. It updates the specified field for every record in your found set. SInce your script does a show all reords, it will update every record in the table.
I figured it out. I used Set Field instead. I also had an issue where the script trigger was messing with the layout (I had the relatinoship backwards). Finally, I need to not update the renewal date if the date was greater than today since that would just revert the 2013 dates back --- meaning if I ran the script twice it would toggle the values.
It's working fine now.
In stead of replace field contents use "Set Field"
My loop scripts usually look like this:
Go to Record / Request [First]
Set Field [Table::Field;Your Value or Calculation]
Go to Record / Request [Next]- Exit after Last
Right, thanks. I finally figured it out and posted my update above your reply.
Do you know if there's a way to copy and paste the script contents into another program?
When I selected all the script and typed Edit...Copy then moved to TextEdit or some other program, nothing pasted.
What's the trick?
I think one of the tricks is to print the script as an XPS (?) document in windows.
Then you just open that document and copy - paste.
(I'n not sure about the exact name, I'm not in windows right now)