Split Price

Legacy Poster

• 2013年10月13日 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

  版主

  ★ BarTender Hero ★

  • 2013年10月16日 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

請登入寫評論。