https://www.machform.com/forums/ MachForm Community Forums Topic: Multiple Choice & Checkbox Selection MySQL Data Entry en Mon, 04 May 2026 02:47:52 +0000 https://www.machform.com/forums/topic/expressing-selection-numbers#post-5628 Mon, 27 Apr 2009 10:24:04 +0000 yuniar 5628@https://www.machform.com/forums/ <p>Hi Chris,</p> <p>That is the intended behaviour indeed, only the index numbers are being stored into your form table, while the labels are being stored in another table.</p> <p>This is necessary to optimize your database. If you need to get the labels, you will need to do a reference to "ap_element_options" table.</p> <p>Using SQL, you can do a LEFT JOIN query for this.<br /> I suggest to contact SQL Maestro Group and ask them how to put the join query into the script.</p> <p>Check this thread for more info:<br /> <a href="http://www.appnitro.com/forums/topic/results-that-match-form-in-database" rel="nofollow">http://www.appnitro.com/forums/topic/results-that-match-form-in-database</a> </p> https://www.machform.com/forums/topic/expressing-selection-numbers#post-5596 Fri, 24 Apr 2009 23:22:27 +0000 getnbye 5596@https://www.machform.com/forums/ <p>First off... MachForm is awesome! </p> <p>I shopped around for a while looking for a Form application and MachForm was the only one I found that done everything I needed.</p> <p>I've created my form and several of the form questions require the user to answer as multiple choice answers. </p> <p>My problem is that when I built my PHP grid to expose the form data, I was surprised to see that the answers are expressed as numbers in the grid.</p> <p>When exposing the form information as data in a grid (MySQL) how do I expose the user responses as a reference to the form selection that makes sense to them?</p> <p>I'm using the PHP Script generator from the SQL Maestro Group (another great application)</p> <p>Here are examples of what I have thus far:</p> <p>My form ---&gt; <a href="http://www.65gs.com/form/view.php?id=2" rel="nofollow">http://www.65gs.com/form/view.php?id=2</a><br /> My grid ---&gt; <a href="http://www.65gs.com/3.php" rel="nofollow">http://www.65gs.com/3.php</a></p> <p>Note elements 7 20 21 &#38; 22 all based on checkbox or multiple selection form questions. </p> <p>I've figured out that what is probably happening is that the number in the DB is simply a reference to a form selection stored elsewhere. </p> <p>Is there anyway to have the form send the selection directly to MySQL to be exposed directly by the grid instead of sending a selection reference / number? </p> <p>Of course if the form user inputed the information directly instead of using a checkbox or dropdown it'd appear, however for convienence and data accuracy this is not really a good option.</p> <p>To have a checkmark show up in the grid for a checkbox marked in the form would be awesome as well as the multiple choice selection appear in the grid from any multiple choice form question.</p> <p>This is all probably pretty simple to most folks reading this however I new to web design and this has got me a bit confused on how to adjust.</p> <p>Thank you,</p> <p>Chris </p>