Make a button generate a quick note

Question

Hello,I've made a field called CALL BUTTON (Showing as Called) as a formula - URLThis button is intended to add a note to a notes field called "Call Log". The note will be timestamped and label it as:

"[Timestamp, User] Call made"Can someone support me with the appropriate input? Thank You

------------------------------Anthony Wong------------------------------

ahuvabrown · Answer

It sounds like you can use the EditRecord API

Assuming the field id of the notes field is 6:
https://target_domain/db/target_dbid?a=API_EditRecord&rid=[rid of record to update]&_fid_6=[value to input]&apptoken=app_token&rdr=[url to redirect to after updating]

------------------------------
Ahuva Brown
------------------------------

francescospiga1 · Answer

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
------------------------------

anthonywong1 · Answer

Hello,Thank you for your swift response!I added the URL and changed app token to : Calledand 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------------------------------

ahuvabrown · Answer

Can you post your url and error message?------------------------------Ahuva Brown------------------------------

anthonywong1 · Answer

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.

&lt;qdbapi&gt;

&lt;action&gt;API_EditRecord&lt;/action&gt;

&lt;errcode&gt;34&lt;/errcode&gt;

&lt;errtext&gt;You cannot change the value of this field&lt;/errtext&gt;

&lt;errdetail&gt;The field named "Customer - Address" with field id 9 cannot be modified&lt;/errdetail&gt;

&lt;rid&gt;111&lt;/rid&gt;

&lt;num_fields_changed&gt;0&lt;/num_fields_changed&gt;

&lt;update_id/&gt;

&lt;/qdbapi&gt;

----------------------------------------------Here's the URL I put for the button:URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;"&amp;rid=" &amp; [Record ID#] &amp;"&amp;apptoken=Called Customer" &amp;"&amp;_fid_9=Completed" &amp;"&amp;rdr=" &amp;URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp;"?a=dr&amp;rid=" &amp; [Record ID#])Thank You again for the support------------------------------Anthony Wong------------------------------

Forum Discussion

Make a button generate a quick note

9 Replies