Airtable Script: Freeze Time and Delete After Records

Topic Labels: Scripting
542 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hello Airtable Community!

I'm looking to enhance my tables and I believe using scripts could be a helpful solution.

Here's the issue: I have a database where company managers provide monthly forecasts for income and costs on their respective projects. Currently, I've set up an Airtable automation that detects the start of a new project and adds a record to the managers' table.

However, I have a gap: when a project is completed, I want Airtable to lock in all the data entered up to and including the project's end date, and then remove any predictions made after that date. Does anyone have a solution for achieving this? Your assistance would be greatly appreciated!

0 Replies 0