I run a renovation and interior design firm. I thought Airtable was going to be the ultimate solution and have spent months perfecting my bases. We need a database of products and materials that we can assign to projects and present choices and final selections to our clients. Our clients are not other businesses, they are individual homeowners, so we are not going to ask them to create accounts in Airtable or become collaborators on our internal system. Each product record has a lot of internal pricing information that we do not want to share with our clients. I tried several extensions but they fell short in many ways (only show one record at a time, only show certain pre-set fields, etc). I tried creating a shared, curated view but our clients could still open and view any field they want. The list view looked fantastic but there's no way to share OR print! I spent hours creating awesome interfaces just to discover they're only available for internal staff (what's the point???).
I'm at a total loss and I'm not a programmer or coding expert or have hundreds of hours to burn. It's so frustrating trying to use "easy" "no code" solutions that turn out to be anything but. I can't be the only B2C business in the world that wants to use the records in my database to populate an attractive live view or report (like I would a shared Google sheet) with my clients.
Any ideas or suggestions are very much appreciated!!
