Ask Your Question
1

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 6.0.2.1 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
1

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

pierre-yves samyn gravatar image

Hi

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).

Steps

  • 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

Comments

Very cool. Thanks for sharing!

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

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
0

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

Ratslinger gravatar image

Hello,

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

Comments

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

Stats

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

Seen: 96 times

Last updated: Apr 22 '18