Forum Discussion

StevenNelson's avatar
StevenNelson
Qrew Member
4 years ago

URL button to edit then refresh page

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#]...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

In fact this should refresh the page you were on ..

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

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

    "&_fid_37=Completed" &

    "&_fid_39="&Now() &

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




& "&rdr="&URLEncode( URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
TateForgey's avatar
TateForgey
Qrew Assistant Captain
10 months ago

FYI - As of today this is no longer working for me. This worked for a while, but I can only assume something changed in QB that prevents this from working properly. I am brought to the home page of the app using this code now. :(