Repeating Sequential Ranges Rule

[LyndaEngelage]

I need a rule for Sequential numbering in ranges of 6 increments that repeats until a specified range ending (1001-146000). I will use a Overflow template until the pages are filled with the repeating range. How do I repeat the rule on the same page until it's filled within the text box?



for example:


1001-1006
1007-1012
1013-1018
etc. filling the rest of the page down, then overflow to the next page and continue where it left off.



My current Sequential Incremental Rule looks like this:


var start_number = 1001;
var increment = 6;

var crn = CurrentRecordNumber() -1;
var set_start = start_number +crn +(crn * increment);
var set_end = set_start + increment;

return set_start + "-" + set_end

[ThomasLewis]

Give this a shot:

var start_number = 1001;
var largest_number = 146000;
var range = 5;
var sequence = "";

while (start_number +range <= largest_number)
{
    sequence += start_number + "-" + (start_number +range) + '<br>';
    start_number += (range +1);
}

return sequence;

[LyndaEngelage]

Thomas,


Thank you for your reply. That worked great! but I had to change the range to 4 to make it work the range I needed. For some reason when I compose the job all the pages turn out the same and not continuous. I have the Text frame on the body page marked as overflow and the 2nd page set up as an Overflow template. I have attached my collected file. Can you take a look and see what I'm not doing correctly?

[ThomasLewis]

You need to remove the rule from the text frame on the overflow page, then in the text frame properties palatte, turn on the checkbox that says "Overflow To".

Also in your Composition Settings under Input, change the Record Range to All or 1 to 1.

[LyndaEngelage]

Thank you very much. It works great now. I was missing the checked box on the Overflow template. I appreciate your help!!

[LyndaEngelage]

I ran into a snag.


I need to edit the rule to include tabs, but when I do and send to compose the server gets to 95% done and just hangs. I let it set all night but it didn't complete. It looks fine in the preview. Is there an easier or more efficient way to put tab stops in the rule. I have the tab stops defined in the text editor, under the tabs. I have also attached my revised setup with a screenshot of the preview.



Here's my rule with the tab tags added:


var start_number = 6001;
var largest_number = 87000;
var range = 4;
var sequence = "";

while (start_number +range <= largest_number)
{
sequence += start_number + "<t>-<t>" + (start_number +range) + '<br>' + "<t>";
start_number += (range +1);
}

return sequence;

[LyndaEngelage]

Just a Note…


To try to simplify things, I tried to make two separate rules to overflow (getting rid of the tabs), but apparently you can't Overflow to two text frames onto the "Overflow" template Page.

[ThomasLewis]

I am having the same issues at 95% I think the amount of overflow going on just may be too much to handle.

I took a different approach. Removed the overflow completely and moved everything into OnRecordStart. Take a look.

[LyndaEngelage]

That worked perfectly, thank you very much!!