Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Creating a form that creates an output

159 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Miranda_Glavin
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

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

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.

CristianCG
8 - Airtable Astronomer
8 - Airtable Astronomer

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:

CristianCG_0-1737651759235.png

 

Feel free to explore these features and many more with a free account on our site.