Ask Your Question

Labels from database / as many copies as the number given by one the fields

asked 2018-04-20 14:02:04 +0100

Geek Disciple gravatar image

Hello! I use LibreOffice to generate labels. This time, I need to print as many labels as the number given by one the fields... any tips?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-04-22 12:29:22 +0100

pierre-yves samyn gravatar image


I see that the answer is marked as accepted but it seems to me however that it is possible to obtain the result without programming. The attached solution assumes that records have a unique identifier.

The principle is to insert variables and condition the goto next record according to the contents of a variable (named Increase in the example).


  • Insert a variable Before at the beginning of the label. Value: drag the id field.
  • Insert a variable Increase. Value: test*Increase+1
  • Insert the "normal" fields (Name in the example)
  • Insert the goto Next record. Condition: [Increase] EQ [NumLabel.Sheet1.Labels]
  • Insert a variable After at the end of the label. Value: drag the id field.
  • Insert a variable test. Value: Before==After

That's it... Explanations:

  • Increase increases from 1 to each label
  • You only change the record when Increase is equal to the number in the field
  • The Before and After variables are no longer equal when you change the record. The test is then zero, which resets Increase (since we multiply by test)

image description

HTH - Regards

edit flag offensive delete link more


Very cool. Thanks for sharing!

David gravatar imageDavid ( 2018-04-22 14:06:59 +0100 )edit

That's amazing! It's exactly what I needed and it works perfectly. Merci beaucoup Pierre-Yves

Geek Disciple gravatar imageGeek Disciple ( 2018-04-24 14:17:03 +0100 )edit

answered 2018-04-21 15:35:58 +0100

Ratslinger gravatar image


Can't envision any method to easily accomplish this. Probably need to write a macro to do this.

In Base you would read the appropriate table, get the # of times to be printed & write the record x times to a temp table. Then use this created table as input for printing the labels. Lots of items to consider such as where this # of times is & how it is cleared. Of course all this requires time and knowledge in writing macros.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more


Thank you very much

Geek Disciple gravatar imageGeek Disciple ( 2018-04-22 09:11:23 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-20 14:02:04 +0100

Seen: 96 times

Last updated: Apr 22 '18