Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Taahir,
Go to layout check conditional and give condition GetSelectedCount(Campaign)>1.
May be like this
If(GetSelectedCount(CAMPAIGN) = 1, 'Online Sales Report for ' & [CAMPAIGN] & ' ' & [Year])
Or if i got you wrong and you need the text box to be displayed but as empty,
use the same trick
if( GetSelectedCount(Campaign)>1,<your string>)
Thanks Sunny your solution helped
Thanks Shiva your solution worked as well