I’m still relatively new to AirTable, but I have grand plans. I’ll try to explain this simply, if I can.
I have a table full of a list of rooms that I provide support to. These rooms have equipment in them that needs to be refreshed occasionally and relies on standard packages to do so. These packages often share several items across them, but sometimes in different quantities. What I have figured out:
- Created the table with a list of items and I can link those items to another table that brings in their summed costs in the form of a package.
- Link those summed costs to their room on another table.
Here is where I am stuck:
- I cannot increase the quantities of items without it affecting all the items across packages.
- I cannot seem to export the final list of equipment in any meaningful way.
I tried looking at the “Product Catalog” template, but nothing immediate jumped out as a solution. The only way I’ve been able to make it work is to create a new table for each package; which would be fine except there are around 15 or so room packages, so the tabs start getting a little unwieldy.
Is this the right way and I just have to live with it, or is there another clever way and I am just missing it?
Thanks for any help in advance.