Forum Discussion

JonathanRoberts's avatar
JonathanRoberts
Qrew Cadet
7 years ago

How can I have a URL button return to where ever it was clicked from? Like same report or homepage that has the report.

I have a Schedule table and buttons for start and complete to change the status of the items. The buttons are used in different contexts and so having it go to a specific report  is not friendly for work flow. Is there a way to have it just edit the record and stay put without going to record or to a certain report?
APIs and custom code
App builders
App home pages
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    no problem. make a formula variable called,  (I suggest),  URL and then continue the formula box with the javascript refresh syntax.


    var text URL = 
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&_fid_11=Complete";


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



    Don't worry that you don't understand that javascript stuff.   It just executes the formula variable called URL and refreshes whatever page you were on.  It's magic.
    • RyanPflederer2's avatar
      RyanPflederer2
      Qrew Trainee
      7 years ago
      And if you don't need to see the change on that page immediately, you can swap out 
      "location.reload(true);" with the line below to remain on the same page but display a small disappearing popup. It makes it even quicker when trying to update numerous records in a report.

      Just replace the bold part with whatever text you need to see in the popup.

      "$.jGrowl('Record #" & [Record ID#] & " has been marked Completed', {life: 5000, theme: \n'jGrowl-green'});
  • JonathanRoberts's avatar
    JonathanRoberts
    Qrew Cadet
    7 years ago
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&_fid_11=Complete" &
        "&rdr=" &

    URLEncode(URLRoot() & "db/" & [_DBID_SCHEDULE] & "?a=q&qid=15")
  • JonathanRoberts's avatar
    JonathanRoberts
    Qrew Cadet
    7 years ago
    Works Great! Does this take you to same place on the page or just same page?

    Thank You!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    It refreshes the page so the user knows something happened and can see the effect of pushing the button.  It probably does not go back to the same spot.