- bleonard8Asked on March 19, 2014 at 12:19 PM
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.
This is a re-post of a comment on Introducing Field Calculations for Forms
- JotForm SupportMike_TAnswered on March 19, 2014 at 03:47 PM
I am sorry to inform you, but it is not likely that we will be able to add such option since it might be really hard to implement. However, if we get many requests about table lookups or some similar conditional actions, our Dev Team will be able to consider it.
Thank you for using our service.