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

  • 1
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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?
Photo of Jonathan Roberts

Jonathan Roberts

  • 174 Points 100 badge 2x thumb

Posted 7 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
Can you post your current formula for the URL formula field?
Photo of Jonathan Roberts

Jonathan Roberts

  • 174 Points 100 badge 2x thumb
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    "&_fid_11=Complete" &
    "&rdr=" &

URLEncode(URLRoot() & "db/" & [_DBID_SCHEDULE] & "?a=q&qid=15")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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.
Photo of Ryan

Ryan

  • 120 Points 100 badge 2x thumb
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'});"
Photo of Jonathan Roberts

Jonathan Roberts

  • 174 Points 100 badge 2x thumb
Oh that's cool! thanks
Photo of Jonathan Roberts

Jonathan Roberts

  • 174 Points 100 badge 2x thumb
Works Great! Does this take you to same place on the page or just same page?

Thank You!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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.