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.
Can I count the number of Male and Female registrants in a form?Asked by nystea on December 01, 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!
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.
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:
Here is my demo form: https://form.jotform.com/53351482785967
Hope this will help. Let us know if you need further assistance.