Based on existing Airtable data structure I used TypeForm API to dynamically create new forms at the end of each week. This meant that the forms were highly specific and it made it easier for customers to pass feedback about recent changes. Along with these forms a webhook was dynamically created as well, which allowed to correctly capture responses for each of these newly created forms.
- Forms table gathered information about each new dynamically created form
- Responses table gathered all form submissions
- Formulas & rollups summarized certain metrics from the form per each form (week)
- Airtable interfaces allowed browsing all of the collected feedback and displayed charts for the numeric metrics
In certain cases feedback form may be the same all the time. But in other situations it’s much better to create forms dynamically - for organized events, courses, workshops it might be useful to generate specific questions based on people involved, topics and other criteria.
This likely leads to higher submissions too as the survey seems more personal and of higher quality.