Search and grid on same page

This tutorial shows how to create a grid with the search function on the same page.

Creating a new grid

1. Create a new grid application using the product table.

2. Choose the Field positioning option in the application menu and choose ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice and UnitsInStock.

Change the settings to display the grid and search on the same page

3. Return to the initial “Grid Module” options

4. In INITIAL MODULE select Search.

5. In APPLICATION MODULES Set Yes to Use Iframe.

Search field settings

6. Open the search folder and click “Advanced search >> Select fields“.

7. Choose the SupplierID and CategoryID fields.

8. Click in the SupplierID field.

9. Set the Data Type property to Select.

10. Open the Search Lookup block.

11. Define the settings according to the image below.

12. Enable the OnChange option in the Field Behavior block. With this option enabled, the search is automatically executed when an option is changed.

13. Open the CategoryID field settings, change the Data Type property to Select and make the following changes.

14. Open the Field Behavior block and configure it according to the image below.

15. Click the Run button on the toolbar.

Tutorials in the same category

Tutorial: Saving Report Views

In this example, we will see the options available for the end user to store, in session or in a...

Tutorial: Grid with modal filter.

This tutorial will show how to configure a query filter to display in a modal window, using the res...

Export Option

To export different types of files we must carry out the following steps: 1 - Create a Grid ...

Integration with WhatsApp

To integrate WhatsApp with ScriptCase, we will be using a specific API called Chat-API, it is a...

Comment this post