-
ippolitoconsultingAsked on November 8, 2017 at 2:32 PM
-
aubreybourkeReplied 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:
-
ippolitoconsultingReplied 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
-
aubreybourkeReplied 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:
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
-
ippolitoconsultingReplied 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 fees75% of applicable tuition and
eligible fees50% of applicable tuition and
eligible feesnot 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 -
MarvihReplied on November 8, 2017 at 7:14 PM
Are the numbers below highlighted the number of people in the family?
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.The form is https://form.jotform.com/73117132424951. I am not sure if the maximum number of family is limited.
-
MarvihReplied 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. -
ippolitoconsultingReplied 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 LeadReplied 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.