I’m using Airtable as a stock system and I need a simple web interface and a counting script to help an automate some tasks.
The purpose of the script is to get the total amount of items in stock + how many more need to be ordered. What is a bit complicated is the way the products are listed in our database.
The structure of a product is as follows:
Product01 -> Assemblies01-09 -> sub-assemblies -> raw material
In the web interface, I would like to have have a form saying “How many products do you need?”, I put a number, the script loops through the different assemblies and components and outputs a nice order list.
If you think you are up for it, we can go into more details