Creating a form that creates an output

1112 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi everyone!
Newbie here still getting my head around Airtable. I am creating a form with 14 questions. The answer to each questions is a scale from 1-5, 1 being none of the time 5 being all of the time. When the form is complete I would like to be able to total the 14 answers for each respondent (so if someone answered 1 for each answer their total would be 14). How do I do this?!

Many thanks

2 Replies 2

Welcome to the community, @Miranda_Glavin!

If you are using rating fields to collect the data, the data is already stored as numbers. So you can just create a formula field in Airtable that simply adds up all of the fields.

I can’t tell if you’re trying to provide the total to your form users, or just keep the totals in Airtable for yourself.

If you need to get the total to your form users, you can’t provide the total on the form itself. But after you create the formula field with the total, you can setup an automation to email them the total after the form is submitted.

If you need to display totals or formula results on your form itself, then you would need to use JotForm (which provides calculations), and possibly add in On2Air: Forms as well (which can pull in live data from your Airtable base).

Amazing thank you :slightly_smiling_face: so helpful thank you.