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
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 in Airtable.
However, if you’re trying to display the formula/calculation results on the form itself, you can’t do that with Airtable’s forms.
If you need to display totals or results on your form itself, then you would need to use Fillout’s advanced forms for Airtable.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to perform math or other live calculations on your forms, update Airtable records using a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, , accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
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 
so helpful thank you.
Hi there!
At miniExtensions, we've created a third-party form that integrates seamlessly with Airtable, enabling advanced features, such as dynamic formula field calculations. Simply enable the Save & Continue mode, which allows calculations (formulas, rollups, etc.) to run either every few seconds or on demand with a button:
Feel free to explore these features and many more with a free account on our site.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.