I tried to find anything close to what I’m building, using Airtable and decided to open this topic. I’m operating small print shop with design and photo services. I have a needs to have preset products and services catalogue for fast estimation and automated inventory. Then using separate tabs to collect estimates and then force them to invoices.
Here is an issue. If I deciding to change any data in the Product Catalogue or Material’s Inventory its automatically updates closed estimates and invoices. Is there any way, maybe when you change status of the estimate and invoice its lock the data they way it is on the time of closing?
Thank you in advance for any information!