Hi,
I' new to Airtable.
What I'm trying to do is to create a gantt chart with the start and end dates for the phases in a record to follow up the peoples workload which is different for each phase of a project.
In one table I have the phases of a project in one record.
I want them in a chart like below.
I can create this with an automation via a "planning" table but I can't seem to update this table when a date changes in the original table. The link in the original table to the planning table contains the ID of each created record in the planning table (so 4).
Can some one help me ?
An alternative is to delete all data in het planning table on a certain time interval and rebuild the entire table but I cant find the way to delete all the records in a table.
thanks,
Koen