help with numbering script

[MikeCarenter]

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

[Dan Korn]

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

[In2print]

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

Edited August 25, 2011 by In2print

[In2print]

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

[Dan Korn]

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