Recode Value

Hi,

Is there an uncomplicated method to recode a response to a numerical value in the spreadsheet. For instance, if someone chooses Strongly Agree, it is represented in the spreadsheet with the number 5 instead of the words.

Thank you,

Hi Education_JAEI,

Thanks for reaching out to Jotform Support. Yes, there's a simple way to assign numerical values to response options like Strongly Agree and have those values appear in the spreadsheet. You can do this by adding a Form Calculation widget to your form. Here’s how to do it:

First, we need to add a Single Choice element and set it up. Here's how to do it:

1. In Form Builder, click on the Add Element on the left side of the page.
2. Add a Single Choice element to your form.
3. Click on the gear icon to open the Single Choice Properties window.
4. In the Single Choice Properties window, click on the Options tab.
5. In the Options tab, set the value of the Options textarea just like in the image.
6. Turn on the Calculation Values option.
7. Set the Condition Values just like in the image below.

Next, we need to add a Form Calculation widget. Here's how to do it:

1. In Form Builder, click on the Add Element on the left side of the page.
2. Click on the Widgets tab.
3. Click on the Form Calculation widget.
4. Click on the wand icon.
5. Click on the Add Field button.
6. Select the Type a Question option.
7. Click on the Save button.

Here's the sample output:

Give it a try and let us know if you have any other questions.