What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    How can I count the number of attendees in a list of entries

    Asked 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. 

    Thanks

    jim

    Page URL:
    https://www.jotform.com//?formID=62558759684981

    running number
  • Profile Image
    JotForm Support

    Answered by jonathan on October 16, 2016 at 01:15 AM

    You can achieve this on your form https://www.jotform.com/62558759684981 by using the Assign Calculation value option on the fields.

    User guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    I.E. 

    For the type field which you will use to count which type are 'Students' you can do like this..

    ----    - 0

    Sponsor - 0

    Chaperone -0

    Student - 1

    Presenter - 0

    Committee -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.

    Total students:

     

    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.

    Thanks.

     

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on October 16, 2016 at 02:16 AM

    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

    Chaperone -1

    Student - 1

    Presenter - 1

    Committee -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 .

    User guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Let us know if you need further assistance.