Tutorial: Editable Grid form using multi-selectable combobox

In some cases, we need to select more than one option in the field, we can deal with this situation by grouping all of these options in a single selection and showing all the checkboxes in a single menu of options on the screen.

In this example, an “Editable Grid” Form will be developed using the Multi-Selectable Combobox feature .

Creating a Form with Multi-Selectable Combobox

note:If you have any questions on how to create a Form, go to:  Creating a new Form

1. Create a new application of the form “Editable Grid” based on the “tasks” table .

Form creation.

2. After creating the Form, in the application menu access the “Field Positioning” tab .

Fields Position Tab.

3. Select the fields: projectid, taskname, startdate, finishdate, percentcomplete and taskpredecessor.

Selecting the Fields.

4. Once this is done, select the “Fields” tab in the application menu and access the settings of the “projectid” field .

Projectid field.

5. Navigate to “Edit Lookup” and replace the SQL code present in the text box with the code below:

SELECT projectid, projectid 
FROM tasks 
ORDER BY projectid

The Edit Lookup will look like this:

6. Still in the “Fields” tab , access the “taskpredecessor” field settings .

Taskpredecessor field.

7. Once this is done, when accessing the general field settings, change the data type to Select , as shown in the image below:

Selecting the data type.

8. Next, navigate to “Edit Lookup” and apply the code below:

select taskid, taskname 
from tasks
where taskid <> {taskid} and projectid = {projectid}
order by taskname

9. Now, activate the options “Multiple Values” and “Use Checkbox in Dropdown” as shown in the image below:

Additional configurations.

10. Having made the changes above, the “taskpredecessor” field will return the multiple values in Dropdown format , as well as the image below:

11. Finally, click on the “Run” button on the toolbar.

Running the application.


To see more examples created using Scriptcase, go to:  Examples: Complete Systems and Applications with Scriptcase.

Tutorials in the same category

Responsive login form 3

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form 2

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form

To learn how to use the templates available within the ScriptCase in the security module, follo...

Summary With Fixed Label

A report in summary format with labels anchored to the top of the screen. Creating the Grid ...

Comment this post