Sequentially numberted tickets...

users
#1

I have been asked to design and print numbered tickets for an event being
organised by a Club to which my wife belongs.

Starting from the left edge:

(a) in the first third details of the event and a number. This is the "stub"

(b) in the remaining two thirds there is an image to the left and then
details of the event. This is the "ticket"

(c) each ticket has two numbers (both the same) printed to justify right on
the "stub" and on the "ticket"

(d) each ticket spans the width of an A4 page

(f) there are four tickets to an A4 page

(g) the ticket will be perforated between the "stub" and the "ticket" to
allow for easy detachment

(h) Designing the ticket is not a problem. But how do I ensure that the
numbers are printed sequentially in groups of two?

Is it possible to do this on LibreOffice?

I realise that it is possible to number each ticket on a A4 page and then
print it but as it is looking like 150 tickets that looks like a lot of
work.

David

#2

Hi David,

I have been asked to design and print numbered tickets for an event being
organised by a Club to which my wife belongs.

How I'd do it (it's from memory, so bear with me for little glitches):

1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
format with two preceeding zeroes) into a column

2. design a nice text page with all 4 tickets in it (you could also try
going with labels but for just 4 tickts per page I'd rather go with
copy&paste instead of fumbling with labels)

3. assign the spreadsheet from #1 as data source (for later use as
mailmerge, from memory: File > New > Database > connect to existing >
spreadsheet)

4. on your above designed ticket page, press F4 to open the spreadsheet
from above as data source

5. enter (simply drag&drop) column header field into the appropriate
place in stub and repeat this for the ticket

6. after every SECOND field enter "next record" switch (Insert > field >
others > database > next record) but NOT after the fourth ticket (as a
page break always triggers a next record switch)

7. Print as mailmerge (or form letter or whatever it's called) into 1
document

8. review the document and if necessary correct&repeat some of the above
steps

9. print the merged documents,

10. enter perforation (I use a sewing machine, works perfectly if you
use a thin needle and adjust the step width appropriately)

11. cut tickets apart :slight_smile:

Enjoy learning :wink:

Nino

#3

Hi :slight_smile:
How i would do it.

1.  Go to an office supplies shop or even a small newsagents
2.  Buy a book of raffle tickets for something like 50p or maybe a £5er these days

Job done.

Regards from
Tom :slight_smile:

#4

[snip]

Thanks, Nino. I will give it a go and report back.

David

#5

Hi Nino

> I have been asked to design and print numbered tickets for an event
> being organised by a Club to which my wife belongs.

How I'd do it (it's from memory, so bear with me for little glitches):

Thank you for the prompt reply and my apologies for the delay in replying to
you.

1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
format with two preceeding zeroes) into a column

Did that without problems.

2. design a nice text page with all 4 tickets in it (you could also try
going with labels but for just 4 tickts per page I'd rather go with
copy&paste instead of fumbling with labels)

O.K. Although I did have some trouble grouping all elements.

3. assign the spreadsheet from #1 as data source (for later use as
mailmerge, from memory: File > New > Database > connect to existing >
spreadsheet)

Perfect!

4. on your above designed ticket page, press F4 to open the spreadsheet
from above as data source

No problem.

5. enter (simply drag&drop) column header field into the appropriate place
in stub and repeat this for the ticket

Went without a hitch.

6. after every SECOND field enter "next record" switch (Insert > field >
others > database > next record) but NOT after the fourth ticket (as a
page break always triggers a next record switch)

This is where I've gone wrong and I cannot figure out how. As I understood
it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
above. Is that correct?

and then, as it will be a new page, the numbering will continue in sequence
until we reach the end of the records. Is that correct

7. Print as mailmerge (or form letter or whatever it's called) into 1
document

I do this by Printing to file. The first ticket is correct. Tickets number
2, 3 and 4 are not numbered. It then goes to the next page where the first
ticket is numbered 2 and the other three are not numbered. And so it goes
on until the end of the records. Each page is the next number.

I notice that when I have Next Record highlighted and click Insert, all that
happens is a thin grey vertical line appears where I click. I would have
thought the words <next record> would have appeared. Am I wrong?

8. review the document and if necessary correct&repeat some of the above
steps

I am at a loss as to what I should do next.

9. print the merged documents,

10. enter perforation (I use a sewing machine, works perfectly if you use
a thin needle and adjust the step width appropriately)

11. cut tickets apart :slight_smile:

Enjoy learning :wink:

My enjoyment is leading to "grinding of teeth in frustration"

David

#6

Hi David,

6. after every SECOND field enter "next record" switch (Insert > field >
others > database > next record) but NOT after the fourth ticket (as a
page break always triggers a next record switch)

This is where I've gone wrong and I cannot figure out how. As I understood
it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
above. Is that correct?

Not quite.

If - as I understand your description - you have the following design:

#7

Oh, I think here I draw the wrong conclusion: If the field numbers are
"empty" then only the number fields from the first ticket have been
correctly inserted, the other fields must be somehow wrong.

However - make the fields visible with Ctrl+F9 (or View > Field Names)
then look what's wrong with them :slight_smile:

BTW: If you want a preview of the resulting Merged Document on the fly,
you can select a couple of rows in the F4 data source window (click on
the first row, then shift-click on the tenth row or so, so that they are
all marked blue) and click on the "Data to fields" button in the data
source window.

Nino