Discussions

Expand all | Collapse all

How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

  • 1.  How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Bronze
    Contributor
    Posted 11-05-2018 19:41
    How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site. 

    I want a field or a link which can be clicked with an underlying URL which points to a different site. 


  • 2.  RE: How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Posted 11-05-2018 19:48
    The generic format for a Formula Rich text field to make a hyperlink is this

    var text URL =   & "url goes here and end with a semi colon";
    var text Words=  & " words for the hyperlink go here";

    "<a href=" & $URL & ">" & $Words & "</a>"



  • 3.  RE: How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Bronze
    Contributor
    Posted 11-05-2018 19:52
    So i just write the formula in a formula rich text field? 


  • 4.  RE: How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Posted 11-05-2018 19:54
    yes, try it yourself first to just link to say google.com as a hard coded URL and hand coded words like "Search".

    Then improve the formula by adding in your URL and the words.


  • 5.  RE: How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Bronze
    Contributor
    Posted 11-05-2018 19:57
    It gives me an error : " Variable declaration must be assigned a valid expression


  • 6.  RE: How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Posted 11-05-2018 19:58
    Please post your code.


  • 7.  RE: How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Bronze
    Contributor
    Posted 11-05-2018 20:00

     

    var text URL =   & "this contains url address to the report";

    var text Words=  & " Click here to access Score Card.";

     

    "<a href=" & $URL & ">" & $Words & "</a>"


  • 8.  RE: How do I create a field that has a button/label which has a URL. This URL is used to access reports on a site.

    Posted 11-05-2018 20:27
    You will need to edit the formula to put in your own words and your own URL to go to.