Over the course of a project we will be conducting a series of feedback surveys, each with the same questions, but after different events. I plan on storing responses to each survey in its own table within a base. Is there a way to duplicate the form to different tables? I will need to do some minor updates (e.g., changing the introductory text), but the questions would be the same.
Solved
Way to duplicate a feedback form with different tables for different events?
Best answer by ScottWorld
You cannot do that, and it is typically not a good idea to create different tables for collecting the same exact information.
Ideally, you would want to create just one table for your form answers and then you can filter based on event.
This is because a database app is supposed to reduce redundancies and create powerful automations & integrations. This can only be accomplished if you store similar records in the same table.
It is also highly recommended to use Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, and so much more.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+20You cannot do that, and it is typically not a good idea to create different tables for collecting the same exact information.
Ideally, you would want to create just one table for your form answers and then you can filter based on event.
This is because a database app is supposed to reduce redundancies and create powerful automations & integrations. This can only be accomplished if you store similar records in the same table.
It is also highly recommended to use Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, and so much more.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
ScottWorld wrote:
You cannot do that, and it is typically not a good idea to create different tables for collecting the same exact information.
Ideally, you would want to create just one table for your form answers and then you can filter based on event.
This is because a database app is supposed to reduce redundancies and create powerful automations & integrations. This can only be accomplished if you store similar records in the same table.
It is also highly recommended to use Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, and so much more.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Well, that's frustrating. I don't really want people selecting events from a drop-down menu. Filtering by date might work, but only if two events don't occur on the same day or within a few days of each other.
Also, while the questions are the same, the data wouldn't ever be analyzed together. Hm. Probably should use a different tool, maybe. I was hoping this would be an easy way to manage surveys from a single team hub, without needing to personally create each survey.
+20They don’t necessarily have to select from a dropdown menu. You could prefill and hide the event name, as long as you give them different form URLs for each event.
If you want separate forms, you can still duplicate forms within the same table, which, as mentioned earlier, is the best way to go.
- ScottWorld, Expert Airtable Consultant
+2You can both prefill and hide fields on a form.
For your use case, assuming that you have a table containing all of the events, you can create a link between the Events table and the Feedback table. After a given event, you would send out the feedback survey with the form containing parameters to prefill and hide the linked Event field.
The only feature you are missing at this point is the ability to change the introductory text.
Security note: if a user were to load the form with the additional URL parameters stripped, they would be able to see and select other events. If the form link is sent out through an email with the link embedded in text, it will load the form link correctly by default. Any user with even mild hacking experience might recognize that they can strip the URL parameters to reveal the hidden field, though. If having your events list exposed is not a matter of concern, you can disregard this.
If you are willing to use a third party tool, you can use Fillout the create the form (still one single form). You would then still have it prefill and hide the link to the Event field, but you can have a text field that changes dynamically based on the linked record. In this scenario, you would have another field in your events table containing the introductory text that you'd like on the survey for each given event.
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.