Discussions

Expand all | Collapse all

EditRecord URL button functional (errcode 0) but doesn't edit record (num_fields_changed 0)

  • 1.  EditRecord URL button functional (errcode 0) but doesn't edit record (num_fields_changed 0)

     
    Posted 10-24-2018 13:47
    I'm attempting to build a button that changes the "Status" (ie. FID 52) of a record to "Complete"

    Here's my formula: 
    URLRoot()&
    "db/"& Dbid()&"?a=API_EditRecord&rid="&
    [Record ID#]&
    "&apptoken=XXXX"&
    "&_fid_52=Complete"
    & "?a=dr&rid=" & [Record ID#]

    I receive the below xml:
    <qdbapi>
    <action>API_EditRecord</action>
    <errcode>0</errcode>
    <errtext>No error</errtext>
    <rid>243</rid>
    <num_fields_changed>0</num_fields_changed>
    <update_id>1540387215968</update_id>
    </qdbapi>

    The button is not updating the fid 52 value- any ideas? 


  • 2.  RE: EditRecord URL button functional (errcode 0) but doesn't edit record (num_fields_changed 0)

    Posted 10-24-2018 14:20
    TRY THIS:

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=xxxxx&rid=" & [Record ID#] &
    "&_fid_52=" & URLEncode("Complete") &
    "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])


  • 3.  RE: EditRecord URL button functional (errcode 0) but doesn't edit record (num_fields_changed 0)

     
    Posted 10-24-2018 14:36
    Thanks for the speedy reply, but unfortunately this formula did not resolve my issue. 

    The field in question ("Status" fid 52) is Type: Text - Multiple Choice, do you think that could affect it? There are two choices for this field: Initiated, Complete


  • 4.  RE: EditRecord URL button functional (errcode 0) but doesn't edit record (num_fields_changed 0)

    Posted 10-24-2018 14:39
    A true text-multiple choice field should not have any issues.  Only a List-Text field would need to be handled differently.  If you would like to call me, we can do a screenshare to troubleshoot. My # is 626 771 0454