How to create a url link

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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

  • 468 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
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

  • 468 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.




that last URL got truncated.
Photo of Shane Selasky

Shane Selasky

  • 468 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.  
You can post your formula.  But highlight it and then use the PRE setting on this forum to keep the href from getting garbled.