Jump to content
You must now use your email address to sign in [click for more info] ×

Publisher automatic sequential numbers


Recommended Posts

Good morning,
I would like to create  raffle tickets for a kindergarten in Affinity Publisher 2.1, for this I need consecutive numbering.

I print several raffle tickets on a DinA4 sheet
Can anyone tell me how to get these sequential numbers automatically? Best if I only have to enter the start number and number of  raffle tickets.

Greetings
Patrick

Edited by Belenus
Link to comment
Share on other sites

Welcome to the forums @Belenus

If you can:

  • show us what each ticket looks like;
  • tell us how many tickets will be on each page;
  • show us how they are to be arranged on the page;
  • tell us where the number should be on each ticket;
  • tell us the format of the numbering system;
  • tell us what number you want to start with;
  • tell us how many tickets you need to create;

...then someone should be able to give you further advice.

Link to comment
Share on other sites

There will be 9 tickets on each page and I will need round about 300 ticket at all.
So I will print 34 pages with tickets.

The number format will be in 100 with beginning 0 so 001 ... 099 ...300

normally I will start with 0 but if we receive more donations, we may have to reprint again, e.g. from 301 image.png.db92465798b88f73bfc14b46f96a9651.png

Link to comment
Share on other sites

Open your graphic with 9 images in Publisher
For each ticket add an art text, I use 888 to set spacing and font size
Data merge manager: select the file
Fields panel: substitute the 888's for the relevant field

image.png.16c37c213a0fa453de42a8b9a2e298c2.png

Generate
Export to pdf

Random sample
image.png.62c68851d53a279c0fd668c0b501b68a.png

If you're using Excel use a cell format 00# to get the leading zeros, save as csv and use that in the datamerge, I've attached a csv that runs from 001 to 999

RaffleTickets.csv

Microsoft Windows 11 Home, Intel i7-1360P 2.20 GHz, 32 GB RAM, 1TB SSD, Intel Iris Xe
Affinity Photo - 24/05/20, Affinity Publisher - 06/12/20, KTM Superduke - 27/09/10

Link to comment
Share on other sites

  • Staff

If you create a paragraph with these options

image.png

It will get sequentially numbered throughout your document.

You can create an empty paragraph in that style and it will give you the numbers.

If you have Designer and StudioLink enabled I would create your ticket in a Symbol and paste it multiple times on the page, alternatively just copy and paste.

Use a master to create a full page of tickets.

Make as many pages as you need and apply the master to all of them.

If you need to make extra tickets either add more pages and just print the pages starting after the ones you already printed or change the value of 'Start numbering at'

Hope that helps,

Mark

 

Link to comment
Share on other sites

5 hours ago, Belenus said:

There will be 9 tickets on each page and I will need round about 300 ticket at all.
So I will print 34 pages with tickets.

The number format will be in 100 with beginning 0 so 001 ... 099 ...300

No need to use the Data Merge.

Make a master page with the design. Make nine linked Frame Text Text Frames for the the Ticket No. Make a Paragraph Style (named Ticket No.) with the Flow setting for Start set to Start in new Frame.

Use a Spreadsheet to make the 300 numbers formatted like you want. Copy them and paste them into the Publisher Document or a Text document. Apply the Ticket No. Paragraph style to the text flow.

 

Mac Pro (Late 2013) Mac OS 12.7.2 
Affinity Designer 2.3.1 | Affinity Photo 2.3.1 | Affinity Publisher 2.3.1 | Beta versions as they appear.

I have never mastered color management, period, so I cannot help with that.

Link to comment
Share on other sites

47 minutes ago, Old Bruce said:

No need to use the Data Merge.

Make a master page with the design.

and

4 hours ago, Mark Daniel said:

If you create a paragraph with these options

image.png

It will get sequentially numbered throughout your document.

You can create an empty paragraph in that style and it will give you the numbers.

 

The proposed method by Mark Daniel is the most simple.

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.