I’ve started designing an AirTable to replace my Excel file to keep track of theatrical lighting template stock by my theater. This image shows where I’m at:
Now, to make this user friendly on computers and mobile, I would like to be able to use the tables as a “grid view”. For example, If I click on a table labeled SL 300, any template with an inventory count of >1 in size SL300 will show up in that table with all the information from the main table.
I have a grid view set up this way, but my testers couldn’t find it.
Also, I would like to be able to track which production is using which templates and thus how many in each size are available for others to use. For example, G579 size A is often used in up to 3 shows at a time. How would I set up a table to show usage and availability and have that show up in a search?
Thanks for any help!