Forum Discussion
FrancescoSpiga1
4 years agoQrew Cadet
Sounds like you just need a simple API_EditRecord.
Also, you need to activate the "log entries" option on the property of the field so it would keep track of who/when as well.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=apptoken" &
"&_fid_id=Completed" &
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & [Record ID#])
Replace the the values in bold with 1) app token 2) field id of your notes field
Hope this helps.
------------------------------
Francesco Spiga
------------------------------
Also, you need to activate the "log entries" option on the property of the field so it would keep track of who/when as well.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=apptoken" &
"&_fid_id=Completed" &
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & [Record ID#])
Replace the the values in bold with 1) app token 2) field id of your notes field
Hope this helps.
------------------------------
Francesco Spiga
------------------------------
- AnthonyWong14 years agoQrew Member
Hello,
Thank you for your swift response!
I added the URL and changed app token to : Called
and the ID to 10 since my multi text field is in slot 10 of the table.
It's still giving me an error message. Am I missing something or mistaken an action step?Thank you again for the support.
------------------------------
Anthony Wong
------------------------------- AhuvaBrown4 years agoQrew CadetCan you post your url and error message?
------------------------------
Ahuva Brown
------------------------------- AnthonyWong14 years agoQrew Member
Hello,
Here is the error message:Please note, Field ID 9 is no longer customer address. It's a multi text field called Contact Log.
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>34</errcode><errtext>You cannot change the value of this field</errtext><errdetail>The field named "Customer - Address" with field id 9 cannot be modified</errdetail><rid>111</rid><num_fields_changed>0</num_fields_changed><update_id/></qdbapi>
----------------------------------------------
Here's the URL I put for the button:
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=Called Customer" &
"&_fid_9=Completed" &
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & [Record ID#])
Thank You again for the support
------------------------------
Anthony Wong
------------------------------