Split Price

Legacy Poster

• October 13, 2013 05:20

Greetings,  I am new to bartender.. I have bartender pro 10.  I am connecting to a sql database to pull in my info.  I have two fields,   price multiple and price.  I would like to print  if the price multiple is 2 and the price is 1.29 I would like to print 2 / $1.29 on the label.   If the price multiple is 1 and the price is 1.29, I would like to print  $1.29

How would I accomplish this task in bartender?  Would I need to write a vbscript?  Thank you for any help you can provide.

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • October 16, 2013 13:24

  Under the "Transform" tab of the data source you can run an "OnProcessData" VB script to handle your conditional formatting.  Something along the lines below:

   

  If value = X Then
    value = Y
  Else
    value = Z
  End If
  

  Obviously you replace X/Y/Z with the relevant items as per your needs.

  0

Please sign in to leave a comment.