I make the design with as many up as I need on the master page, linking the frames where the numbers will go. Then I make the list using Excel, copy paste to ID and apply a paragraph style with "start in next frame" option. Click the outbox on the pasted text to get a loaded cursor and delete the frame. Then just shift-click over the first textframe on a live page to have as many "tickets" added as needed automatically.
Some drawbacks to this feature are that you lose a little control when you are typing. Word formats for you and some users do not like this. Also, on certain items, you will get a number when you do not expect or need one. For example, you have an attorney whose name begins with an initial (A. George Smith). When you type the name and press ENTER, the first initial "A." converts to an automatic number.
I created something like this for a demo and didn't have to use a script. If I remember correctly, I leveraged Workflow. Essentially, the form submission would trigger a very simple workflow that would look at the current counter value on a database table and increment it by 1. The next form would then start with a lookup that would grab that counter and put it into a read-only (or hidden) field. Rinse and repeat.
Next we will look at scenario 2. The variation here is that Apex wants to start each year with anew sequence of numbers. Also, they want to include the year when displaying this number. We still use a DMax, but we need to add criteria to determine the year. So Apex needs to have a field in their table that indicates the date. Generally, such inquiries will have a date/time stamp to indicate when received or the user will input the date and time. So we will assume there is a field in record called InquiryDate. We will also add an Integer field named Sequence. On the form we will add a control bound to Sequence, but set its Visible property to No. The line of code will look like this:
Tip  Follow the same steps (above) to create Request for Production or Request for Admissions. The only difference would be in Step 3, you would change the "rog" to "rpf" or "rfa". This will keep unique numbering schemes running in the same document. Therefore, you could have an Interrogatory No.1 as well as Request for Production No.1. Keep in mind that if you cut, copy or paste sequence codes, you'll need to select them and press F9 to update the field codes. They do not update automatically.
 I'm looking for a script for Laserfiche Forms that will query a database and pull the next number in sequence and display it as the unique identifier for this document.  Once this number has been used, the number should not be used again.  This is similar to what the Submission ID is, but from what I can gather, this number is assigned after the submission takes place.  
The new SQL stored procedure lookup rules in Forms 9.1 make doing something like this possible. The example in the online help shows how to use a stored procedure to auto-append an incrementing number from the database to a form when it loads, which might solve some of your problems. However, the number is incremented after the form loads (not when it is submitted), so that might not exactly fit your needs. Here's the link to the correct page of the online help.
All I want to know is, how do you link fields, like {SEQ}, to a style – so that if I select/apply style “Figure Caption” (my style, I also have “Table Caption”), I get not just the attributes of the style (what it looks like, where it is on the page etc.) but I get a chapter (or section) number + a sequence number added, (e.g. “2-3”). I know about STYLEREF and SEQ Figure # and/or calling a section number (if required) – but I can’t find out how to take the simple and to me obvious step to have sequential numbering (prefixed with either “Figure” or “Table”) attached to my Figure Caption style. It all seems to be a two-step process: (i) select the style, (ii) select the numbering. I want to do both at style level. I want to see/get (e.g.) “Figure 2-3: Linking figure numbering to styles” just by applying my “Figure Caption” style to my figure caption text “Linking figure numbering to styles”. Please, only tell me how to do that, how to link chapter/sequence numbering via a style – i.e. in just one step – applying the style.
Scott, I was able to try this as I assumed that is what I needed to do. It does not work. First, the current macro for that button is a Save Record, Close Window operation. How could I keep this and also add Code? If I just add a new button to the form and under the On Click Event put the code you suggested, I get a compile error of “method or data member not found” and ” .txtPROJECT” is highlighted. The actual field is “PROJECT ID#” and it is a long integer number. Entry I have is: Private Sub Command88_Click()
Michelle Castle began writing professionally in 2005. She has written technology news and tutorials for consumers, brochure and web copy for the Ehlers-Danlos National Foundation, and promotional materials for religious nonprofits including the International Pentecostal Holiness Church. Michelle has a Bachelor of Arts in English from Oklahoma State University.

Erica Gamet has been involved in the graphics industry for an unbelievable 30 years! She is a speaker, writer, and trainer, focusing on Adobe InDesign and Illustrator, Apple Keynote and iBooks Author, and other print- and production-related topics. She is a regular presence at CreativePro Week’s PePcon and InDesign Conferences, and has spoken at ebookcraft in Canada and Making Design in Norway. You can find Erica’s online tutorials at CreativeLive and through her YouTube channel. When she isn’t at her computer, she can be found exploring her new homebase of Seattle and the greater Pacific Northwest.
So if you encountered this problem, then you didn’t follow the instructions completely (which is OK) and appear to be automatically generating the number whenever the record is accessed. If that’s the case, then you are risking duplication because you are not saving the generated number immediately. Rather then try to test if a number already exists as you seem to be doing, you should not automatically generate the number, but trigger the generation from some action in the form.
Before you complete the merge, preview the merge results to make sure that the tracking numbers will display as you want them to in your publications. You can preview the merge in two ways: While you are refining the layout to review the layout of the individual coupon or gift certificate, or when you are getting ready to print, to preview the arrangement of coupons or gift certificates on the printed sheet.

Hi – are you creating your own tickets using the instructions on this page? If so, you can of course change the font and everything else in your Word document. If you are using the Raffle Ticket Creator app (app.raffleticketcreator.com) then you can’t change the font size … you’ll just need to tinker with the exact words that you are including in order to get them to fit on the page. Hope that helps!

In a legal document, it's rare for every paragraph in the document to be numbered. Usually, you change between numbered paragraphs and non-numbered (plain) paragraphs of text. When Word sees you switching between these types of formats, it usually tries to help by restarting your numbered list back at "1" (or the first value of your list, such as "A"). There are a few different ways to make the number follow the last number of your paragraphs. In Word, this is called Continue from Previous List.
In summary, paragraph numbering is really just an exercise in logic, and this blog post is showing the numbering styles for a very specific project. Your project may be similar, but not exactly the same. You just need to think though the levels and how you want to restart the numbers. I do my best to think it through correctly the first time, set it up, and then try as hard as I can to break it, so that I can find my errors. The good news is that once you get your numbers working, you shouldn’t ever have to think about it again.
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!
LION has an economy line, standard-duty numbering machines in both the 5 wheel & the 6 wheel model. As with the heavy-duty line, these automatic numbering machines are also made from one-piece hardened die-cast metal frame and wheels to assure trouble free operation. This self inking numbering machine is ideal for sequential numbering operations to use as a date and number stamp, serial number stamp, inspection stamp and etc. Best choice for the budget conscious users looking for standard quality, durability and low cost.
OK I found the ControlSource property but it is on the Job No text box, do I enter the code there or am I entering my code on the button I created to save and get new number? If I put it behind the button, when I open the form it goes to the first record so I go to the last record and hit save get new number button and it gives me the number 1……Is it because when I open the form it goes to the first record and not a new record????
Since Word 2000 applies outline numbering by default, as you press TAB or SHIFT+TAB in a numbered list, you are moved to the next or previous outline level. If you are in a numbered list that has outline numbering generated by the method described in the previous exercise, when you choose Bullets and Numbering from the Format menu (or alternate-click a portion of the numbered list), the Numbered tab appears on the Bullets and Numbering dialog box. However, if you first select the entire list and choose Bullets and Numbering from the Format menu, the Outline Numbered tab from the Bullets and Numbering dialog box is selected.

This difference is not simply a case of syntax. In order to provide a large workspace, conventional spreadsheets extend a table in X and Y to form a very large grid – ideally infinite, but normally limited to some smaller dimension.[N 2] Some of these cells, selected by the user, hold data. Data is manipulated using formulas, which are placed in other cells in the same sheet and output their results back into the formula cell’s display. The rest of the sheet is “sparse”, currently unused.[5] Sheets often grow very complex with input data, intermediate values from formulas and output areas, separated by blank areas. In order to manage this complexity, Excel allows one to hide data that is not of interest,[6] often intermediate values. Quattro Pro commonly introduced the idea of multiple sheets in a single book, allowing further subdivision of the data.
Changing the numbering display affects how pages are indicated in the InDesign document, as in the Pages panel and in the page box at the bottom of a document window. The numbering display also affects how you specify page ranges when printing and exporting the document. However, the numbering display does not change the appearance of page numbers on document pages.
A subsequence of a given sequence is a sequence formed from the given sequence by deleting some of the elements without disturbing the relative positions of the remaining elements. For instance, the sequence of positive even integers (2, 4, 6, ...) is a subsequence of the positive integers (1, 2, 3, ...). The positions of some elements change when other elements are deleted. However, the relative positions are preserved.
I normally use "Data Merge" in InDesign and use Excel (or something like it) to generate the list of numbers for me. You would copy the numbers into a text file so that InDesign can read them as the merge data source. Note that you would have one ticket on the page and then let InDesign set the other tickets on the page (you can tell the Data Merge control panel about spacing).
I thought I'd try and just create one decal and use the print merge feature but I don't print from my workstation. I create the design in X7 then export it to a RIP Station for print. I thought I'd just do the print merge and print as pdf just to get the numbers without typing them. That gets me all the numbers in sequence but all on 500 separate pages.

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. :-)


I need 2 copies to be printed each time I print from a certain file. Is there any way to save this command so I don't have to change the number of copies each time I print? Hi you could record a macro while doing this manually and assign a shortcut or button to this recorded macro -- Regards Frank Kabel Frankfurt, Germany Hebert45 wrote: > I need 2 copies to be printed each time I print from a certain file. > Is there any way to save this command so I don't have to change the > number of copies each time I print? ...
Tip  Follow the same steps (above) to create Request for Production or Request for Admissions. The only difference would be in Step 3, you would change the "rog" to "rpf" or "rfa". This will keep unique numbering schemes running in the same document. Therefore, you could have an Interrogatory No.1 as well as Request for Production No.1. Keep in mind that if you cut, copy or paste sequence codes, you'll need to select them and press F9 to update the field codes. They do not update automatically.
Hi All, I am working on a YTD Sales report. I would like to know if I can create a cell in a query that will be a squential number. Starting with 1 on up. If so how would I do this? Report would look something like: Num Customer YTD Sales 1 Bobs Sales 495,000 2 Denny's 395,000 3 Biffs Supply 390,000 4.... -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com You can use a text box in the report: Control Source: =1 Running Sum: Over All -- Duane Hookom Microsoft Access MVP "mattc66 via AccessMo...
LION also carries a heavy-duty, 6 wheel automatic numbering machine with rubber faced wheels. The rubber wheels work great for metal marking and plastic marking when used with LION fast dry ink. As with the other LION numbering machines, this machine is made in Japan with precision crafted one-piece hardened steel frame with all metal interior construction. LION machines will provide years of reliable use. Ideal for sequential numbering operations to use as a date and number stamp, serial number stamp, an inspection stamp and etc. sequential numbering in publisher
×