Discussions

Expand all | Collapse all

Testing for Null Value For a Label

  • 1.  Testing for Null Value For a Label

    Silver
    Contributor
    Posted 07-04-2017 06:37
    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


  • 2.  RE: Testing for Null Value For a Label

    Posted 07-04-2017 09:42
    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 !!


  • 3.  RE: Testing for Null Value For a Label

    Silver
    Contributor
    Posted 07-04-2017 22:18
    Many thanks for your kind help.