I have made inventories Airtables with a combination of inventories, buys, sells and orders, so it can be done. I do think I don’t understand this bit completely… Your staff sells something, use a form to submit that sale, but then add a checkmark?
not exactly: it’s the wine cellar of a restaurant. Every day we sell wine bottles and regularly we buy new ones. That part is easy with a rollup field.
every month an inventory is made, and sometimes it has to be adjusted: there should be 10 bottles but there are just 8. We can add a -2 but I rather write the count (when people has to do calculations tend to make mistakes).