Help

Auto Generated "Form Completion" Status?

Topic Labels: Base design
1594 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jenna_Fiore
4 - Data Explorer
4 - Data Explorer

Hi!

Is there a way to track completion of forms that are sent to a contact list in one of the tables? We want to send a form to everyone and then see who has or has not completed it yet.

Furthermore, some people may need to complete the feedback form multiple times (about a different person/experience each time) so ideally we can see their completion status by the person/experience they are providing feedback on.

Any recommendations? Thank you!

1 Reply 1

Welcome to the community, @Jenna_Fiore! :grinning_face_with_big_eyes: This is probably doable, but it’s not a simple “turn on this feature” solution. Long story short, you need a way to create links between the incoming forms and the contacts who filled out those forms. This can be done either using internal tools, or external tools.

Internally, Airtable has added a beta feature that would allow you to trigger a script under certain conditions, one of which is the addition of a record to a table. With this, the script could trigger each time a form submission comes in, and the script could match the email address (or other contact info) collected by the form with info in the contact table, and link the form to the correct contact when a match is found.

Externally, you could use a tool like Zapier or Integromat to do something similar. In that case, you’d trigger off of a new record in a view, with the view picking up on new form submissions by the lack of a link to a contact record. You would then search your contact table for that matching contact info, creating a link if a match is found.

If you’d like more detailed help with either option, let us know and we’ll do our best!