Skip to main content
Question

What's wrong with this URL button formula

Forum|alt.badge.img+6
I am trying to check a checkbox field by clicking this URL Formula button on a record in a report without opening the record to a form and then stay on the report. This worked wonderfully with a javascript rich text button...but....

URLRoot() & "db/" & [_DBID_PLC] & "?act=API_EditRecord"& "&rid=" & URLEncode ([Record ID#])& "&_fid_46=1"
& "db/" & Dbid() & "?a=doredirect&z=" & Rurl()



I am getting this error:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>1579</rid>
<num_fields_changed>0</num_fields_changed>
<update_id>1626883497807</update_id>
</qdbapi>


Style information? What do I need to add to this formula to get it to work?

------------------------------
George Bramhall
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14
I believe the redirect is incorrect. Try this.

URLRoot() & "db/" & [_DBID_PLC] & "?act=API_EditRecord"& "&rid=" & URLEncode ([Record ID#])
  & "&_fid_46=1"
& "&rdr="
  & URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())

------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement