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??