Hi,
We need to collect longer testimonials (round one A4) from hundreds of clients during a year, process them (re-write and polish before publishing) and have the clients approve the edits.
Ideally I would just create fields for this in Airtable (draft -> approve button -> final -> published), but to my understanding Airtable doesn't allow free user to edit anything sent out form the base. And forms are made to be one-to-many, not enabling a form per client to be sent out, non?
We use Google Sheets so I somehow vaguely think this should be doable with some creative Sheets integrations, but I can't envision it concretely.
Anybody out there who could see this clearly, what would be the elegant and robust way to do it?
Björn
PS. We use Zapier also, so that is a viable option. For cost and maintenance reason I'd prefer not to use other third party systems.