Using query prompt value for VBscript and printer setup Follow

Marco Brummund

We would like to use Bartender for some automation, but with the current setting it seems to be impossible for us.

Example: There is a form where the user has to input the article number and quantity. Due to database connection, the quantity of articles in one carton is known. But how to calculate the quantity of needed cartons (and therefore carton-labels). We can't find any setting how to use the value of the quantity prompt within a VBscript.

In the second step, the calculated quantity of carton labels should be the number of copies of the label. Ok, maybe we could assign a named data source, but how to do this if there is no possibility to calculate with the user's input value?

Thanks in advance.

P.S.: Sorry fo any mistakes or bad expressions, but English is not my mother-tongue :-)


Manuel Lara
Comment actions Permalink

Hi Marco, were you able to solve this? i know its been a while but i have the same issue as you and i am not sure how to fix it

Pete Thane
Comment actions Permalink

If I am reading this correctly:

Number of items per carton taken from a database field

Total number of items required taken from a Data Entry Form

Labels to print to be calculated from those two fields.

To do this:

  1. Add a field to the side of your label (so it wont print) and give this a Name via the Change Data Source Name button in the field properties, I called mine "TotalOrder"
  2. On your Data Entry Form link your data entry field for the total number of items required to this "TotalOrder" field (using the LInked Data Source option in the properties of the entry box)
  3. Back on the Template view add another field similar to the above, again off the side of the label, but make this field a Visual Basic Script field having given it a suitable name, as above, I used "CalcValue"
  4. Amend the VB type to Event Controlled Script and use the Editor to amend this.
  5. In the Autoselected Event change the entry to "Value = 1" and then click on the OnPostPrompt option
  6. In the entry field add the following:

Value = <double click on the TotalOrder named DataSource in the Script Assistant box to the right> / <double click on the name of the Database field that contains the carton quantity again in the Script Assistant box> 

Value = Round(Value+.499)

 So you should end up with something like

       7. Click on File>Print screen and click on the button to the right of the Copies entry box and on the new screen change the option to Get Quantity from Data Source. Click on Data Source in the column on the right and then use the Change Data Source Name button and from the list of Named data sources choose the name you gave for the VB field and you should have something like the image below

...and that should be it

I hope this helps


Please sign in to leave a comment.