Tutorial: Editable Grid using a multi-selectable combobox

In this example will be developed a form of the “Editable Grid” using the multi-selectable combobox feature.


Creating Form

1. Create a new application type Form “Editable Grid” based on the tasks table.

2. Access field settings “taskpredecessor” in the application menu, and set the field for the type “Select”


3. Also in the settings of the field, go to “Edit Lookup” tab, where we use the following SQL

SELECT taskid, taskname 
FROM tasks
WHERE taskid <> {taskid} AND projectid = {projectid}
ORDER BY taskname

4. Select the options for “multiple values” and “Use Checkbox in drop down”


5. Click the Run button on the toolbar.


Tutorials in the same category

Form with special fields

In this example, we'll see how to configure a couple of Scriptcase special fields, in a form applica...

Master-Detail (Single-to-Single)

In this example, a Master / Detail complete application, where we get an edit form of categories and...

Generate PDF from Forms

In this example we will see how to configure the application form to display the button to print the...

Form Mobile

Scriptcase Form applications are generated with mobile responsiveness automatically. Selectin...

Comment this post