Vbscripting Help

Legacy Poster

• March 02, 2016 17:43

The information that is currently set to print on my label is being pulled from the database (Field: ShippingName). Sometimes that info is blank in the database and when it is, I need it to print from  (Field: TechnicalName).

 

Is there a way to do this with VBScript? Can someone please help me?

 

Thanks in advance.

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • March 03, 2016 14:02

  Using an OnProcessData VB script for your database field data source, write something like the below:

   

  If value = "" Then

     value = Field("myDatabase.myTable.myField")

  End If

   

  You'll need to substitute in your own DB, table, and field names.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • March 03, 2016 21:23

  That worked almost perfectly. Bartender suggested using:

   

  ReferenceField("myDatabase.myTable.myField")

   

  At the beginning of the script and now it works perfectly.

   

  Thanks for the help as I do not know anything about scripting.

   

  :)

  0

Please sign in to leave a comment.