Skip to main content
Best answer

How to delete old records from Zapier tables?


JoseMendioroz
Forum|alt.badge.img

Besides adding a delay when a new record is created, then delete this after a certain time (avoiding several zaps in playing status).

 

Is there an automated way to delete old records from a table? 

 

Use Case:

Let’s say I want to delete 1000 records from a table when it reaches the limit (10,000 records) → Automatically, maybe a new zap to control this?

Best answer by Troy TessaloneBest answer by Troy Tessalone

@JoseMendioroz 

Feedback can be submitted to the Zapier Tables team here: https://eap.zapier.app

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @JoseMendioroz 

Good question.

Try this Zap action: Zapier Tables - Delete Record

 


JoseMendioroz
Forum|alt.badge.img

Hi Troy,

 

This asks for the record ID to be deleted, I need (for example) to provide the first 1000 records


Troy Tessalone
Forum|alt.badge.img+14

@JoseMendioroz 

Might be easier to do manually in the Zapier Table.

 


JoseMendioroz
Forum|alt.badge.img

Can Zapier automate this for us?

Or maybe add a funtion in Utulities to count Zapier table records?


Troy Tessalone
Forum|alt.badge.img+14

@JoseMendioroz 

Yes, if you know the required values for the Zap action.

 

Try this Zap action: Zapier Tables - Delete Record

 


JoseMendioroz
Forum|alt.badge.img

Great! 

The required value = The first 1000 records created in the table

Zapier should consider this, to automate the hability to count records from first record created, from a period of time, filtering and counting rows like in any other table, etc.

Thanks for your help Troy, I’m afraid we may need to wait for this.


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31340 replies
  • Answer
  • July 18, 2023

@JoseMendioroz 

Feedback can be submitted to the Zapier Tables team here: https://eap.zapier.app


JoseMendioroz
Forum|alt.badge.img

Thanks!