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
      ------------------------------