calculating a total from a number field | Community
Skip to main content
Question

calculating a total from a number field


Hi

Having a number field asking how many people are attending, how can I add the total of all attendees?

How many people are coming with you?  5

How many people are coming with you? 3

Total; 8

Can I store that total and check regularly to know current total of attendance?

I have created this logic step but the result for both entries is Score: 5 and score: 3.  How can I add the values and where are they stored?

Thanks so much.

john.desborough
Forum|alt.badge.img+6

@JSands - use the Connect feature to connect the form to a Google Sheet and all the responses will be recorded there as well. you can then see the running total of all the attendees.. 

just a suggestion

 

des


  • Explorer
  • March 20, 2025

Thanks John,  

 I guess that I misunderstood the use of score or variables, they perform calculations within each response, right?  like if a ticket is 20 and there are 2 people coming, the value is 20 x 2.  Not that keeps adding the values of all the responses, like 2 + 1 +3 people coming?

I’ll have a look at Connections with Google or Excel.

 

Thanks!

 


Reply