Javascript in Formula URL Help

Question

From other posts I was able to put together the following code for a Formula URL button. This accomplishes the main actions of calling a 3rd party REST API and then reloading the current page.

var text URL= "https://hooks.zapier.com/hooks/catch/XXXXXXXXXXX?;

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"

I'd like to know if its possible to do one of two (or both) additional actions

1. Is it possible to add a delay before the page reloads?
2. Is it possible to show a pop-up box the user would click on and then reload the page

I basically just need to buy a second or two while the REST API that was called does its thing and then ultimately updates a record back in Quickbase before the page reload occurs

Thanks for the help

markshnier__you · Answer

In the Quick Base formula language when you want to use an intermediate calculation for ease of writing a formula you can create what is called a formula variable.&nbsp; Here is some help on that.https://help.quickbase.com/user-assistance/formula_variables.html------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

joshuatate · Answer

For the first one is straight forward, below is the timeout function, i use a fat arrow function with no input, and call location.reload(true) after 2 seconds or 2000 milliseconds.

setTimeout(()=> location.reload(true),2000)

joshuatate · Answer

As for the popup box, there are so many ways to do this, for the sake of expedience have a look at Dans pastie in the below link, his pastie collection is a good starting point in extreme cases or a good resource to save time in general as you are starting your Javascript adventure in quickbase.

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=7&rl=w2v

robiv · Answer

$.get is shorthand for a jquery Ajax (Asynchronous JavaScript and XML) call.&nbsp; The asynchronous nature of this allows for exactly what you are looking to do in a non-blocking way.You just need hit up a .then() or similar after your API call.Here are some docs:https://api.jquery.com/jquery.get/More stuff:&nbsp;https://api.jquery.com/category/ajax/Hope this helps,~Rob

robiv · Answer

See:&nbsp;https://api.jquery.com/deferred.then/also:&nbsp;https://api.jquery.com/deferred.done/

Forum Discussion

Javascript in Formula URL Help

Related Content

Delete Formula Button Error

Formula Assistance

Formula Url Buttons

Formula Query with custom key

URL formula -API_RunImport