https://www.machform.com/forums/ MachForm Community Forums Topic: Can you change the field names in the table..... en Tue, 05 May 2026 07:51:54 +0000 https://www.machform.com/forums/topic/can-you-change-the-field-names-in-the-table#post-8630 Sat, 06 Feb 2010 05:07:04 +0000 startagl 8630@https://www.machform.com/forums/ <p>Using phpMyAdmin do a select query to inner join the two tables together and get the information as an output. Then import that information into your database. </p> https://www.machform.com/forums/topic/can-you-change-the-field-names-in-the-table#post-8623 Fri, 05 Feb 2010 21:06:12 +0000 deejay 8623@https://www.machform.com/forums/ <p>Yes, I imported it through phpMyAdmin but some of the fields imported are "funky". I am going to look into it more today. It was probably something that I did. Thanks for your help. I am very impressed with the product and the support you give here. :) </p> https://www.machform.com/forums/topic/can-you-change-the-field-names-in-the-table#post-8619 Fri, 05 Feb 2010 19:40:16 +0000 yuniar 8619@https://www.machform.com/forums/ <p>Hmm.. how did you import the csv file? Using PHPMyAdmin?</p> <p>If your form has dropdowns, you need the import into two tables. One is "ap_form_x" (x is your form id number) and second is "ap_element_options"</p> <p>"ap_element_options" is where you store your dropdown text/labels, while the number being stored in "ap_form_x" is the index number which refer to "ap_element_options" table.</p> <p>Both are relational tables.<br /> So the dropdown labels is being stored in "ap_element_optins", while the selected index is being stored in "ap_form_x" table.</p> <p>I hope I'm explaining this clearly. </p> https://www.machform.com/forums/topic/can-you-change-the-field-names-in-the-table#post-8614 Fri, 05 Feb 2010 09:40:32 +0000 deejay 8614@https://www.machform.com/forums/ <p>Thanks for your reply. I finally realized that. I would like to use the machform to insert the data through the form into my existing database because I want to do a custom search and display certain results in html. </p> <p>I figured out how to do the search and display the ap_form table data into html. The problem I ran into is when I import a csv file into the ap_form table to populate, it takes the text fields in my csv file and changes them to the numeric equivalent of the element option I used for the drop down box when creating the form. Any way to change this other than making all the fields to text? </p> <p>I hope this makes sense as I am a newbie to PHP and MySql. Thanks again for any help! </p> https://www.machform.com/forums/topic/can-you-change-the-field-names-in-the-table#post-8612 Fri, 05 Feb 2010 09:04:28 +0000 yuniar 8612@https://www.machform.com/forums/ <p>I'm afraid it won't be possible to modify the form field names and table. MachForm uses those names to be able processing your forms correctly. </p> https://www.machform.com/forums/topic/can-you-change-the-field-names-in-the-table#post-8607 Fri, 05 Feb 2010 02:30:12 +0000 deejay 8607@https://www.machform.com/forums/ <p>I did my first form and I have to say, this is great software! The table the installation generates puts the name "element_X" for the field name. I have two questions regarding the field name:</p> <p>1. Is there anyway to change this option so you can choose the field names when setting up?</p> <p>2. Can I change the field names to integate into my exisiting custom table?</p> <p>Thanks in advance for any help! </p>