JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Performing complex calculations and outputting resultAsked by AlecTaylor on August 28, 2015 at 11:52 AM
Hi - I would like to create a form to gather user data, then have a complex set of calculations performed to create a suitable output to the user on the form.
The calculation would not be of the simple type that could be accommodated with something like the calculator widget. It would require a large spreadsheet to be run, with perhaps VBA macro code behind the spreadsheet.
Can this be done?
Alternatively, is it possible for me to directly code a widget\app to perform complex calculations?
Thanks in advance, Alec.
Our form calculation is limited to basic calculations, it is not possible to integrate with jotform directly.
You can however download the form's full source code which will give you all the flexibility you need to write you own custom implementation.
Please refer to this guide on how to get your form's full source code, do let us know if you need further information