Nov 14th, 2012, 6:55 AM
Thanks for the suggestion, I have read through the documentation but I can't find anything to explain this.
When I look at the option list for my form field in Form Tools, it shows field values in the left column (5,4,3,2,1) and the right column it shows the display text (Excellent,Very good,good,average,poor) which mirrors the options in my form:
<select name="quality" id="quality">
<option value="5">Excellent</option>
<option value="4">Very good</option>
<option value="3">Good</option>
<option value="2">Average</option>
<option value="1">Poor</option>
</select>
When I view data submitted by a user, the spreadsheet shows me the display text when I need to see the field value (option value). Is there a way to make Form Tools display the option value instead of the display text?
When I look at the option list for my form field in Form Tools, it shows field values in the left column (5,4,3,2,1) and the right column it shows the display text (Excellent,Very good,good,average,poor) which mirrors the options in my form:
<select name="quality" id="quality">
<option value="5">Excellent</option>
<option value="4">Very good</option>
<option value="3">Good</option>
<option value="2">Average</option>
<option value="1">Poor</option>
</select>
When I view data submitted by a user, the spreadsheet shows me the display text when I need to see the field value (option value). Is there a way to make Form Tools display the option value instead of the display text?