Hello- I’m looking for some help with an automation/formula in airtable.
I have a table called Inventory that has all of my products in it. I have a view that contains priority level of what needs to be produced next and the amount of space it takes up during production by product.
I have another table with kiln loads (production) that I need to link all of these records to automatically by priority level and not have the kiln space exceed 90% (I have a rollup field that sums the space taken by each product). Essentially, I need the automation to start linking the products to be produced on the first record, once that reaches a max of 90% space, start linking them on the second record, and so on until all of the products to be made on the first table are linked to a kiln load.
I’m pretty good at airtable but this one has me scratching my head. Thanks for any help in advance!