Publisher automatic sequential numbers

[Belenus]

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 June 23, 2023 by Belenus

[GarryP]

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.

[Belenus]

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

[David in Яuislip]

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

Generate
Export to pdf

Random sample

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

[Mark Daniel]

If you create a paragraph with these options

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

 

[Belenus]

Thank you for your help!

I used David in Яuislip variant and its running very well.

Thank you also to Mark

Regards

Patrick

[Old Bruce]

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.

 

[anto]

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

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.

 

 

[HelenG]

Could someone please tell me how I make the master page? I have the image that I make in Designer but when I bring it in to Publisher it doesn't go where the Master Page should be?

[walt.farrell]

25 minutes ago, HelenG said:

Could someone please tell me how I make the master page? I have the image that I make in Designer but when I bring it in to Publisher it doesn't go where the Master Page should be?

Welcome to the Affinity forums. 

Double-click on the Master Page in the Pages panel to select it, then use File Place to add you file to it 

Or if you don't have any Master Pages, add one using the Pages panel.

[HelenG]

1 hour ago, walt.farrell said:

Welcome to the Affinity forums. 

Double-click on the Master Page in the Pages panel to select it, then use File Place to add you file to it 

Or if you don't have any Master Pages, add one using the Pages panel.

I'm sorry I can't find that 'File Place'. I have done this today already but can't remember how I did it, I've been trying again for ages.

As you can see my Master A is blank, I am trying to add the page to the right to it so I can add the sequential numbered pages.

Sorry if I seem a bit dim, I'm very new to Publisher.

Edited June 7 by HelenG

[walt.farrell]

Sorry for the lack of clarity. It's Place in the File menu, more often shown here as File > Place.

[R C-R]

6 hours ago, HelenG said:

As you can see my Master A is blank, I am trying to add the page to the right to it so I can add the sequential numbered pages.

I do not understand what you mean by "add the page to the right to it" or "add the sequential numbered pages." Do you mean you want the document pages to have a page number or are you instead talking about adding sequential ticket numbers to each ticket instance on your page 1?

[HelenG]

Ahh I meant on the left, the top Master A was blank and I couldn't figure out how to add the image to the master A image. I did it once and forgot how I did it! I managed to get the tickets done without that though. I just did the first page and then used duplicate in the pages panel and it added the numbers to the next pages.

[R C-R]

To add things to a master page, you should make it the page shown in the workspace window, for instance by double-clicking on its thumbnail in the Pages panel. Then you can add items to it just like you can to document pages.