Hi @Andrew_Poon - you could definitely implement a workflow with Airtable, Zapier and Typeform.
Let’s say your table is something like this:
The fields to have in this record are:
- The record ID
- the attachment
- the client’s email
- a checkbox to initiate sending to the client
- A Typeform URL that includes the record ID
- A checkbox to indicate client approval
- A notes field to get feedback from the client
The process would work like this:
- Create your record, with attachment, client email etc.
- When ready check the checkbox “send to client”
- You have a view on this table which filters records to show only those where “send to client” is checked
- In Zapier use the trigger “when new record added to a view” to initiate the Zap (the Zap is based on the filtered view, so you checking the checkbox is the action that starts the Zap process)
- In Zapier use the “send email” action to send an email to your client using the email address in the record, attaching the attachment and so on.
- Crucially you will point them to a Typeform form (using the URL in the table) which allows them to give approval and make comments.
- You then have another Zap that picks up the responses from the Typeform form and sends them back to Airtable.
The Record ID in the Typeform URL is a Typeform “hidden field” (note that this needs a paid Typeform plan rather than the free plan, I think). This hidden field value would be used in the return Zap to find a record in AT, then update it with the client’s responses.
As far as I know, you can’t use an AT form to collect the client responses - although you can prefill fields on an AT form, you can’t prefill a record ID or an autonumber. You could have another field type as the record “key” e.g. email, and prefill this, but then you get into the problem of having the same email address on multiple records. Something totally unique like record ID is what you want here.
(Note that there might be a few wrinkles in the process to work through - I haven’t built this exactly, but have built something similar in the past.)
Hope this helps!