Label Fields Not Updating From Database On Print Preview Follow

0
Avatar
Legacy Poster

Good day,

 

I have a label with a data entry form. Data is read from a database (XLS file). The data entry form is configured with a dropdown field for selecting the primary/unique field in the table and a label preview (image).

 

The dropdown field options/values on the data entry form are populated with a VB script as explained here: http://forums.seagullscientific.com/index.php?/topic/2446-drop-down-menu-and-vb-script/?p=8060

 

The label contains a text fields (text field 1) which display the value selected on the dropdown field on the data form, plus an additional text field (text field 2) which should display values corresponding to the dropdown value selected (from the XLS file).

 

Now, my problem is that, when printing, the label preview on the data form does not update correctly: text field 1 displays the correct value (same value as selected on the dropdown field), but text field 2 is not updating to display the value corresponding to the dropdown field selected, it always shows the value from the first row in the XLS file. 

 

How am I supposed to link text field 2 to the dropdown field selection, so that text field 2 updates with the value corresponding to the dropdown value selected?

 

When designing the label (non print/preview mode), I can browse through the records with the arrows at the bottom of the screen, and both text field 1 and text field 2 are updating correctly.

 

Regards,

John Grobler

8 comments

0
Avatar
Legacy Poster
Comment actions Permalink

Bump

0
Avatar
Legacy Poster
Comment actions Permalink

I've created a few screenshots to better explain the issue, maybe someone can point me in the right direction. Thanks!

https://dl.dropboxusercontent.com/u/3642769/bartender.png

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

The preview picture in the data entry form doesn't currently work for data sources that are calculated by VB script.  In a future release we hope to handle such scripted data sources for the preview picture. Sorry!

0
Avatar
Legacy Poster
Comment actions Permalink

Hi Ian,

 

Thank you for the feedback. I've just done a test by manually entering two values from the XLS file into the dropdown menu (so no VB script needed). But, when I change the selection on this dropdown menu on the data entry form, the preview picture still does not update correctly (exact same issue as previously mentioned). Do you have any documentation on how to implement this the correct way in Bartender?

 

Thank you!

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

This seems to work for me without a problem.  What version/build of BarTender are you using?

 

I did nothing special.  Either follow the training video here or refer to the BarTender Help system.

 

http://www.bartenderbarcodesoftware.com/label-software/training-video-(data-entry-at-print-time).aspx

0
Avatar
Legacy Poster
Comment actions Permalink

Hi Ian,

 

I'm new to Bartender, so thank you for the information. I've previously watched the training video provided, but maybe I need to explain better what I'm trying to accomplish:

 

The purpose of the dropdown field on my data entry form is to filter/select the specific record in the database. So for example, if I select option A from the dropdown menu, the template fields should display the field values corresponding to option A selected from the database (XLS file). 

 

In the training video link provided, the data entry fields seem to just be used for adding additional data to the label, and not for actually filtering/selecting a specific record and displaying this record's data on the label.

 

Is it possible to use the data entry form to filter/select a specific record from the database with a dropdown menu, or what is the best way to accomplish this?

 

Thank you!

 

Update: In your thumbnail provided, if I select Green from the dropdown menu, the record in the data source associated with Green should be selected and the corresponding data should be printed (additional text fields etc).

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

You need to be using a query prompt for the database query rather than a standard data entry form control.  Unfortunately we only support a standard text input box for query prompts currently.  We do plan on revamping our database functionality in BarTender for future versions, but it is as it is for the moment.  The below training videos indicate what is currently possible in terms of database connectivity and record selection.

 

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

0
Avatar
Legacy Poster
Comment actions Permalink

Perfect that's what I needed to know, thanks!

Please sign in to leave a comment.