help with numbering script

I have a numbering job

this event has is a auction that has 50 tables with 8 chairs at each table so i need a script that will number like

1-001

1-002

1-003

1-004

1-005

1-006

1-007

1-008

2-001

2-002

2-003

2-004

2-005

2-006

2-007

2-008

up to 50-008

thanks for any help i can get

var result = "";
for (var table = 1; table <= 50; table++)
   for (var seat = 1; seat <= 8; seat++)
       result += table + "-00" + seat + "<br>\n";
return result;

Hi there,

Just looking at this post for assistance with a very similar job. It is almost what I need.

However, when I use the code you supplied Dan I just get a long list of the numbers all in one cell, I need them to go in to individual cells multiple times per page. Also I require leading zeros at the beginning of the first number, when I tried to edit the code it gives me an error.

Any help would be greatly received.

Cheers

Paul

Hi there,

Been looking at this post for a guide to a numbering job I have to do this week.

It is almost what I need but I have 2 issues with it.

1) I need lead zeros at the front of both numbers not just the last.

2) When I use the above code I get a very long list of the numbers, I need them as individual records for use in 5 places per sheet.

Can anyone help me please.

Paul

1) I need lead zeros at the front of both numbers not just the last.

You can use the FormatNumber function to do that. Something like:

result += FormatNumber("000", table) + "-" + FormatNumber("000", seat);

2) When I use the above code I get a very long list of the numbers, I need them as individual records for use in 5 places per sheet.

Then instead of using JavaScript to drive the counting, you want to use a ticketing-type job which leverages FusionPro.Composition.repeatRecordNumber, as in this example:

http://forums.pti.com/showthread.php?t=391