I have a Table for Product Creation that is linked to individually tracked Inventory on hand with a rollup to count down available inventory left as it is used in production. So, when I get to a point in production, I need to select multiple matching...
ok I have everything changed and the automation shows they work but when I use airtable the only time the automation updates the record is if I go into automations and press “run as is’”. Why won’t it update automatically on its own as yours have as ...
ok I have that linked but I am having difficulty cascading the remaining total of the Automated record into a new record for production. It will not let you duplicate it to create separate records based on the amount remaining from production. So cou...
Thank you I will try another table linked to the terpene inventory as a usage log. Would that use an Automation to create as well as update the record until inventory is zero then us an identifier to create a view in which I sort by inventory with am...
Here are screen shots of what I have. I can break down the formulas and automations if needed. There are linked record to 2 separate Inventories. I for the Base product and 1 for the terpenes. As I use the terpenes for production, they have to be tra...
