Advanced sqlDashboards Query Forms
Multiple Input Components
Clicking on add components multiple times, will add a new component to the bottom of the form each time.
Within the list of components in the form editor, we can select the one we wish to edit. While selected we can use the up/down arrows to rearrange the input component order of the form and the delete button to remove that component.
You will have noticed when we select an input component, there is sometimes a query box where we can enter an SQL query. The first column of this query will be added as options to the list of values that a user can select. Here's an example of dynamically selecting the countries available from the database.