Forum Discussion

JenniferJuhasz's avatar
JenniferJuhasz
Qrew Trainee
10 months ago

Check-in button that refreshes report and doesn't open the record

Hi everyone,

I hope this is a simple question.  

I have a check-in button that works (yay), but I want it to refresh the table report that it's in, and not open the record.  Is that possible?

My code is:

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    "&apptoken=ye9hbxcau45itjjdkhccw9ccsg" &
    "&_fid_28=1" &
    "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() &
        "?a=dr&rid=" & [Record ID#])

and it Does work and do exactly what I want it to, I'm just hoping to keep the table report open, so a person can quickly just go down the list and click 'check in' for each.

(Note - while the button is just changing a check box from unchecked to checked, my end users who will be completing this action will not be opening the report in 'grid edit' mode - I realize there are options for this, but I just want to give them this one table report and have them click 'check in' and have the report refresh)

I did research the forums for historical examples, but I can only find Javascript options, which I believe I can't use.

Thank  you for any thoughts!



------------------------------
Jennifer Juhasz
FamilySmart
BC, Canada
------------------------------

3 Replies

  • np, there is magic syntax which will refresh whichever page you are on.  Here us an example  

    Just use your URL instead  

    var text Approve = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#])
    & "&_fid_144=Approved";

    var text RefreshPage =  URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

     
    $Approve
    & "&rdr=" & URLEncode($RefreshPage)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JenniferJuhasz's avatar
      JenniferJuhasz
      Qrew Trainee

      Thank you Mark! That example helped me a ton; I was able to make the correction and it's working now.

      I so appreciate your time and guidance!

      Take care,



      ------------------------------
      Jennifer Juhasz
      FamilySmart
      BC, Canada
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        It's a very useful Technique, because that way you can have the button on whatever report you want or even on the record and it's simply refreshes whatever page you are on. 



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------