Skip to main content
Question

Testing for Null Value For a Label

  • July 4, 2017
  • 0 replies
  • 7 views
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
      This topic has been closed for replies.

      • JohnThomas
      • Registered
      • July 4, 2017
      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 !!
      • ArshadKhwaja
      • Author
      • Registered
      • July 5, 2017
      Many thanks for your kind help. 
      Terms & ConditionsAccessibility statement