Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
3 years ago

Error in a URL Button

Can someone tell me what's wrong with my URL Formula button code: (fid 21 is a date field)

Here is my URL Code 
URLRoot() & "db/" & [_DBID_RECEIPTS] & "?act=API_EditRecord" &
"&rid=" & [Maximum Unsent Receipt Record ID#]& "&apptoken=cz33dcb8h2qfbp4evmdpbw2hd &_fid_21=" & Today()&
"&rdr=" & "&z=" & Rurl())

And here is my 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>44</rid>
<num_fields_changed>0</num_fields_changed>
<update_id>1643228728393</update_id>
</qdbapi>


------------------------------
George Bramhall
------------------------------
APIs and custom code
Buttons
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Once the user clocks the button  where are you trying to land the user? On the same page they were on?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • GeorgeBramhall2's avatar
      GeorgeBramhall2
      Qrew Cadet
      3 years ago
      Yes...on the same page they were on.

      ------------------------------
      George Bramhall
      ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    var text Update = URLRoot() & "db/" & [_DBID_RECEIPTS] & "?act=API_EditRecord" &
    "&rid=" & [Maximum Unsent Receipt Record ID#]&
    "&apptoken=cz33dcb8h2qfbp4evmdpbw2hd&_fid_21=" & Today();

    var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

    $Update
    & "&rdr=" & URLEncode($RefreshPage)

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • GeorgeBramhall2's avatar
      GeorgeBramhall2
      Qrew Cadet
      3 years ago
      OYE. I tried a URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();...but without the URLRoot() & "db/" & Dbid()

      Thanks as always.

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