Forum Discussion

ArshadKhwaja's avatar
ArshadKhwaja
Qrew Commander
8 years ago

Testing for Null Value For a Label

I am using the following label using a URL field  to show a label.  Mark was kind enough to help with this.  Can I hide the label where the Sales Data is returning Null. 

var text Words = "Show Store Dev History and Sales";
var text URL = [Sales Data];

"<a class=\"Vibrant Primary\"a href=" & $URL & ">" & $Words & "</a>" // makes blue
  • JohnThomas's avatar
    JohnThomas
    Qrew Cadet
    8 years ago
    var text Words = "Show Store Dev History and Sales";
    var text URL = [Sales Data];
    If(Length($URL) =0, "Null", "<a class=\"Vibrant Primary\"a href=" & $URL & ">" & $Words & "</a>" )

    I hope this will solve your issue !!