Conditionally Search And Replace Database Data Source Follow

0
Avatar
Legacy Poster

Currently, I am reading in text from an excel database as a sku/barcode and I want to be able to specify at print time if I want the sku to end in either UTW or NIB. I'm using a Data Entry Form and a check box to determine if I want to end with NIB or UTW at print time but I don't know how to transform that data from the database based of a condition specified by the Data Entry From. I'm still pretty new to using BarTender and any help is really appreciated. Thanks. 

3 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

So are you wanting a database field to set a data source value or the checkbox form control? Your question is not clear to me.

In the checkbox form control properties you can specify the checked and unchecked value that you wish to apply to the linked data source.
0
Avatar
Legacy Poster
Comment actions Permalink

I want a checkbox on the data entry form to conditionally transform a data source from a database. Thanks for helping me out. 

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

Set a name for the data source that links to the checkbox form control.  Create a VB script data source in a template object that checks the value of the checkbox data source, and in a conditional statement sets it's own value accordingly using further input from the relevant database field.  In the script editor in the "Script Assistant" tool box you'll see that you have access for inserting references to database fields and named data sources in your code.

Please sign in to leave a comment.