Can I count the number of Male and Female registrants in a form?

  • nystea
    Asked on December 1, 2015 at 10:21 PM

    In a conference registration form I have allowed for up to 36 people per school to attend. Some are students and some are adults. For the students, I need the gender of each student to determine rooming requirements. I have a field called Gender that must be set to M or F as a conditional requirement if the member type is Student. I don't care about the adult gender. Figuring 3, 4 and 5 person room assignments with the correct gender for students is the challenge.

    As a crosscheck (and to reduce the amount of email we have to send to fix errors), I want to count the number of Male and Female students attending and compare it to a teacher entered Total M and Total F value to make sure the data entry is correct. If 7 M and 6 F are listed but the teacher says 8M and 5F, I need an error flag of some sort to make them check their data.

    The error can either be a triggered email, or ideally, turn off the Submit button and provide a screen message to check/correct their numbers before they can submit. 

    In a perfect world, I would also like Total Students to be compared to Total M + Total F with a error flag if they get it wrong.

    I found some forum postings that said text boxes can be counted, but not whether the content could be compared and counted. 

    Is this possible?

    Thanks for your help!

  • BJoanna
    Replied on December 2, 2015 at 4:30 AM

    Thank you for contacting us.

     

    I have inspected your form and I saw that you are using dropdown field for selecting genders. You can use form calculation to calculate number of Male and Female registrants in a form. First you would need to add additional text box fields and use conditional logic to pass values to that fields based on selection of your gender dropdown field. 

    Can I count the number of Male and Female registrants in a form? Image 1 Screenshot 20

    Than you would need to perform calculation inside of your form to count the number of male and female students. Inside of this guide you can find how to perform calculation in the form:

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form 

    Here is my demo form: https://form.jotform.com/53351482785967 

    Hope this will help. Let us know if you need further assistance.