Creation of a conditional form that needs calculations?

  • ippolitoconsulting
    Asked on November 8, 2017 at 2:32 PM
  • aubreybourke
    Replied on November 8, 2017 at 3:54 PM

    Yes, we can try and help you there. Can you please describe your conditions and calculations? Also please supply your form URL:

    Where to Find My Form URL?  

  • ippolitoconsulting
    Replied on November 8, 2017 at 4:32 PM

    Thanks- essentially I want to create a form where people could input the number of people in their family and annual income and then based on those answers give them an answer of 100%, 75%, 50% or not covered. I have all the data that I could provide but don't know if it is possible or where to start, Does that make sense?

     

    https://form.jotform.com/73114371327147

  • aubreybourke
    Replied on November 8, 2017 at 5:06 PM

    Yes please provide detailed information of how to calculate the coverage.

    I have started creating the demo.

    We will need to use conditions to calculate the coverage.

    For example:

    1510179154Microsoft Edge 08 11 2017 22 1 Screenshot 10

    Here if the number of people in your family is one and your salary is greater than 20K you are entitled to 25% coverage.

    You can see this working here:

    https://form.jotform.com/73116192911957

     

  • ippolitoconsulting
    Replied on November 8, 2017 at 5:15 PM

     

    Thanks! Let me know if the chart below makes sense and is workable. Thank you again for your help!

    P          
               
    Potential Scholarship Amount
    (up to $12,280 cap) à    		 100% of applicable tuition and
    eligible fees    		 75% of applicable tuition and
    eligible fees    		 50% of applicable tuition and
    eligible fees    		 not covered at this point  
               
    1 if annual income is 0-$22,311 if annual income is 22,312-$30,150 if annual income is 30,151-$36,180 if annual income is 36,181  
    2 if annual income is 0-$22,311 0-$30,044 if annual income is 30,045 - $40,600 if annual income is 40,601-$48,720 if annual income is 48,721   
    3 if annual income is 0-$37,777 if annual income is 37,778-$51,050 if annual income is 51,051-$61,260 if annual income is 61,261  
    4 if annual income is 0-$45,510 if annual income is 45,511-$61,500 if annual income is 61,501-$73,800 if annual income is 73,801  
    5 if annual income is 0-$53,243 if annual income is 53,244-$71,950 if annual income is 71,951-$86,340 if annual income is 86,341  
    6 if annual income is0-$60,976 if annual income is 60,977-$82,400 if annual income is 82,401-$98,880 if annual income is 98,881  
    7 if annual income is 0-$68,709 if annual income is 68,710- $92,850 if annual income is 92,851-$111,420 if annual income is 111,421  
    8 if annual income is 0-$76,442 if annual income is 76,443-$103,300 if annual income is 103,301-$123,960 if annual income is 123,961  
  • Marvih
    Replied on November 8, 2017 at 7:14 PM

    Are the numbers below highlighted the number of people in the family?

    Creation of a conditional form that needs calculations? Image 10


    I have cloned your form and modified then added a sample condition. That if number of family is equal to one and Annual income is less than 22,311 (0-22,311), 100% coverage will show.

    Creation of a conditional form that needs calculations? Image 21

    The form is https://form.jotform.com/73117132424951. I am not sure if the maximum number of family is limited.

  • Marvih
    Replied on November 8, 2017 at 7:16 PM

    You can also do what my colleague @aubreybourke did.

    If you want to clone the forms we create you can follow this guide https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Let us know what you think.

  • ippolitoconsulting
    Replied on November 8, 2017 at 7:24 PM

    Yes the highlighted numbers are # in family and should only go up to 8 for these purposes. Thank you.

  • Kevin Support Team Lead
    Replied on November 8, 2017 at 8:48 PM

    You will be able to conditionally calculate the value based on the information entered on your fields, please check this guide that will help you doing so: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic 

    I hope this helps.