Text Formula URL to open external webpage

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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!!
Photo of Stephanie

Stephanie

  • 10 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
I'm not understanding what you are trying to do, but I observe that you have &aid= In it.  Did you mean &rid=
Photo of Stephanie

Stephanie

  • 10 Points
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
Photo of Stephanie

Stephanie

  • 10 Points
I got it!!

Here is what I did

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


Works beautifully now
Photo of Sergio

Sergio

  • 492 Points 250 badge 2x thumb
I would love to know what you did, because i have a similar need

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Sergio, I suggest that you post a new question.