Skip to main content
Question

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

  • August 14, 2023
  • 0 replies
  • 71 views

Forum|alt.badge.img+7

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

MarkShnierYou
Forum|alt.badge.img+24

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
------------------------------