Hello there,

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

Thanks!

Guy G