URL button to edit then refresh page

Question

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

markshnier__you · Answer

In fact this should refresh the page you were on ..URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;
&nbsp;&nbsp;&nbsp; "&amp;rid=" &amp; [Record ID#] &amp;
&nbsp;&nbsp;&nbsp; "&amp;_fid_37=Completed" &amp;
&nbsp;&nbsp;&nbsp; "&amp;_fid_39="&amp;Now() &amp;
&nbsp;&nbsp;&nbsp; "&amp;_fid_44="&amp;UserToName(User(),"FF")
&amp; "&amp;rdr="&amp;URLEncode( URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl())------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

tateforgey · Answer

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.

ben_simon · Answer

TateForgey MarkShnier__You I tracked down an existing escalation that's already open for this.
Tate, your support case can get added to it. At the very least, it's a bug Quickbase has on its radar and product team is working through a resolution for.

stevennelson · Answer

I figured it out
URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;
&nbsp;&nbsp;&nbsp; "&amp;rid=" &amp; [Record ID#] &amp;
&nbsp;&nbsp;&nbsp; "&amp;_fid_37=Completed" &amp;
&nbsp;&nbsp;&nbsp; "&amp;_fid_39="&amp;Now() &amp;
&nbsp;&nbsp;&nbsp; "&amp;_fid_44="&amp;UserToName(User(),"FF")&amp;
&nbsp;&nbsp;&nbsp; "&amp;rdr=" &amp;
&nbsp;&nbsp;&nbsp; URLEncode(URLRoot() &amp; "db/" &amp; AppID())------------------------------Steven Nelson------------------------------

stevennelson · Answer

I changed field 44 to a user field.&nbsp; I need to get rid of the "usertoname" part of the code but when I do it says "&amp;" cannot be applied to a user field.&nbsp; What am I doing wrong?"&amp;_fid_44="&amp; User()------------------------------Steven Nelson------------------------------

Forum Discussion

URL button to edit then refresh page