Automatically clear file attachment field?

here are some cheat notes that will help.
URL to delete a file attachment

URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_9="
& "&delfile_fid_9=1"
// & "&apptoken=<your apptoken>"





Because someone else might come along looking for this: here's the XML version:

<qdbapi>
<udata>mydata</udata>
<ticket>auth_ticket</ticket>
<apptoken>app_token</apptoken>
<rid>[record_id]</rid>
<field fid="[field_id]" filename="delete"></field>

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

@Alex Gale

It looks like there isn't any explicit support in Pipelines for deleting a file attachment.

You could use the "Make Request" action in the Quickbase Channel under "Quickbase APIs" for this. This basically allows you to create your own custom Quickbase Pipeline Action (You just have to know enough about the API to form the call)

@Mark Shnier (YQC) has done some of the heavy lifting for you in his reply, if you wanted to use the HTTP API instead of the Restful API.

​

​

------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------

Thank you everyone for your help. I was able to use this advice to create a pipeline with an API call that does what I want. I chose a pipeline because I wanted a branching IF condition, but I assume a webhook would have also done the trick.

------------------------------
Thanks,
Alex
------------------------------