Numbering

[Fletch]

I need to create a rule that starts a sequential number sequence. Once it hits 10,000 it needs to restart back to 1 and repeat the sequence. I'm guessing it's a fairly easy JavaScript formula. Maybe not. Any help would be greatly appreciated.

[tou]

create a rule (YOUR RULE NAME) and use the following code. If you sequence number is 10,000 it'll set it to 10,000 due to 0 remainder......

 

var setA = 10000

var a = FusionPro.Composition.inputRecordNumber%setA

 

if (a==0)

a = setA

 

return a

[step]

You want to use the modulus operator:

 

return CurrentRecordNumber() % 10000 || 10000;