Skip to main content
Best answer

How to delete old records from Zapier tables?

  • July 18, 2023
  • 8 replies
  • 779 views

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 Tessalone

@JoseMendioroz 

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

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 18, 2023

Hi @JoseMendioroz 

Good question.

Try this Zap action: Zapier Tables - Delete Record

 


JoseMendioroz
Forum|alt.badge.img
  • Author
  • Beginner
  • July 18, 2023

Hi Troy,

 

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


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 18, 2023

@JoseMendioroz 

Might be easier to do manually in the Zapier Table.

 


JoseMendioroz
Forum|alt.badge.img
  • Author
  • Beginner
  • July 18, 2023

Can Zapier automate this for us?

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


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 18, 2023

@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
  • Author
  • Beginner
  • July 18, 2023

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • July 18, 2023

@JoseMendioroz 

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


JoseMendioroz
Forum|alt.badge.img
  • Author
  • Beginner
  • July 18, 2023

Thanks!