We will show you how to add dynamic select menus, in your insert or update record forms using Bootstrap 3 Dynamic form generator. In this tutorial, we will show you how to do this with an insert record form, but it is the same, for the update record forms. The first thing we need to do is to create an action file which contains a query, that returns the values needed for the dynamic select menu. Add a new action file. We call it categories, as we will display product categories in the select menu (1). Right click steps. And add a database connection (2). Select your database connection from the menu or create a new one, if you haven't done this yet (3).
then, right click the database connection step. And add a database query (1). Add a name for this query (2). And setup the query options (3). Our categories are stored in a separate database table. So we select it from the dropdown, and add it to the selected columns list (4). And then, we add the columns we need, to our query. Click the Ok button, when you are done.
Save your action file (1). And now, you can create the insert record action file. Let's call it - add product (2). Right click steps. And add a database connection (3). Select your database connection, from the menu (4).
then, right click your database connection. And add a database insert (1). Setup your insert options (2). Select and add the table, you want to insert data into (3). then add the columns you need. And click the OK button, when you are done.
Do not forget, to save your action file (1). Now, we need to setup a server action executor, for the categories query (2). Add a new server action executor. And add a name for this executor (3). Select the categories action file, from the dropdown. And click ok (4).
Now we can generate our insert record form. Open the insert panel. And select - bootstrap 3 dynamic form generator (1). Select server action input source, as we are creating an insert record form. and then, select the insert record server action, from the dropdown (2). then, click the form field, which needs to be a select menu. And change its type to - select (3).
Click the dynamic data button, in order to select a repeater, for the dynamic select menu. Select the categories query, from the server action executor, which we've already created. And click OK.
Then, click the dynamic data button, in order to select the dynamic select menu titles. And select a dynamic binding, from your query. Click OK.
do the same for the select menu values. Select a dynamic binding, from your query, and click OK.
You can choose, whether to add an empty first value in the dynamic select menu, or not. Click the ok button, when you are done.
Now, just create your insert record server action executor and you are done. We've already shown you, how to create the insert record action executor, so we won't show this again. Let's preview the results. You can see, our select menu displays the values, returned from our database. That's how easy it is to create dynamic select menus, using bootstrap 3 dynamic form generator.