Forum Discussion

GeorgeBramhall1's avatar
GeorgeBramhall1
Qrew Member
4 years ago

What's wrong with this URL button formula

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
------------------------------
APIs and custom code
Buttons

2 Replies

Sort By
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    4 years ago
    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
    ------------------------------
    • GeorgeBramhall1's avatar
      GeorgeBramhall1
      Qrew Member
      4 years ago
      Bingo! Worked like a charm. Thanks Mike!

      ------------------------------
      George Bramhall
      ------------------------------