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.
Can the new calculation widget do table lookups?Asked by bleonard8 on March 19, 2014 at 11:17 AM
Will the form calculator be able to do table lookups? I would like to have the widget supply a number based on looking up ranges of numbers and then doing a calculation. For example, if the number is between 5500 and 7500, then the result would be 660 (the result from the table for that range) plus 15% of the amount greater than 5500. This would allow tax calculations, although the formula would be much more complex than this example.
Also, would you be able to then take that number and do a new calculation based on the result from another table?
We've updated our calculation widget and include advance math functions. You can find the references here: Form Calculation - Math Function Reference.
One question, how would you intend to implement the table? Is it using the Text Box field? Do you have some sort of example on how this work to the form? OR maybe, tell us the whole flow?
I am a family law attorney and I intend to use this to allow child support calculations.
The client would enter his or her gross income and other information and the program would deduct the appropriate taxes and other deductions and then from that result, calculate the amount of net available income that would be applied in the case.
The program would then use that number and calculate the actual support based on a table depending on the number of children involved in that case and the number of children not involved in thiat case. Each circumstance has a different percentage of support.
An alternate way to do it would be using a large number of "if...then..." statements. If the case involves 3 children and the obligor has one other child that he is responsible for then the support will be X percent of net available income.
As you stated on your last post, I also believe this would be possible using conditional rules so that the the calculation is made depending on the initial value that was input by the user. To be straight forward I lack the knowledge of how child support is calculated, but I would think that the best process would be to allow the user to input their main variables at first, to avoid conditional rules further down the calculation.
As my colleague stated above, it would be helpful to have an example of what is needed to work this on a form. So that we may assist you better.