Automatically insert multiple records based on logic on newly inserted row

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 ?

Welcome to the Airtable community!

While an Airtable automation can create new records, if you do not know the exact number of records to create in advance, you would need to use a scripting action to create the records.