5 Replies Latest reply: Mar 31, 2017 1:49 AM by Taahir Hoosen RSS

    If statement in a text box based on selection of field

    Taahir Hoosen

      Hi

       

      I would like to know is it possible to create a text box with conditional text.

       

      my text box has a campaign selection field as an input as below:

       

      = ,'Online Sales Report for ' & [CAMPAIGN]  & ' ' & [Year])

       

      but when there is no selection, it shows "Online Sales report for"..... I would like to make this text box conditional so that when there is no selection it remains blank

       

      = if(CAMPAIGN = '' ,'','Online Sales Report ' & [CAMPAIGN]  & ' ' & [Year])

       

      I am using the above statement but it does not seem to work