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#]...
Forum Discussion
I figured it out
------------------------------
Steven Nelson
------------------------------
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
------------------------------
- MarkShnier__You
Qrew Legend
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
------------------------------- I changed field 44 to a user field. I need to get rid of the "usertoname" part of the code but when I do it says "&" cannot be applied to a user field. What am I doing wrong?
"&_fid_44="& User()
------------------------------
Steven Nelson
------------------------------- MarkShnier__You
"&_fid_44="& ToText(User())
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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. :(
