Hello,
To manage a catalog of goodies for a company, I've started building a database, forms and an interface.
The goodies catalog has about 30 items in 3 categories. Some items are textiles with 7 different sizes.
The 30 items are common to different entities of the company, but the stocks are different from one entity to another. (1 entity by city)
I built the following tables:
Entitie,
Sizes,
Categories,
Objects,
Received items,
Distributed items.
The last two have a form for entering what has been received or distributed.
Finally, the interface displays the catalog with all the items and quantities for an agency.
After this long intro, I share you my problem:
To display the stock by size for a given item (textile) and for an agency, I can't find any other solution than to calculate stock for each agency by creating a column per item per size per agency.
For each size, I calculate quantity received, quantity distributed and finally stock, i.e. 21 columns per agency ...
I think there's a more optimal way of doing this ...
The Airtable community, do you have any ideas?
Thank you 🙂
