Julius_Kratschm - profile

Julius_Kratschm · Nov 27, 2018

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

Julius_Kratschm · Nov 28, 2018

@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...

Julius_Kratschm · Nov 27, 2018

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

Julius_Kratschm · Nov 27, 2018

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

Julius_Kratschm · Nov 27, 2018

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

User Statistics

User Activity

How to assign entries in one tab to different categories in another tab

Re: How to assign entries in one tab to different categories in another tab

Re: How to assign entries in one tab to different categories in another tab

Re: How to assign entries in one tab to different categories in another tab

Re: How to assign entries in one tab to different categories in another tab