Skip to main content
SirSpeedy Meadow Lands
SirSpeedy Meadow Lands
Participating Frequently
October 3, 2019
Question

Static Numbering for NCR Forms in InDesign

  • October 3, 2019
  • 2 replies
  • 4567 views

I am trying to figure out how to apply numbering to a form (an Invoice) in InDesign and print digitally. (The numbering I'm talking about would be equivalent to crash numbering using traditional printing methods.) I have absolutely no clue how to set up the numbering, nor how to make sure that when I print I get the numbers printed on each copy of the NCR. Any help is appreciated.

    2 replies

    SirSpeedy Meadow Lands
    SirSpeedy Meadow LandsAuthor
    Participating Frequently
    October 4, 2019

    Thanks but never mind. I figured it out using a data merge from an excel spreadsheet.

    F
    Fast5F97
    Participant
    October 19, 2020

    Hi,

    Would you mind sharing some info about how you solved this problem?

      SirSpeedy Meadow Lands
      SirSpeedy Meadow LandsAuthor
      Participating Frequently
      October 19, 2020

      Create a MS Excel Spreadsheet. On the top row make column headers alphabetic -a-b-c, etc. Make your columns beginning in row 2 start with the numbers you want to insert first. Click and drag down to what should be the last number for that column.For instance, if your going 1-500, you'll actually drag down to select everything to and including row 501. Go up to the right and select Fill, Series and step by one. That will fill the entire column with you numbers.

       

      Save the file as an excel csv file or Macintosh csv, whichever system you're running.

       

      Open InDesign and select "data merge" and choose the CSV file you created. Create a textbox on the InDesign document and then click on the merged data selection. It will fill that box with an <<a>>, click Preview and it will show the number. If doing a multiple-up print, create additional text boxes as necessary and click on the different column headers from your csv document.

       

      Select "create merged document" and InDesign will create the the sequentially numbered document for you, then all you gotta do is print.

        M
        Migintosh
        Legend
        October 3, 2019

        Are you looking to have (for example) 100 different pages, each with a different number in one document and you print the one you need when you need it, or a single-page document, that updates the number each time you use it? The first is what you would do if you were printing them in advance, and I can help you with that, but the other is out of my experience, so I'm not sure how you would do it, but there's probably someone who will help you with that on the forum.

        SirSpeedy Meadow Lands
        SirSpeedy Meadow LandsAuthor
        Participating Frequently
        October 4, 2019
        I am printing invoices that have a pre-assigned number on them. Numbers will run 11500-11999. It is on NCR paper (Non-Carbon Repeating) 2-part, white/yellow. (So, each number has to print twice.) I just can't figure out how to get that sequential numbering inserted into the already created document.
        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices