AnsweredAssumed Answered

Add a number to a field - update as a group

Question asked by PeterDowns on Mar 15, 2011
Latest reply on Mar 16, 2011 by philmodjunk

Title

Add a number to a field - update as a group

Post

Hi

I have a table with a year field containing

7, 8, 9, 10, 11, 12

I need to rollover these numbers at the end of the year and add 1

so they would become

8, 9, 10, 11, 12, 13

Created a setfield script

Set Field [finance::year; finance::year +1]

Button is located on the layout page where the data is.

 It works fine but only updates one record at a time. I need it to update all the records at once. Any advice would be appreciated.

Cheers

Downsy

Outcomes