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

    Can't seem to figure out a formula.

    Asked by Pistol865 on April 25, 2017 at 02:21 PM

    Here's my problem:

    I have three fields:

    1) What group will be attending this meeting?

    2) Area Breakouts

    3) Region Breakouts

    Within them, I have values assigned to specific groups.

    Below them is a field:

    How many people will be attending this meeting?

    In this field I need to populate it with the all the lesser values being added together and getting a final total.

    i.e.: in What group will be attending this meeting? DXS AE and DXS FAS is clicked. Each with a total number of attendees being 76 and 65 respectively.

    in Area Breakouts, the Area Business Meeting - Central and Area Business Meeting - West, is ticked, with values of 25 and 30 respectively.

    In the field How many people will be attending this meeting? I need it to recognize the lesser values of 25 and 30 ( and NOT the 76 and 65 which were also ticked) and add them up to get a total of 55.

    If the groups weren't broken up into "Area" or "Region", I need the field How many people will be attending this meeting? to be populated by the total of just the What group will be attending this meeting? field.

    I have a form calculation widget associated with the How many people will be attending this meeting? field. But I can't figure out what calculation formula I need to put in there.

    Any help is extremely appreciated.

     

    PM

     

     

    Page URL:
    https://form.jotform.com/71108358384156

    Screenshot
  • Profile Image
    JotForm Support

    Answered by jonathan on April 25, 2017 at 04:11 PM

    Allow me some more time to figure out the correct formula needed for your form requirement.

    I will get back to you as soon as I have update on this.

    Thank you.

  • Profile Image

    Answered by Pistol865 on April 25, 2017 at 04:55 PM

    Thank you!!