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

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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? 
Photo of AO

AO

  • 304 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,266 Points 2k badge 2x thumb
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#])
Photo of AO

AO

  • 304 Points 250 badge 2x thumb
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
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,266 Points 2k badge 2x thumb
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
(Edited)