- MDeaglenestsAsked on February 21, 2017 at 11:02 AM
I need to create a check box in my survey that is automatically set to FALSE if unchecked and TRUE if checked. I have learned that you should be able to do this using calculation values, but I have been unable to get this to work. When I set calculation values, even if numerical, my submissions come out as the text of the option, and not the calculation values.
My objective is to have an excel export that has the value TRUE if the box is checked, FALSE if unchecked. I am ok with having two options if needed, but ideally only one checkbox would be needed to obtain both values.Page URL:
- JotForm SupportdavidAnswered on February 21, 2017 at 12:21 PM
Calculation values will not be shown in form submission data, only the option text will be. Calculation values are used to give numerical values to non-numerical options. Those values can be used in a calculation field:
You could set up a condition to update a text box with your text based on the input of your checkbox field:
But if you need True or False to be produced from the checkbox field alone, you would need both options.