I have been playing with MachForm for a while now, and I am very pleased. I am missing one thing that I (personally) would expect. Maybe I overlooked it, but I have been going through the software for quite a while now.
I would like an option to create a form (Form-A), in which I enter data, and then create a new form (Form-B) in which I can use the data from Form-A. I'll give an example;
1.- Form-A is used to input names of colors. Just one field. The colors go into the database.
2.- Form-B has two fields. The first field can be used to type in a car brand (Toyota for example). The second field is a drop down list, and retrieves the values entered in Form-A.
Even better would be the option to add a button on a form so the user (end-user) can be linked to a form to add values to a drop down list, in case the required value isn't provided. I'll give another example, based on my previous example;
1.- Form-B has two fields. The first field can be used to type in a car brand and the second field is a drop down list, and retrieves the values entered in Form-A. Behind the field that lets the user select the color of the car, there is a button that links to Form-A (preferably in an Ajax "pop-up"), and lets the user add an additional color in case the required color isn't provided.
2.- Form-A shows the field where the color can be entered, and it (Ajax) dynamically inserts into the drop down box of Form-B, so that the page won't have to be reloaded, preventing loss of entered data.
I can think of numerous of purposed and scenarios that would welcome this functionality. Right now the only way I can achieve this is by writing my own PHP scripts, and it involves copying data from one table (form) to another table (form). Having duplicates of data within a database isn't exactly efficient and it means data will have to be copied back and forth every time it is updated. It also means I would end up modifying existing scripts, which is undesirable since every update of the software would overwrite my adjustments.
