Questions & Answers

Q: I have successfully built a form using Form1Builder MySQL trial download and it inserts into database as required. I have then used the 'Existing Form functionality' but it does not seem to be able to allow ongoing 'edits' of the form. Is the process one-way, i.e. generation can only happen once and the designer view cannot be used to view existing fields and add more?

A: Existing Form allows you to use a previously set up form, either from a prior Form1 Builder session or a form that has been built by other means. When using Existing Form there must be no code (including form1 processing code) above the html start tag. If a file includes code above the html start tag open the file in a text editor and delete it before using the

Existing Form function. The Existing Form function is not designed for further editing although you can direct edit the code in the text area if required. It is recommended you set up your initial form layout either using a web editor or the Designer Form function or a combination of both. Keep in mind however that once you have added the processing code to the form it should only be edited using a text editor as html editors can corrupt the php coding.

Q: I am new to php and mySQL, which is why I am interested in your product. Will this tool allow me to create a form that will generate data for two tables at once? The first table would contain info on a person and the second would have multiple records linked to a record from the first table via a foreign key. Does your tool support that?

A: Each form submission will only update one database table but you can achieve what you require by linking two forms together. For example build the first form with the personal detail input and set it up to add this to the personal details table. In this form set the thank you url to point to the second form that has the additional detail required and set this up so that when it is submitted this data is added to the second table. The only issue would be the key, but you could pass it as a get variable between forms and add it as a hidden field for submission on the second form (this would require some additional php coding).

Question and Answer Item 237 - Browse All Question and Answer Items

Q: Everything seems to be working correctly except when I fill out the form, but leave out one of the required fields, Form1 correctly goes to your default page that says, "you didn't input all the info." There is a Return to previous page button, but when you press it, it does not return. It reenters my web address twice, then adds the form.php file at the end?

A: I gave it a test run and it works fine for me. One issue that may cause this is if you use query stings at the end of your urls ie something after a ? in the url.

Question and Answer Item 206 - Browse All Question and Answer Items

Q: How do I make the Project description box 5 or 6 lines high like in one of your demos?

A: This is a text area and the size can be set using the rows and cols attributes. You can see the source code for this in the Message field at https://bizpep.com/formsource.html . Also there are a couple of Form Code tutorial sites listed at https://bizpep.com/formcode.html that may be of interest.

Question and Answer Item 207 - Browse All Question and Answer Items

Q: How do I hide the hidden information that I want to pass to myself without the viewer seeing it.

A: You can unset the Display as HTML before Submission variable this will stop the form data being displayed to the submitter.

Question and Answer Item 208 - Browse All Question and Answer Items

Q: Is there a way to save my work? Not the php file, but the work I've done in creating the Form1 file in Internet explorer. I have had to start over a few times because I accidentally closed Internet Explorer thinking it was just a web page. Also, if I want to add categories to it later, do I have to start from the beginning? Isn't there a way to save it?

A: The processing code variables are saved when you click Save Variables (in the Required Section). For the form code you can simply copy the form code to a text editor ie Notepad and save it. If you save the Form Page Layout Code Only this is the code that determines the form layout and can be reused, see the Existing Form in the menu. You can also edit directly in the text editor if you want and then reuse it later.

Question and Answer Item 209 - Browse All Question and Answer Items

<< < Page 271 272 273 274 275 276 277 278 279 280 > >>