Populating a label sheet using a data entry form S’abonner

0
Avatar
Joachim Schulz

I'd like to use a single data entry form to fill out multiple labels on a single label sheet before printing, all with the same layout but with different data.

So i'm looking for something similar to the "repeat data entry until cancelled"-setting but it should also delay the printing until cancelled.

Thanks for any help in the matter.

8 commentaires

0
Avatar
Pete Thane
Actions pour les commentaires Permalien

Not sure if this is what you are after, but have you looked at setting up multiple templates on the label and link a data entry form to each one? At print time you would fill in each form before moving onto the next and after the last one is complete the print button would produce them. 

Pete

0
Avatar
Joachim Schulz
Actions pour les commentaires Permalien

I've thought of that, but it gets unwieldy after a while (there are 30 labels on the sheet). Also, more importantly, i don't want to print a full sheet but a different amount of labels each session.

So, ideally, i'd like a data entry form that gives me a "next" and a "print" button or something with that same functionality. Or, with that multiple templates/data entry forms solution, a way to cancel the data entry process but still go to printing.

0
Avatar
Joachim Schulz
Actions pour les commentaires Permalien

Ok, i found an interim solution. If i set the frequency of my data entry controls to "Every copy" and put another control on top to enter the number of labels i want to print, it will show the data entry form that many times.

Now i only need that exact behaviour without having to specify the number of labels beforehand, like with a data field which controls the copy number that increments by 1 each time a specified data form control is filled. But i guess the print quantity can only be entered once at the beginning.

 

0
Avatar
Pete Thane
Actions pour les commentaires Permalien

You could create a front end to allow you to enter the appropriate data and when you are finished have a "print" button that saves all the data as different lines in a text file for example having previously configured Integration Builder (need Automation edition or above) to "wait" for the file and then open BarTender, populate the appropriate number of labels, i.e. 1 per record, and then print them all whilst running in the background.  

0
Avatar
Joachim Schulz
Actions pour les commentaires Permalien

Thanks for your suggestions so far, Peter. Using the Integration Builder might be too complicated for me. I could simply fill out an excel file and use that as a data source for the same effect.

So, i'm shooting into the blue here because i'm totally new to VBscript, but would it be possible to run a script "OnPrePrompt" to fetch the number of labels left on the sheet (after the user selects the start position) and use that as the number of print copies, and another script "OnPostPrompt" to jump directly to printing/print preview if a certain data entry field is left empty by the user?

 

0
Avatar
Joachim Schulz
Actions pour les commentaires Permalien

Addendum:  I just found out that it is in fact possible to change the number of print copies after the start. So now i'm using serialization to add 1 to the that number each time a certain data field changes. That means i don't have to enter the number of copies at the start and it automatically stops and goes to printing if i leave that field empty.

Two minor nitpicks though: First, it also stops if enter the same data twice so i would like to use a script instead to do the serialization. Second, because it stops AFTER the empty data entry form it prints one empty label. I don't know how to remove that.

0
Avatar
Joachim Schulz
Actions pour les commentaires Permalien

Addendum 2: Ok, second nitpick, the empty label at the end, removed by using conditional printing. Now i just need that Serialize-if-datafield"x"-is-not-empty-script and i'm a happy camper.

 

0
Avatar
Joachim Schulz
Actions pour les commentaires Permalien

Ok, this is now how i've done this:

I'm using "Value = 31 - Format.StartingPosition" for the number of print copies (my sheet has 30 labels) so it automatically uses the number of labels left on the sheet.

To get it to stop in the middle of the data entry process like i wanted to i used a second, empty data entry form. It shows the second form if a certain field in the first form is left empty. The empty data form just makes it skip to the end. Via conditional printing empty labels are discarded.

The result is that now i get the data entry form and can enter label data after label data until i want to stop and then just leave the form empty and press ENTER or i reach the maximum number of labels. For user convenience a counter and the max number are also shown on the form.

Thanks again for the help.

 

Vous devez vous connecter pour laisser un commentaire.