Auto Generating an Insert Record Form

We will show you, how to auto generate an insert record form using Bootstrap 3 Dynamic Forms Generator. We created an empty page, and added a bootstrap 3 container in it. Instead of creating the insert record form, manually and adding the fields in it, one by one we will use the dynamic form generator. First, let's create a server action. Add a name for your server action (1). Then, right click steps. And add a database connection (2). Add a name for your database connection (3). And then, setup its options. Enter your connection details address database username and password. Click the OK button, when you are done (4).

Right click your database connection step. And under database actions. Select database insert (1). Add a name for the insert step (2). And then setup its options (3). Select the database table, where you'd like to insert data into. And add it to the selected tables list (4). Then, select the columns, you'd like to insert data into, and add them to the selected columns list. We want to insert data into all of the columns, of this table. The bootstrap 3 dynamic forms generator will generate a form input, for each of the columns, selected here. click the ok button, when you are done.

Save your action file (1). Now, let's generate the insert form. Click bootstrap 3 dynamic form generator (2). Select server action input, as a fields source (3). then, select your insert record server action, from the dropdown (4). And select your form type. We select vertical form layout (5). Here, you can see all of the form fields, that will be generated based on your selected columns in the insert record step. You can select any of them. And then you can edit the selected field's name and label (6). Also, you can change the field type. Bootstrap 3 Dynamic Form generator, is smart enough and sets the form field type depending on your database field type so most of the times you won't need to change this. You can add, delete and move fields, inside the form. A submit button is automatically being added, to the form so you don't need to add one later. Click the OK button, when you are done.

And here is our form, generated in just a few clicks! Now, the only thing left is to setup the server action executor and you are done. You already know how to setup the server action executor, for the insert record so we won't show this now. Stay tuned for our next tutorials, where you will learn, how to auto generate an update record form dynamic select menus and dynamic checkboxes and radio button groups.