AnsweredAssumed Answered

Script to move text from one field to another?

Question asked by sk on Feb 15, 2011
Latest reply on Feb 15, 2011 by philmodjunk

Title

Script to move text from one field to another?

Post

Hi,

I need a script that will let me move the data from a "Color" field into a "Description" field against a set of found records. I would need to insert a comma and a space between the fields, so it is added to the existing data in the description field. I tried the Replace Field Contents with a calculation of 

Description = Description & ", " & Color

but I have to create the calculation everytime for every found set of records and I also want to clear the "Color" field once the data from it is moved to the Description field. I'm not to clear on the looping script step.

Any help is appreciated!

Outcomes