how to automate distribution of a questionnaire / survey directly from airtable

[Gerard_Blokdyk]

We have a list of questions in a base that we want to email out to gather answers, or ratings on a scale of 1-5. 

Is this possible to automate?

[David_Skinner · Accepted solution]

You can send emails using Automations. You'd probably want to use a Form view to for the questions which you would share in the email.

The questions need to be fields in a table, you can make them single select fields with 1 to 5 as the options. When people fill in the form their answers would come through as records in that table. 

[ScottWorld · Accepted solution]

There is also a “Rating” field in Airtable which can be used specifically for these purposes.

[Gerard_Blokdyk]

Thank you both, I tried to make the forms work, but it seems they'e only usable to enter a new record, not able to pull up questions from the database, display them, and ask people to rate their answers. Am I missing how to use forms? If it helps, here's the base with questions, recommendations and the Rating field https://airtable.com/appymGnhtm0h6XolS/shrPs3u7c6LG7qufj

[David_Skinner]

've made a very quick example to show you what I meant in my previous answer.

https://airtable.com/invite/l?inviteId=invRdgxZ6hqh4qqBI&inviteToken=8fa815e603c3ec392df2db5dfbedbe2...

[Gerard_Blokdyk]

Thank you, David. Could you please guide me on how to configure the form to retrieve questions from the database and present them to the user, prompting them for answers?

[ScottWorld]

I was thinking that you might be able to use Fillout to present the questions in the desired way and then send the questions to Airtable, but I'm not exactly sure how you would structure your Airtable base & your Fillout form to make that happen. 

I feel like the easiest & most straightforward way of setting up a form like this would be to simply setup the form in JotForm. Then, you would use Make's JotForm integrations and Make's Airtable integrations to parse the incoming data from the form submissions, and put all the data into Airtable in the appropriate places. This is likely the easiest & quickest way of solving this issue.