2: Cut and Stack within Data Merge using a script I’ve made for the task: Episode 9: Cut and Stack Assistant script – YouTube (the script is available from my website https://colecandoo.com/downloads/ for FREE).
Patient number format is >L-999/99999 where L is the first letter of the last name, next 3 digits is the count of number of patients with the same first letter of last name and the last 5 digits is the total count of all patients at the time the patient was entered in the system.
I’d be happy to try and help you. But it would be easier through a different site. Please go to http://www.allexperts.com/user.cgi?m=4&expID=47239&catID=1440 and post a question to me. Please include what you have tried and what is going wrong including any error messages.
We use the auto page numbering trick here, the trick is to do it as spreads. You just make your pages the same size as the ticket with crops and bleeds. Then set up the shell on the master page and place your auto page number where you want your numbers. Each pages is the next number. You can also have two sets of numbers for perforated ticket. You then can use the page start options to add to the numbers and keep the same number of total numbers. For example you would do a new page start after number 99. 0001 to 0099 so it doesn’t add two “0’s” to the front of 100 and you get 00100 when you want 0100. Works great for small quantities, we have done up to 1000+ tickets and once you do it once or twice it is a snap to set up. To avoid having to do 1000 pages just send the tickets in groups. Usually between 25 to 100 at a time works good depending on artwork file size. Just save each time before sending to printer and name the file with what the tickets are. Like “MyTickets-0001-0100.Indd”. Makes it easier to go back if you have a problem. You can even do two rolls of tickets if your using 12 x 18 sheets by flipping the sheet and doing one row along the top and one along the bottom on reverse side. That is if your ticket is single Sided. Two sided tickets are a bit trickier. 🙂
Of course, there are third-party solutions that are available for creating sequentially numbered labels. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting (http://www.payneconsulting.com). This free Word template allows you to easily create as many labels as you need for a specific purpose.
I have several xml files (SMS backup files) I am editing where I want to insert sequential numbering. The number in the id field shown in bold italics below has been replaced with a unique string to allow for a find and replace to be done sequentially giving, e.g. xml a) containing 1 to 25, xml b) containing id’s 26 to 50, xml c) containing id’s 51 to 75 and so on.
So using a field with Global ID, or even a manually created ID that is really long (full user name plus date plus time) is not ideal. With the old paper submittals we received, we had an auto incrementing number preceded by a letter indicating Animal, Plant, Vertebrate or Invertebrate (e.g. A1234). I understand this is not possible in Survey123 because there are multiple users submitting records and you could very easily have overlap in the numbers BUT what if the user name preceded the auto incrementing numbers e.g. taraboswell0001?
Amtrak started offering electronic tickets on all train routes on 30 July 2012. These tickets can be ordered over the internet and printed (as a PDF file), printed at a Quik-Trak kiosk, or at the ticket counter at the station. Electronic tickets can also be held in a smart phone and shown to the conductor using an app.
I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I’m also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.
I have screen shots of what I have in my db, where can I send it to you (it is in word format) so that you can take a look at it to see what I am doing wrong. I took a screen shot of what is listed for the button and I took a screen shot of the text box Job No. I don’t know how to bound anything other than put the code behind the button and putting the Job_No in the code as you stated. I understand what you are saying, but I thought if I put the text box name Job No in the code behind the button then it would be bound to my table with the Job No field. Heeeelllllppppp!!!! I am sorry that I can’t seem to grasp this….but appreciate all of your help!
When the context menu opens, look for the choice Edit Field…. If it doesn’t exist, then your template doesn’t use the SEQ function. If it does exist, click on it. When the next window opens, you should see SEQ in the Advance field properties box. That template definitely uses SEQ.
The code block should not need to be modified (unless you want to implement sorting that can be ascending or descending as mentioned below). The first three parameters of the expression are required. Most of the time only the first two parameters of the expression are all that must be modified.
Tip You can always reset your numbering formats back to Word’s defaults by clicking on the Reset button in the Bullets and Numbering dialog box. You will have to reset each numbering scheme individually.