Hello,
I have a form with a Text - Multiple Choice input element which has a list of states I wish my users to select from:
- Arizona
- California
- Texas
The value from this Multiple Choice input writes a value to a field named STATE in the table:
[STATE]
Arizona
Arizona
Texas
California
Texas
Arizona
Arizona
Texas
California
Texas
What I want the form to do is write the abbreviated name of each state into the STATE field:
[STATE]
AZ
AZ
TX
CA
TX
I know with HTML forms, you can use values in your tag for each option (see below); how do I achieve the same in Quickbase?
<form action="/action_page.php">
<label for="state">Choose a State:</label>
<select id="state" name="state">
<option value="AZ">Arizona</option>
<option value="CA">California</option>
<option value="TX">Texas</option>
</select>
<input type="submit">
</form>
Thanks