Formula URL button from Quickbase to external URL caching variables from previous QB records

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • In Progress
  • (Edited)
I have a formula URL button in Quickbase that is redirecting to an Order Form depending on what criteria is selected in the record using an (If) statement. I am passing variables from Quickbase to the external Order Form through the URL (Variable Passing). The button works just fine and the variables pass and pre-populate the Order Form, however, if I go to another record in Quickbase and click the formula URL button it does indeed take me to the Order Form but it remembers the prior information passed in the URL from Quickbase even though there are new variables passed in the URL. 

Now, I know this is a cache issue and that I can just clear my cache or open in a new incognito window, however I would like to see if anyone had any ideas with how the redirect is happening and if there are any variables I can pass in the redirect from Quickbase that would tell the new page or in this case the Order Form (Which I did not build, its an Order Form provided by our Merchant) to clear the form and accept the new variables? 

We use to use Formstack for this, and I am trying to do away with Formstack and we didn't seem to have the caching issues there, so I am not sure if Formstack had the redirect setup in a way that it did exactly what I am trying to achieve, just in Quickbase. Thanks everyone. Here is my code below:

"https://website-example/OrderForms?Contact0LastName="&[First Name]&"&Contact0LastName="&[Last Name]&"&Contact0Company="&[Company]&"&Contact0Email="&[Email]

*URL is not functional, just for example purposes. 
Photo of Nathan Call

Nathan Call

  • 110 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
This is definitely a caching issue on the destination URL.  

There are a few options you can try to override the cache.

1- Set Browser settings to reset per the specific site
https://www.howtogeek.com/137681/how-to-automatically-clear-private-data-when-you-close-your-browser...

2- Append some form reset protocol to the URL.  This one is tricky, because you'd want to know the form settings on the 3rd party form.  You can see some examples here.
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
http://stackoverflow.com/questions/1922910/force-browser-to-clear-cache

3- Ask DanDiebolt@gmail.com