# Structuring a delete function using Zapier **URL:** \ **Category:** Knacksters' Idea Lab\ **Created:** [June 9, 2024, 3:15pm UTC](https://forums.knack.com/t/structuring-a-delete-function-using-zapier/17378 "2024-06-09T15:15:27Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![GSH](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/gsh/32/2669_2.png) [@GSH](https://forums.knack.com/u/GSH)\ **Post date:** [June 9, 2024, 3:15pm UTC](https://forums.knack.com/t/structuring-a-delete-function-using-zapier/17378/1 "2024-06-09T15:15:27Z")
I understand why a records based charge model means that having the ability to remove records is commercially damaging. Despite this I do need to find a way to remove records from my [knack.com](http://knack.com) app because otherwise it is not commercially viable and also opens up liability in respect of things like retention policies under GDPR. I has dealt with the issue of GDPR quite nicely using a date stamp plus x days on records that are added to the system and a task that goes through each of those records and clears the data values in them one that date has been reached. While I can do manual deleting by hand, if there was a way to automate this using zapier that would be great as a fallback. I have done some pretty intense API connections with Zapier but am having a roadblock when thinking about how to sequence this with zapier. My trigger choices are: ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/3/3d76a2d0e4a47f717274d714a2022dc1b0e8bcf4.png) What I am thinking is that I am going to need to create a stand-alone table that’s function is to ping Zapier when a specific condition has been met, in this case the condition is that the record has met the criteria for deletion. Anyone got any inspiration for how I can make this run on an existing table where all the main data is stored? Cheers ---
**Author:** ![Godfred](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@Godfred](https://forums.knack.com/u/Godfred)\ **Post date:** [June 9, 2024, 3:35pm UTC](https://forums.knack.com/t/structuring-a-delete-function-using-zapier/17378/2 "2024-06-09T15:35:36Z")
Hello, the easiest way is to use [make.com](http://make.com). [Make.com](http://Make.com) offers the ability to delete records. ![image.png](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/b/b9ec69c19853287b728f8690eb7c6640b65f8d94.png) ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [June 9, 2024, 7:40pm UTC](https://forums.knack.com/t/structuring-a-delete-function-using-zapier/17378/3 "2024-06-09T19:40:29Z")
@GSH - You may find this of some help / inspiration **Managing Cascading Deletes in Knack** Step-by-Step Tutorial! [![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/f/ffb00626523785d7946ea2e40aba534ddeb5ec2b.jpeg "Managing Cascading Deletes in Knack: Step-by-Step Tutorial!") ](https://www.youtube.com/watch?v=eBsOOYOXynU) ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [June 9, 2024, 7:58pm UTC](https://forums.knack.com/t/structuring-a-delete-function-using-zapier/17378/4 "2024-06-09T19:58:11Z")
Hi @GSH We use make to put about 150 to 200 records into one field and we do this for multiple objects, this means we can covert 1000’s of records into 1 record. We use Make to do this but Zapier could do it too. We basically loop through each record and each record becomes 1 line of a table which then gets put back into Knack into 1 rich text field. Once the data is stored we delete all the original data. The really nice thing about this is that using Knack’s classes you can make it look like a normal grid when viewed on the front end. The trigger we use is a form submit but you could use a search trigger too and run it periodically. If you’d like more info please get in touch. It’s a fairly straightforward setup once you’ve done it once. Craig ---
**Author:** ![GSH](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/gsh/32/2669_2.png) [@GSH](https://forums.knack.com/u/GSH)\ **Post date:** [June 10, 2024, 6:44am UTC](https://forums.knack.com/t/structuring-a-delete-function-using-zapier/17378/5 "2024-06-10T06:44:56Z")
Thanks both these were really helpful. Will try option 1 for now before making option 2 if things go well and I can’t afford the API credits!