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.

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
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. 
Photo of Raj Helaiya

Raj Helaiya

  • 1,318 Points 1k badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 60,108 Points 50k badge 2x thumb
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>"

Photo of Raj Helaiya

Raj Helaiya

  • 1,318 Points 1k badge 2x thumb
So i just write the formula in a formula rich text field? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 60,108 Points 50k badge 2x thumb
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.
Photo of Raj Helaiya

Raj Helaiya

  • 1,318 Points 1k badge 2x thumb
It gives me an error : " Variable declaration must be assigned a valid expression"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 60,108 Points 50k badge 2x thumb
Please post your code.
Photo of Raj Helaiya

Raj Helaiya

  • 1,318 Points 1k badge 2x thumb

 

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

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

 

"<a href=" & $URL & ">" & $Words & "</a>"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 60,108 Points 50k badge 2x thumb
You will need to edit the formula to put in your own words and your own URL to go to.