How to create a url link

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
can't find documentation on how do this.  I think i have to use a formula url field but not sure what i need to add to it.  Instead of just having the long url in form to click on, i would like it to be a url link that says "for further information, click here" and then the :"click here" is the link. Thank you.
Photo of Shane Selasky

Shane Selasky

  • 382 Points 250 badge 2x thumb

Posted 2 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Here is my hyperlink for dummies example which I use all the time.

var text Words = (field or hard coded words go here);
var text URL = (url goes here);  
"<a href=" & $URL & ">" & $Words & "</a>"
Photo of Shane Selasky

Shane Selasky

  • 382 Points 250 badge 2x thumb
it is giving me a syntax error within the URL link.  It is highlighting the colon between https and //.  Not sure why since i copy and pasted everything from what you gave me above and the syntax is matching from beginning to end.  Here is the entire formula i pasted into the url formula:

var text Words = (Further information);
var text URL = (https://appriver3651013949.sharepoint.com/:p:/r/_layouts/15/Doc.aspx?sourcedoc=%7Bd5a8c264-2b87-4af5...;  
"<a href=" & $URL & ">" & $Words & "</a>"

I have had issues before with copying and pasting into formula before so maybe that is the issue.

Also, is there further information on how to create formulas through quickbase?  It has been forever since i did programming.  The concepts are still familiar to me, just not the commands to do the programming.




Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
that last URL got truncated.
Photo of Shane Selasky

Shane Selasky

  • 382 Points 250 badge 2x thumb
i got the link to show on the form but when clicking on it, the link errors out.  it is includeing the <a href in the url.  i will play around with it a bit to see if i can figure it out.  Giving me what you did definitely helped to at least make it a link.  
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
You can post your formula.  But highlight it and then use the PRE setting on this forum to keep the href from getting garbled.