Forum Discussion

MarkCorcoran's avatar
MarkCorcoran
Qrew Cadet
5 years ago

Removing Javascript Screen Refresh from URL Formula Fields

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('" & ...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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 =  your URL goes here;


// then this part below will always be the same.

$URL

& "&rdr="&URLEncode( URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • MarkCorcoran's avatar
    MarkCorcoran
    Qrew Cadet
    5 years ago
    This works good, thanks for the solution!

    ------------------------------
    Mark Corcoran
    ------------------------------
  • TateForgey's avatar
    TateForgey
    Qrew Assistant Captain
    4 years ago
    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.  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. 

    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.)  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.  Ugh.

    ------------------------------
    Tate Forgey
    ------------------------------