Removing Javascript Screen Refresh from URL Formula Fields

Question

I started my Quick Base app years ago, and the best way (at that time) to do a screen refresh was with this nifty snipped of javascript (which I know nothing about).

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

It has worked great over the years, but now Quick Base is no longer going to support javascript in URL Formula fields. My question is how do I get the same functionality? Am I supposed to create a code page with just this snippet on it and call it from the formula field? - I've never created a code page (never had too) - so calling one is new to me as well.. Is there a better way to do the refresh? - actually if it just refreshed the child records (embedded report) that would be even better.

Basically I have an embedded report (ie.. invoice line items - child records).. and each line item has a button to "copy" or "delete" the line item, then refresh so it is displayed on the screen.

Thanks for any help or insight on how I can keep my line item buttons working.
Mark

------------------------------
Mark Corcoran
------------------------------

justintorrence · Answer

@Mark Corcoran
Quickbase just added a new URL parameter that allows you to emulate this functionality. Here is a blog post that references it.​

------------------------------Justin TorrenceQuickbase Expert, Jaybird Technologiesjtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------

markshnier__you · Answer

Here is another way to say the same thing more generically and written similar to that previous Javascript method that you were using.var text URL =&nbsp; your URL goes here;// then this part below will always be the same.
$URL
&amp; "&amp;rdr="&amp;URLEncode( URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl())
------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markcorcoran · Answer

This works good, thanks for the solution!------------------------------Mark Corcoran------------------------------

tateforgey · Answer

There is a specific use of the previous JavaScript that doesn't seem to work with this new code. (Inspired by Coach!) I have a button on a table's form that redirects to a report on a different table with an "ask the user" filter and completes that filter with a value from the original record.&nbsp; It's part of a workflow to associate child records in bulk where the users usually search for an ID from the filtered list, associate the record with a formula button that also refreshes the page, and then search for another ID to associate. This has worked beautifully for years, and users loved it! I replaced the JavaScript with this code for the reload portion of the button and boom - busted. It seems like the report refuses to display with the filter as it did before.&nbsp; Instead of the reload, I think I'll need to create a redirect back to the same page, but reinsert the fields in the filter, which means I'll have to go hold them in a surrogate table just for this purpose (Coach's "User Focus" technique.)&nbsp; A bit of a pain, but I'm hoping that works. I must be getting crotchetier, but it seems all Quickbase's recent changes cause me a lot of work and bring me little benefit.&nbsp; Ugh.------------------------------Tate Forgey------------------------------

Forum Discussion

Removing Javascript Screen Refresh from URL Formula Fields

4 Replies

Related Content

Button to Add Record via Pipeline, and refresh Record

Thumbnail pictures refreshing slowly

Removing Blank Input Type

Pipelines - Connected Table Refresh

Javascript