Hi guys, might be a simple question for you, but I’m just starting with airtable.
In my database I have 1 tab called “Inventory”, where I track my stock of products and 1 tab called “Purchase Orders”, where I track purchases that employees do via a f...
@Julian_Kirkness Any other ideas? E.g. work with IF functions to search for validity in another tab: e.g. In Excel it would be something like =IF(Purchase Orders!D:D =“Product Stock”;“Product Stock”;“Other Inventory”) D:D would be column “Inventory c...
Julian_Kirkness:
I don’t think this is going to be possible in the way you hope. The grouped view can only show a record once and therefore cannot be in two groups.
Hm I thought it might can work as it is not exactly the same record twice, bec...
Its also set via a Purchase Orders Form. It is mandatory to decide when filling out the Purchase Orders Form, whether the item belongs to the Product Stock (that can be sold immediately) or to the Other Inventory (e.g. Office Supply).
Attached is act...
Hi. I try to explain:
The Inventory Table should be a fixed table with fixed products where nothing will be edited manually in the future. All things like stock quantity, products ordered and products sold, change automatically according to the data ...
