How to send out survey regarding existing data

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

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.

Thank you so much!

HTA logo small for sig block.jpg