Discussions

Expand all | Collapse all

How to create a url link

  • 1.  How to create a url link

    Posted 03-01-2019 15:06
    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.


  • 2.  RE: How to create a url link

    Posted 03-01-2019 15:16
    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>"


  • 3.  RE: How to create a url link

    Posted 03-01-2019 16:15
    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...">https://appriver3651013949.sharepoint.com/:p:/r/_layouts/15/Doc.aspx?sourcedoc=%7Bd5a8c264-2b87-4af5-825b-661231657c1e%7D&action=edit&uid=%7BD5A8C264-2B87-4AF5-825B-661231657C1E%7D&ListItemId=299006&ListId=%7B77808F62-6509-461B-8A4F-C17F3247E5EF%7D&odsp=1&env=prod)">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.






  • 4.  RE: How to create a url link

    Posted 03-01-2019 16:22
    that last URL got truncated.


  • 5.  RE: How to create a url link

    Posted 03-01-2019 16:22
    var text Words = "(Further information)";
    var text URL = "https://appriver3651013949.sharepoint.com/:p:/r/_layouts/15/Doc.aspx?sourcedoc=%7Bd5a8c264-2b87-4af5";  


  • 6.  RE: How to create a url link

    Posted 03-01-2019 18:39
    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.  


  • 7.  RE: How to create a url link

    Posted 03-01-2019 18:46
    You can post your formula.  But highlight it and then use the PRE setting on this forum to keep the href from getting garbled.