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!
