MachForm Community Forums » MachForm 2

1. deejay
   Member

   I want to insert a text value into my form_1 table for my drop down boxes instead of the value in the ap_element table. The reason is I don't have to do a lookup to see what the value of the digit entered equals.

   For Example if the drop down box options include "dog", I don't want a value "1" entered for dog, I want "dog" entered. Can I change the code in the form to do this?

   An example would be:

   <option value="Dog" >Dog</option> instead of <option value="1" >Dog</option>.

   Posted 14 years ago #

2. deejay
   Member

   One more question. Where does the forms_1 file go? I would like to make some modifications if I may.

   Posted 14 years ago #
3. 

   yuniar

   Unfortunately, it won't be possible to change the dropdowns values into text, as it would break the entire machform processing code. The reason for this is to optimize your database and avoid redundant data.

   I suggest to learn a simple SQL join query to get the data from both tables at once. It's quite handy once you get used to it.

   Some posts regarding this:
   http://www.appnitro.com/forums/topic/mysql-question?replies=5
   http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11

   Regarding form file, there is no separate file for each of your form.
   All your forms are being handled dynamically by a single file, which is view.php or embed.php

   ---

   MachForm Founder

   Posted 14 years ago #

RSS feed for this topic

Reply

You must log in to post.