“sequential invoice numbering in word +consecutive numbering in indesign cs6”

Have you ever needed to number a variety of text objects in your drawing file? It’s so tedious to do this manually! In this video tip from Cadalyst and Lynn Allen, you’ll see how to sequentially number selected text objects with the AutoCAD Express Tool TCount instead.

Let’s take an example of cashier who receives vouchers from different departments which bear different serial numbers. Thus it is not possible for him to arrange such documents in a series. This can pose serious problems if one of the vouchers get missing. In order to make sure that all the vouchers are present cashier will give his own numbering to each document he receives following a particular sequence. And later he will use his own numbering system to track different documents. Suppose the following scenario he faced:

Auto increment fields (and ObjectIDs): In common database jargon, some people solve the problem with what is known as Auto Increment fields. Through an Auto Increment field, a database is able to assign a new and unique identifier (typically a number) to every new record added into a table.  This works well, because it does not matter from where you add a new record: when it gets to the database it will be assigned a new identifier… a new ‘Ticket Number’.

A common practice for increasing revenue from ticket sales is to offer bulk sales of tickets, e.g., $10 per single ticket or $25 for three tickets, although this practice is illegal in some countries. In many places raffles are only legal for registered nonprofits.[citation needed] Players tend to spend more money on bulk tickets believing they have a much better chance of winning. Since the tickets cost little to produce, and the prize expense has been set, the number of tickets sold creates little or no additional cost for the raffle holders.

So? You are storing 2 sequential numbers then. One a number per last initial, the other an overall number. So you are storing those 2 numbers. Those numbers do not change once generated. There is NO need to redundantly store the concatenated full ID.

This will work OK for a small set of data, but the more data there is, the more intensive the subquery becomes, and it must be called repeatedly for each row. This is one of those rare cases where doing it in VBA is faster than doing it in SQL — after all, row numbering is fundamentally iterative, not set-based which just goes against the grain of what SQL was designed to do – solve a problem in a set-based fashion, non-iterative fashion.

Finally,you said: “I’m not sure how the display would work as far as searching for specific Artifact IDs in the future.”. This will not be a problem. The best solution is to use a combobox to select the Artifact ID. The relevant properties of that combo would be:

document; ClientCode, which is a 5 character code that identifies the client and CaseNumber, which is an alpha-numeric code assigned to the case. Since the Case Number is unique to the Client, we only need to set the criteria in the DMax for the case number. We will also need to add an Integer field named

Note  All of the controls in the dialog box are either blank or grayed out because by default, the font formatting of the number follows the font formatting of the text that comes after-unless you explicitly declare exceptions as in the next step.

After you set up your list of tracking numbers in the data source and design your publication, you are ready to merge your list of tracking numbers with your publication to create a batch of gift certificates or coupons that each displays a unique tracking number.

If your tickets don’t require sequential numbering, you can find more templates at RaffleTicketTemplates.org. The tickets there are more the standard fare. They have different sizes, layouts, and downloads for both Microsoft Word and Corel Draw.

Note  Most of the formatting to numbered lists needs to be done from within the Bullets & Numbering dialog box. Otherwise, any change you make will only apply to the one paragraph instead of the entire list. The following table describes each of the items in the Customize dialog box and the function of each feature.

John, Sorry for the delay, but I was away last week with limited Internet access. I assumed if you had a Save button, you would know how to put code behind it. To see the code behind a button, Select the button in Form Design Mode and open the Properties Dialog (Right click and select properties), on the Events tab there should be something in the On Click event of the button. If you click the Ellipses […] next to the event, it will open Code Builder where you can enter the code.

Copyright © 2018 by Office Depot, Inc. All rights reserved.  Prices shown are in U.S. Dollars. Please login for your pricing.  Prices are subject to change. All use of the site is subject to the Terms of Use. Prices and offers on www.officedepot.com may not apply to purchases made on business.officedepot.com. See Terms of Use details.

If you have already developed a set of specific code numbers that you want to use to track and categorize customer responses, you can type these numbers into a column of the data source that you plan to use for the mail merge.

To get started with a blank template, simply determine the number of rows and columns you want page page. It works rather like the “table” creator on Word. For this example, I a 2×4 (two columns, four rows) layout.

I get an error with this code but it is something I literally copied from a post in this thread where you said it works every time and simply replaced the names of fields and tables with those of my project.

Start writing the text for the numbers. In this case, I typed ticket “nr.” Leave any numbers out. This will be filled in by the data file. As you can see, the text box wraps around the full tickets with crop marks.

For example, if we have a list with 10 items and a user adds a new number 3, then the existing number 3 should equal 4, the existing number 5 should equal 6 and a new number 11 will be added. In the same way that if the users deletes 3, then the existing number 4 should equal 3. I am sure we can achieve something using workflow or InfoPath.

Comments

  1. Maureen

    To get started with a blank template, simply determine the number of rows and columns you want page page. It works rather like the “table” creator on Word. For this example, I chose a 2×4 (two columns, four rows) layout.
    For larger numbers, increase the interval between each sequence and use that number of pages. What I suggested is based on 34 pages of 6 so the interval is 34. For each additional page of 6 you would increase that interval between the starting numbers by one.
    Now I’m having multiple problems even if i see the sequential numbering in the form view under transaction_ID field, it does not “save” those numbers in the transaction_ID in passengertable but it shows up in the form view (passengerform).
    Using the current time is certainly going to give us a unique number for the device you are on, but this does not mean that it will be unique across all devices capturing data. First of all, there may be people creating new survey at exactly the same second.  If working across multiple time zones, the chances of coincident numbers increase.
    Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I’d have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I’ve used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also “Single-sided” cos my default of duplex printing had come up). But TA-DA!  All is fine now. Thanks very much again.

Leave a Reply

Your email address will not be published. Required fields are marked *