Trigger For Print Time Data Entry Form S’abonner

0
Avatar
Legacy Poster

I'm using an Excel spreadsheet as a data source. It's full of ship-to addresses and carrier info for our customers. 

 

Is it possible to create a text input box in a data entry form, that, at print time, when you enter a customer name, a full address from the corresponding row in the Excel file would populate a multi-row text box on the label?

 

In other words, if I type a customer name in a box, can their full address automatically be displayed automatically on the label?

 

Thanks!

 

(I'm using the demo. Loving it so far. And your on-line videos are very well done.)

 

 

4 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Yes,

 

You need to set up a database query in the database setup for the label template to ask for the customer at the time of printing.

0
Avatar
Fernando Ramos Miracle
Modérateur
Actions pour les commentaires Permalien

Please take a look at the below training videos as they might help you on both configuring your database connection and and setting up the query respectively:

 

http://www.bartenderbarcodesoftware.com/label-software/training-video-(reading-data-from-database).aspx

 

http://www.bartenderbarcodesoftware.com/label-software/training-video-(selecting-records-from-a-database-at-print-time).aspx

 

Regards,

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Thanks for the replies!

 

Slickson: thanks for confirming that it can be done.

Fernando: thanks for the video links. I watched them both again and while what I needed came close in the second one at 4:20 on "Queries" it did not go far enough in detail.

 

Question for support: is there a generic template somewhere in the software that would demonstrate this? There are a lot of 'things' that can control other 'things' and being new to the software I know I'm missing something. After I see it once, I'll be good to go. 

I may have to pay someone to show me how this is done as it's the thing I have to prove before we purchase software/printer combo. 

 

~Dan

0
Avatar
Fernando Ramos Miracle
Modérateur
Actions pour les commentaires Permalien

Hello Dank,

 

Please note that you can forward this issue directly to our Technical Support service, that way we can offer a more through support or maybe even send you a simple example using your database (or a fragment of it).

 

You'll find our support contact details on the below webpage (contact the closest office to your region for a faster answer):

http://www.bartenderbarcodesoftware.com/label-software/technical-support.aspx

 

*Please remember to mention this post on your email and also send us your support number (from BarTender's "Help>About..." dialog) and a sample of your database.

Vous devez vous connecter pour laisser un commentaire.