Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

creating multiple duplicate records


This topic is 8184 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Newbies

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8184 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.