Quick Base Discussions

Expand all | Collapse all

Text Formula URL to open external webpage

  • 1.  Text Formula URL to open external webpage

    Posted 07-27-2015 17:55
    I want to create a formula text "button" that will open a specific html page I have built in QB - this URL also passes information from some of the fields in the table it sits on:

    This is what the URL looks like:


    https://MY.quickbase.com/db/bxbxbxbxbx?a=dbpage&pageID=7&aid=[Record ID#]&company=[Company Name for URL]&time=[Date and Time for URL]

    I'm having trouble getting it to work - and it's probably something silly I am missing.

    Thanks in advance for any help!!


  • 2.  RE: Text Formula URL to open external webpage

    Posted 07-27-2015 18:47
    I'm not understanding what you are trying to do, but I observe that you have &aid= In it.  Did you mean &rid=


  • 3.  RE: Text Formula URL to open external webpage

    Posted 07-27-2015 19:20
    yes, rid - ...

    what I am trying to do - I have this in an email with html:  "<a href="https://MY.quickbase.com/db/bxbxbxbxbx?a=dbpage&pageID=7&rid=[Record ID#]&company=[Company Name for URL]&time=[Date and Time for URL]">

    it works fine from the email - but if I try to make a button out of it ... it doesn't pull the information from the fields in... that's the part I need help with


  • 4.  RE: Text Formula URL to open external webpage

    Posted 07-27-2015 19:30
    I got it!!

    Here is what I did

    "https://MY.quickbase.com/db/bxbxbxbxbx?a=dbpage&pageID=7&rid="&; URLEncode([Record ID#])&"&company="& URLEncode([Company Name for URL])&"&time="& URLEncode([Date and Time for URL])


    Works beautifully now


  • 5.  RE: Text Formula URL to open external webpage

    Posted 08-02-2018 00:10
    I would love to know what you did, because i have a similar need



  • 6.  RE: Text Formula URL to open external webpage

    Posted 08-02-2018 01:22
    Sergio, I suggest that you post a new question.