creating multiple duplicate records

[Lee Schulman]

I would like to create a script that would allow me to make many duplicate records. I want to be able to select the number of duplicates. At the same time I want each duplicate record to have a file number that increases by 1 with each duplicate.

[Fitch]

1. Make a global number field, gCount

2. Make a number field, FileNumber

3. Make a script:

Loop

. Duplicate Record

. Set Field [FileNumber, FileNumber +1]

. Set Field [gCount, gCount - 1]

. Exit Loop If [gCount = 0]

End Loop

Just fill in your starting FileNumber, and the number of duplicates you want in the gCount field, and away you go.

[Lee Schulman]

When I tried to create the calculations:

Set Field [FileNumber, FileNumber +1]

Set Field [gCount, gCount - 1]

I get an error message that says, "There are too many separators in this functions."

What am I doing wrong?

[Vaughan]

These aren't calculations, they are script steps. This is how they look (more or less) when listed in scriptmaker.

Set Field [FileNumber, FileNumber +1]

In the square brackets, the first "FileNumber" refers to the specified field, the "FileNumber +1" refers to the calculation.

[Lee Schulman]

Thanks! It's working perfectly now.