Discussions

Expand all | Collapse all

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.  How can I have a URL button return to where ever it was clicked from? Like same report or homepage that has the report.

    Posted 05-02-2018 16:27
    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?


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

    Posted 05-02-2018 16:38
    Can you post your current formula for the URL formula field?


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

    Posted 05-02-2018 16:41
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&_fid_11=Complete" &
        "&rdr=" &

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


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

    Posted 05-02-2018 16:45
    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.


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

    Posted 05-02-2018 16:56
    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'});


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

    Posted 05-02-2018 18:20
    Oh that's cool! thanks


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

    Posted 05-02-2018 16:51
    Works Great! Does this take you to same place on the page or just same page?

    Thank You!


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

    Posted 05-02-2018 16:56
    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.