Display field values in results

[ImagineWebsites]

Hello

I'm using dropdown lists on a form with a number of options, these options are each given a value:

<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>

The problem is, when the form is submitted the display text is shown (e.g. 'Very good'. when I what I need to see is the option value '4'. Is there something I can do to change this?

Thanks

[mrGarvin]

Maybe something to do with your option list? Or perhaps how you set up your fields and their values.

Read more about the use of option lists here: http://docs.formtools.org/userdoc2_1/?pa...ion_groups

About the fields here: http://docs.formtools.org/userdoc2_1/?pa...fields_tab

[ImagineWebsites]

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?