Sep 22, 2022 08:40 AM
I have a base that I have configured for an event. At the event, we will collect ideas in real-time and enter them into the table. At the end of the event, I would like to be able to send out a form that allows participants to rank each listed idea in the table for at least two categories. Ideally, the form will have each idea listed with the ranking options below each one. Once participants have all filled out the form, I would like to be able to average all of the collected data.
Do you know how to set up a form like this and configure my base to allow this to work? If not, do you have suggestions on other routes or programs to take?
Any and all help is appreciated! Thank you in advance
Sep 22, 2022 10:22 AM
Hi @Amber_Neil,
You can prefill forms with existing data in your base, so that new form submissions already contain the data you want (Ideas).
https://support.airtable.com/docs/prefilling-a-form
Depending on how your data is configured, Airtable will display average for you automatically.
Sep 26, 2022 10:02 AM
Thank you so much!