I am new to Airtable and setting up coaching system.
A batch (table Batch) will have start & end date and one batch will have one coach. I have another table (CoachBandwidth) to calculate the coach bandwidth based on its allocation. Coach can be part of multiple Batches.
If the batch is of 4 month duration from Sep 2021 - Dec 2021 than I need 4 records to be inserted/updated for each month (Sep, Oct, Nov, Dec 2021) based on number of student it is coaching.
How can I achieve inserting multiple records (table CoachBandwidth) based on new record added into table Batch ? Is it possible to achieve using Airtable Automation or any other suggestion ?