These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#40925 - 10/03/12 10:20 AM Workorder
PrintsPlus Offline
OL Newbie

Registered: 08/22/12
Posts: 17
I have a customer that wants to number a workorder that will be uploaded to PSM Web. He wants to put in a starting number...let's say 3000 an when he puts in the quantity he wants...let's say 1000...he wants the file to print out starting with 03000 and end with 04000. What kind of excel file and code would I need to make this happen

#40938 - 10/04/12 10:35 AM Re: Workorder [Re: PrintsPlus]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4956
Loc: Objectif Lune Montreal

To me, it sounds like you could just make a counter in PrintShop Mail and have it start at 3000. So you could make a variable, and use the following expression:

COUNTER(3000,3000 + RECORD_COUNT(), 1, 5, True)

The counter will start at 3000, and will go up to 3000 + whatever number of records you have. It increments by 1 for every records, and has a minimum of 5 positions. The True means it will add leading zeroes, so you'll get 03000, 03001, etc...

Hope that helps!

Raphaël Lalonde Lefebvre