JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How can I count the number of attendees in a list of entriesAsked by nystea on October 15, 2016 at 06:21 PM
I tried to search for this but "count" and "entries" kept bringing me to submission limits on forms.
What I'd like to do is separetly count the number of Male and Female students, as well as the total number of attendees (this includes adults).
I have a manual entry for M and F students and Total attending but don't trust the public with math.
I'd also like to count the non-students. This could be Total -(M+F) or a count of anyone that isn't classified as Student.
I know it should be simple, but I'm not making it work.
You can achieve this on your form https://www.jotform.com/62558759684981 by using the Assign Calculation value option on the fields.
For the type field which you will use to count which type are 'Students' you can do like this..
---- - 0
Sponsor - 0
Student - 1
Presenter - 0
Guest - 0
For Gender field to determine count of F or M, simply assign 1 for F and 0 for M
then use the form calculation widget for all calculations.
Since in Gender only F=1 you can also get total by adding all the fields (same to formula of Type)
Formula for M = Type - F <--- to get total count of M students
I'll create a demo form and get back shortly so you can try.
Please test this form https://www.jotform.com/62889281887983
it work like this
I have modified the previous calculation value for the Type I mentioned. The correct now is like this
---- - 0
Sponsor - 1
Student - 1
Presenter - 1
Guest - 1
I also now have assigned calculation value to "Years Attending" since that is the only means I can distinguished 'Students' from the 'Type'
To better review the test form https://www.jotform.com/62889281887983 you can clone it .
Let us know if you need further assistance.