how to count gender across more than one type of attendee (student vs teacher, etc)

  • Profile Image
    Asked on October 26, 2016 at 03:16 PM


    I thought I could get away with having a total count of attendees and just a gender count for students, but the powers-that-be want more detail.

    After messing with this for a while, I thought of only requesting gender for students with a hidden field. I need to know the gender of all attendees even if I don't count the non-students breakout. This poses a problem.

    I have a way to count total attendees. I can count total students, too. 

    My goal is  
    Count of Male Students,
    Count of Female Students,
    Total Students,
    Total Attendees,
    Individually record the gender of all attendees to aid in housing decisions.

    If I count gender for all, the student count is broken by non-students attending.

    This is the only way I see to make it work - and I'm hoping there is an option with less fields.

    Last-Name is Filled = +1 in Attendee(n).
    Total-Attendees = Sum of Attendee(n)

    Type (Student, sponsor, etc) triggers a hidden Student-Gender(n) field OR a hidden Non-Student-Gender(n) field. Only Student-Gender fields are counted. Non-Student-Gender allows us to plan but is not used in a calc field.

    Type = Student has a +1 value for Student-Count(n) and displays hidden Student_Gender(n).
    Student-Gender(n) = F has a +1 value for Female-Student(n).

    Total-Students = sum of Student-Count(n)
    Female-Student-Count = sum of Female-Student(n).
    Male-Student-Count = Total-Students - Female-Student-Count 

    Type = Any other choice will display hidden Non-Student Gender field, which doesn't get counted but is tied to that attendee in the database.

    Without two separate Gender fields, I can't figure out the logic. If I needed breakout beyond student/non-student for the other Type choices, it would be multiple Gender fields per attendee with the same decision tree.

    In FileMaker, I could use nested if statements or their CASE function. So far, I can't find anything like that in JotForm.

    Thanks for any insight into alternatives or just confirming that I'm on the right path.



  • Profile Image
    Answered on October 26, 2016 at 07:55 PM

    There is a way to have nested "If" statements with your condition and since you would only like to count the total number of male and the total number of female students attending the conference, I suggest you make use of it.

    When you create your condition, there is a "Plus" button on the right of the first "If" rule statement. Clicking it would let you add another "If" rule.

    If you have more than one "If" rules, you also have to take note if you would like to have the action executed if all of the rules are matched or only if any of the rules are matched.

    I hope this helps.

    Below is a sample form that I've created that is based on the requirements you mention in your post.

    You may clone the form to your account so you can have it inspected.

    If you have any other questions or you need any further assistance creating your form, please do not hesitate to let us know.

    Thank you.