AnsweredAssumed Answered

Updating multiple fields using scripts

Question asked by mhan on May 29, 2009
Latest reply on May 31, 2009 by LaRetta_1


Updating multiple fields using scripts


In our marketing database we have fields to keep track of calls (and notes on those calls). The fields are set up as Call Date" 1-25 and "Notes" 1-25.  When the database closes, I want a script to scan the "Call Date1" field in all records and if it is newer than "Call Date2," move data from "Call Date1" field to the "Call Date2," move "Call Date2" data to "Call Date3" field, etc., as well as move data from "Note1" to "Notes2", and "Notes2" to "Notes3," etc.


The script(s) I have written thus far only updates one record instead of all the ecords in the database that match this criteria.