Creating a number of records based on a formula result; and keeping track of that count

I am trying to set up a production calendar for my bakery. I calculate my total orders for a product based on a table that takes in a spreadsheet from my inventory software (SOS Inventory). This generates a “number of bakes” based on the yield of 30 units per bake approximately.
What I want to do is have the table compare the number of bakes scheduled to the number needed, and generate additional records (bakes) that I can then add to the production calendar by assigning them to a date. In other words, I drag the unscheduled bake to a date on the calendar and it’s scheduled.
In other words, if I need 90 units of a product, it tells me I need to do 3 bakes. If I have to make 120 units of another product, and there are two bakes scheduled already, it tells me I need two bakes.
Can this type of thing be done in Airtable??

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.