So if you need 150 labels for one customer, can they be numbered 1...150 to provide that "unique number" on each label.
I can assume that you have a table of customer contact info. Then you can define a related table for printing labels that links by a customer ID field to the original table of contact info. That allows you to set up a labels layout for your particular layout format and place fields from the now related contacts table to show the needed contact info on the label. Add a number field defined in your labels table to provide the unique number.
Then you can specify the number of labels in a field on the contacts layout and use a looping script to create the needed set of labels records. The loop can increment the number field in the Labels table to produce a unique number starting with 1 for the first label for that customer.
Once you have printed your labels, you can "clean house" by deleting the labels records.
Thanks for your answer! I will try this now, never thought about looping script.
Essentially you would be creating 150 Records in the labels table, but then deleting them after it's done so no wasted space.
There is a performance issue with this script, I am remotely hosting my filemaker which makes response time slow down, particularly when it comes to creating lots of records via online.
I can't remember the script, but it's something along the lines, you have a field with the number of boxes you wish to create. Make a script with create record, with an auto enter serial when the labels are created. You then need a loop script, which means it will keep looping until it meets the number to stop at. End loop if. Was the script. Then a pause script, is required. Then you are on the layout and do what you want to do. i.e. print.. etc.
You will then need to create a delete all records script. then close.
You will need a table to create new record labels to. Then create a relationship for that table.
Beware this is a slow script, in my opinion. Could take 30 Seconds - 1 minute to create 400 records. Depends on the internet speed.
The method I opted for but means more work, but much quicker was creating label layouts from 1 to 300 boxes manually. 6 Labels to a box, then simply duplicate the layout as much as you need and change the numbers. Make sure to take the time to get the label positioning perfect, as any flaws will be duplicated throughout.
You can create a script to print multiple layouts at once for shortcuts.
It may work for you but if you are hosting locally, probably the create records script would be best for you and easier to do.