Forum Discussion

ARademacherARad's avatar
ARademacherARad
Qrew Member
11 years ago

URL Formula Button Refresh current page not Redirect

What I have now is an application dashboard for our Director to select a name of a manager. Then it takes them to individual Dashboards with ALL of the reports for that one manager on the page for employee performance metrics (measured across multiple tables and entry points). One report on the dashboard is a "Address at the next 1:1" list. On the report i have a URL button field that changes the status from "Address" to "Closed" so that the director can just click on the button without editing each record every time just to change status and save. One click entry without leaving the dashboard view.

Since i cannot redirect to the main table dashboard (since she would have to select the name and re-enter the specific employees dashboard). I would like for the page to just refresh itself on the current dashboard. Keep in mind that i cannot code a specific dashboard since there are 40+employee dashboards each with a different URL that utilize the same table, but different reports.



Here is what i have:

URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]

& "&_fid_12="&URLEncode("Closed")


& "&rdr=" & URLEncode(URLRoot() & "db/INSERT THE MAIN TABLE ID YOU CAN FIND THIS BY CLICKING HOME") <--I cannot use this because i want to just refresh current page





Found this suggestion on further research, but it gives me "Formula Syntax Errors" when i add this to the bottom of the code below

"javascript:" &

"$.get('" &


$URL &


"',function(){" &


"location.reload(true);" &


"});"


& "void(0);"




Any help is greatly appreciated

APIs and custom code
App home pages
Branding and app management
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    11 years ago
    Xavier Fan posted that info and while I have not tested it yet myself, it should work.



    Try this and do my testing for me. make a formula variable to define $URL and then the code should work. Let us know how it goes.


    var URL =


    URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]

    & "&_fid_12="&URLEncode("Closed");

    "javascript:" &

    "$.get('" &


    $URL &


    "',function(){" &


    "location.reload(true);" &


    "});"


    & "void(0);
  • ARademacherARad's avatar
    ARademacherARad
    Qrew Member
    11 years ago
    That is the exact problem i am having.  I am not able to find anything that will define the $URL as the current page we are on now. I keep getting syntax errors when i use this.. Something else i just tried

    URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_12="&URLEncode("Closed")
    & "&rdr=" & URLEncode(URLRoot() & "javascript:location.reload(true))")  <-but the java is not able to be used like that, but at least i get to a 404 error page and can hit my back button.   

    Any other ideas to define $URL as the current page?


    The above sample did not work.

    var URL = ??******MISSING FORMULA TO DEFINE THE CURRENT PAGE URL*******??

    URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]

    & "&_fid_12="&URLEncode("Closed");

    "javascript:" &

    "$.get('" &

    $URL &

    "',function(){" &

    "location.reload(true);" &

    "});"

    & "void(0);"
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    11 years ago
    You did not try what I suggested.
    I gave you the exact code to try but it had a small syntax error.  This is tested.


    var text URL =
    URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_12="&URLEncode("Closed");

    "javascript:" &
    "$.get('" &
    $URL &
    "',function(){" &
    "location.reload(true);" &
    "});"
    & "void(0);"
    • AdminEntry's avatar
      AdminEntry
      Qrew Cadet
      8 years ago
      I have noticed that this code doesn't always work for some reason. It's not consistent, but when the button is clicked, the form or report is just refreshed but the action is not performed. Have you experienced this at all or have any idea why that would be? This happens regardless of which browser is being used.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      8 years ago
      Juan
      You should clearly state your question in a new post and perhaps just reference this post with a link as we have no idea what your code is.
    • AdminEntry's avatar
      AdminEntry
      Qrew Cadet
      8 years ago
      Sorry, I was just referring to the example to which I added my comment:

      URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&_fid_12="&URLEncode("Closed");

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

      I noticed that the edit action does not always get executed, although the refresh (reload) does. Sometimes the records just don't get updated.

      I'll create a new post if I still need an answer. Thanks!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    Kerry-Ann
    Did you try code like this?

    var text URL =
    URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_12="&URLEncode("Closed");

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

    In that example, the field being updated is field ID#12