https://www.machform.com/forums/ MachForm Community Forums Topic: Drop down must show labels but enter different data in the database en Sun, 14 Jun 2026 04:57:38 +0000 https://www.machform.com/forums/topic/drop-down-must-show-labels-but-enter-different-data-in-the-database#post-15761 Tue, 28 Aug 2012 19:01:51 +0000 yuniar 15761@https://www.machform.com/forums/ <p>Ok, you can keep the "Restrict to US State Selection" enabled. Then modify your "includes/view-functions.php" file around line 3305:</p> <pre><code>//if this address field is restricted to US only if(empty($element-&gt;is_design_mode) &#38;&#38; !empty($element-&gt;address_us_only)){ $country_markup = &#39;&lt;option selected=&quot;selected&quot; value=&quot;United States&quot;&gt;United States&lt;/option&gt;&#39;; }</code></pre> <p>you can remove that block of code. This would display the complete country list and yet still display the US states as well. </p> https://www.machform.com/forums/topic/drop-down-must-show-labels-but-enter-different-data-in-the-database#post-15740 Tue, 28 Aug 2012 05:32:38 +0000 JerryH 15740@https://www.machform.com/forums/ <p>OK, that helps but I am still not there 100%.</p> <p>I sucessfully switched my form to use the Address field and customized the State labels and values the way I need them BUT....<br /> I NEED the State drop down AND I NEED the Country drop down.</p> <p>Right now, I have to select "Restrict to US" to get the State drop down which eliminates all countries but US.</p> <p>Is there a way around this?<br /> Thanks. </p> https://www.machform.com/forums/topic/drop-down-must-show-labels-but-enter-different-data-in-the-database#post-15720 Sun, 26 Aug 2012 18:58:13 +0000 yuniar 15720@https://www.machform.com/forums/ <p>Using the general dropdown field, I'm afraid it won't be possible to do so.<br /> However, if you are using the Address field (which contain the State field), it is possible to modify the State dropdown to do what you need.</p> <p>You can modify "includes/view-functions.php" file. Search around line 3151 and you'll find these lines:</p> <pre><code>$state_list[0][&#39;value&#39;] = &#39;Alabama&#39;; $state_list[1][&#39;value&#39;] = &#39;Alaska&#39;; $state_list[2][&#39;value&#39;] = &#39;Arizona&#39;; $state_list[3][&#39;value&#39;] = &#39;Arkansas&#39;; $state_list[4][&#39;value&#39;] = &#39;California&#39;;</code></pre> <p>Simply modify the above with the state codes. </p> https://www.machform.com/forums/topic/drop-down-must-show-labels-but-enter-different-data-in-the-database#post-15701 Sat, 25 Aug 2012 00:23:02 +0000 JerryH 15701@https://www.machform.com/forums/ <p>I need to find a way to have the list in a drop down show labels (Arizona, California, etc.) but enter different data in the database (AZ, CA, etc.).</p> <p>The users need an easy to pick description but the database requires a 2 digit code.</p> <p>Can this be done? </p>