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 1 month 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,298 Points 1k badge 2x thumb

Posted 1 month ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,240 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,298 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

  • 53,240 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,298 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

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

Raj Helaiya

  • 1,298 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

  • 53,240 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.