Taking contents of a field and then adding additional information to the existing contents

[James Gill]

I’m running into issues with a script I’ve written that takes the contents of a field and then adds additional information to the existing contents.

I am populating a single field from multiple records using the substitute and List commands. When the user puts a report up for review, a script is run that captures the contents of a field and assigns it to a variable. The script then replaces the contents of the field with a set field command using the Substitute and List commands and then tacks on the variable to the end of the contents.

This works, but the problem is that every time a report is reviewed and submitted (this can happen multiple times) the contents of the field are copied and pasted. This results in many, many copies of the same contents of the field if a report is approved multiple times.

Is there a way that I can insure that only new values are added to this field?

Edited August 4, 2010 by Guest

[bruceR]

Other issues need to be addressed but you should pretty much NEVER be using copy and paste in scripts. Use set field.

[bruceR]

If the append script is running every time - and it should NOT run every time - then when should it run? I'm not being facetious. What are the available and desired criteria for when this should be triggered?