Set Print Visibilty From Database Field Follow
I found a couple topics about this, but I can't seem to make it work...
I am using Bartender 10.0 SR4
I am using a linked excel table to fill in some of my data sources.
One field is 'number of boxes' and is just a number (1-5) or blank, although it could be 0 if needed. This is a named data source in my bartender document (boxes).
I have a text object named 'Required Boxes' that uses a prefix-'number of boxes'-suffix. so it would print like "Complete Kit Requires 2 Boxes"
I have tried to set up a vb script to prevent 'Required Boxes' from printing, including the prefix and suffix, if 'number of boxes' is empty.
I navigated to File> BarTender Document Options> VB Scripting> Functions and Subs
This is the script I used:
If Format.NamedSubStrings("boxes").Value = "" Then
Format.Objects("Required Boxes").PrintVisibility = False
I know absolutely nothing about scripting, so this is all new to me.