Skip to main content
Question

URL button to edit then refresh page

  • September 2, 2021
  • 0 replies
  • 511 views
Forum|alt.badge.img+3
I put the following code into a Formula URL field.  The purpose is to change the status to completed by clicking the button.

URLRoot() & "db/" & [_DBID_LOTO] & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_37=Completed"

Works great, but it then goes to the response page below.  Which I don't want.  How do I modify the code above to simply change the status and refresh the page.



------------------------------
Steven Nelson
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+3
  • StevenNelson
  • Author
  • Registered
  • September 2, 2021
I figured it out

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &

    "&rid=" & [Record ID#] &

    "&_fid_37=Completed" &

    "&_fid_39="&Now() &

    "&_fid_44="&UserToName(User(),"FF")&

    "&rdr=" &

    URLEncode(URLRoot() & "db/" & AppID())



------------------------------
Steven Nelson
------------------------------
MarkShnierYou
Forum|alt.badge.img+24

Tate, I'm happy to help, but please post your code.  We don't know what "This" is.

Mark Shnier. Your Quickbase Coach
TateForgey
Forum|alt.badge.img+7
  • TateForgey
  • Registered
  • June 13, 2024

Good news and bad news. I had an inkling as we were chatting and testing just confirmed that this is an issue related to the new navigation. When I switched back to the top navigation in "My Preferences" this button worked as expected. Switching back to the side nav resulted in the incorrect redirect again. So, that seems like a solid thing for QB to track down.

It is important to remember this is a feature that still in beta, but I'm still keeping side nav on. It is just too good! I'll put in a bug report now. I expect the other weird redirects were caused by the new nav as well. 

    Terms & ConditionsAccessibility statement