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 to set up condition between three fields...

    Asked by Pistol865 on April 25, 2017 at 05:36 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, if ONLY What group will be attending this meeting? I need to get the sum of ALL groups selected.

    If instead either, a selection is made in Area Breakouts OR Region Breakouts , then I need ONLY whatever that value is selected, to populate the How many people will be attending this meeting? field. 

    The values in these two sections- Area Breakouts OR Region Breakouts-
    TRUMP the values in What group will be attending this meeting?-- And those values should be shown in How many people will be attending this meeting?

     

     

    i.e.: in What group will be attending this meeting? DXS AE.  with a total number of attendees being 76.

     

    in Area Breakouts, the Area Business Meeting - Central, is ticked, with a values of 25.

     

    In the field How many people will be attending this meeting? I need it to recognize the lesser value of 25 (and NOT the 76 which is also ticked)

     

    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.

     

    Is this done with a  form calculation widget or can it simply be done by using "CONDITIONS"?

    The simpler the better!

     

     

    Any help is extremely appreciated.

     

     

     

    PM

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

    Screenshot
  • Profile Image

    Answered by Ian on April 25, 2017 at 08:36 PM

    Please do not submit multiple threads addressing same issue.

    Another thread addressing the same concern has been posted at https://www.jotform.com/answers/1128336

    Please follow that same thread for further discussion regarding the same.

  • Profile Image

    Answered by Pistol865 on April 25, 2017 at 10:08 PM

    No.. it's question/problem similar, however the details of the question is different on this one.

    Hopefully, you can still help me.

    I'm trying to find the simplest solution to the problem stated above. That's why the questions look so similar.

    I've been trying to solve this problem for days.. and every time I feel like i might come up with a different solution, I STILL get stuck on either "Conditions" or " Formulas".

    Please help.

    Thank you in advance.

    PM

  • Profile Image

    Answered by Pistol865 on April 25, 2017 at 10:43 PM
    Answered by Pistol865 on April 25, 2017 at 10:08 PM
    https://www.jotform.com/answers/1128547-How-to-set-up-condition-between-three-fields-/?entrymessage=10732640770
    No.. it's question/problem similar, however the details of the question is different on this one.
    Hopefully, you can still help me.
    I'm trying to find the simplest solution to the problem stated above. That's why the questions look so similar.
    I've been trying to solve this problem for days.. and every time I feel like I might come up with a different solution, I STILL get stuck on either "Conditions" or " Formulas".
    Please help.
    Thank you in advance.
    PM
    ...
  • Profile Image

    Answered by Ian on April 26, 2017 at 12:29 AM

    I am not sure if I understand your requirement correctly, but before I proceed I found that the the calculation field itself was not calculating correctly , because of the + operand missing

    The above fix now calculates correctly

    If you could elaborate In the field How many people will be attending this meeting? I need it to recognize the lesser value of 25 (and NOT the 76 which is also ticked),  I will investigate further

  • Profile Image

    Answered by Pistol865 on April 26, 2017 at 01:15 AM

    First off, thank you Ian for taking the time to try and fix my problem.
    let me see if I can elaborate further to make it clearer.

    So we have a field  with the question:  What group will be attending this meeting?

    And each group in that field, has a value associated with it.

    IF this is the only field that groups are clicked, I need the field with the question: How many people will be attending this meeting- To be populated with the sums of all of those groups that were clicked.

    Meanwhile, the fields marked:  Area Breakouts & Region Breakouts, are "Sub-Groups" of the original: What group will be attending this meeting-  So the values associated with the groups in those headings are less than the original group.

    If a group in either of these two fields are clicked, I need those numbers to populate the field: How many people will be attending this meeting, rather than the values associated with the FIRST filed which was: What group will be attending this meeting?

    The values in these two sections- Area Breakouts OR Region Breakouts-
    TRUMP
    the values in What group will be attending this meeting?--

    And those values should be shown in How many people will be attending this meeting.

     

    Again, with regards to the field: How many people will be attending this meeting?

     

     

    In this field, if selections are made ONLY in the field: What group will be attending this meeting? I need to get the sum of ALL groups selected to populate: How many people will be attending this meeting? .

    If instead either, a selection is made in Area Breakouts OR Region Breakouts , then I need ONLY whatever that value is selected there, to populate the How many people will be attending this meeting? field.

    I hope I've made it a bit clearer.

    I'm really stuck here.

    Can it simply be done by using "CONDITIONS" ?

    The simplest solution.

    Thank you again in advance!

     

    Regards,

     

    PM

  • Profile Image
    JotForm Support

    Answered by Chriistian on April 26, 2017 at 03:56 AM

    I can see that my colleague is currently working on your query in this thread: https://www.jotform.com/answers/1128336. Please follow up that thread to see my colleague's answer.

    Regards.

  • Profile Image

    Answered by Pistol865 on April 27, 2017 at 10:21 PM

    Has anyone come up with a response to MY response to Ian's inquiry above??

  • Profile Image

    Answered by Pistol865 on April 27, 2017 at 10:43 PM
    Answered by Pistol865 on April 26, 2017 at 01:15 AM
    First off, thank you Ian for taking the time to try and fix my problem.
    let me see if I can elaborate further to make it clearer.
    So we have a field with the question: What group will be attending this meeting?
    And each group in that field, has a value associated with it.
    IF this is the only field that groups are clicked, I need the field with the question: How many people will be attending this meeting- To be populated with the sums of all of those groups that were clicked.
    Meanwhile, the fields marked: Area Breakouts & Region Breakouts, are "Sub-Groups" of the original: What group will be attending this meeting- So the values associated with the groups in those headings are less than the original group.
    If a group in either of these two fields are clicked, I need those numbers to populate the field: How many people will be attending this meeting, rather than the values associated with the FIRST filed which was: What group will be attending this meeting?
    The values in these two sections- Area Breakouts OR Region Breakouts-
    TRUMP the values in What group will be attending this meeting?--
    And those values should be shown in How many people will be attending this meeting.
    Again, with regards to the field: How many people will be attending this meeting?
    In this field, if selections are made ONLY in the field: What group will be attending this meeting? I need to get the sum of ALL groups selected to populate: How many people will be attending this meeting? .
    If instead either, a selection is made in Area Breakouts OR Region Breakouts , then I need ONLY whatever that value is selected there, to populate the How many people will be attending this meeting? field.
    I hope I've made it a bit clearer.
    I'm really stuck here.
    Can it simply be done by using "CONDITIONS" ?
    The simplest solution.
    Thank you again in advance!
    Regards,
    PM
    ...