Skip to main content
Question

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

  • May 2, 2018
  • 0 replies
  • 153 views

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?
This topic has been closed for replies.

Can you post your current formula for the URL formula field?

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

URLEncode(URLRoot() & "db/" & [_DBID_SCHEDULE] & "?a=q&qid=15")

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.

Works Great! Does this take you to same place on the page or just same page?

Thank You!

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.