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.
How to show calculation values in the reports?Asked by erothhaus on May 05, 2015 at 05:06 PM
I've assigned my radio buttons values 1-4 or 4-1 (depending on the question, but when the data is collected in a spreadsheet, the text answers show up (not the values assigned to the text). How can I access the calculation values and work with the data?
Yes, that behavior is "per design". The reason why it is so is because the calculation values are only to be used in calculations and as such it would only be visible to the math part of conditions and to the form calculation, while to the reports it would not.
The only way around this is to create a hidden set of fields on your jotform that would update through conditions or you can use Form Calculation widgets to capture each field instead.
These fields should hold the label that you want to show in your reports and if done as mentioned above, they would show the calculation value.
Since form calculation will do the capture of this value for you by simply adding the field that you are after I do not think that you will have any trouble with this - but as this might be so depending on the fields, do let us know about it and we would be happy to assist.
In regards to the capturing of the value through the conditions, please take a look at the following guide: How to Insert Text or Mathematical Caculation into a field using a Condition
- I would recommend the Form Calculation approach.
@richardheslop, I have raised your feature request to our second level in a separate thread here: http://www.jotform.com/answers/694999