Filter on Form Aplication

Filter on Form Aplication

This application filters data that will be displayed on editing forms. This type of application necessarily works linked to a form.

 The table used to create this application must be the same as the one used to create the form.

In this article we will show you how to configure a filter application.

 

After creating the filter application, using the same table as the form, follow the steps below:

 

 

1. First, we must select the fields that will be present in the filter.

    In the application settings, in the side menu access Filter> Field positioning.

 


 

2. Next, we must create an application-type connection, with the form that will have the filter.

    To create this link, in the application settings in the side menu go to Links> New Link



 

3. Next, a list of available applications for creating the filter will be displayed.

 


 

4. Now, a screen will be displayed with the fields of the filter to make the association with the fields of the form.



 

5. Finally, a screen for the connection settings will be displayed.

    With some settings like Link operation mode, which sets the way the filter will be displayed.



    • Related Articles

    • Filter Connection

      Some databases use schemes to organize internally their data, just like Oracle, PostgreSQL, and SQL Server. Such feature is great when known and used correctly. The problem is when the database has a lot of schemes, that results in delay at the time ...
    • Using two search applications to access a form

      In this example we are going to create 2 applications of the "Search" type, and 1 application of the "Form" type. In the Search type applications, we will use the "customers" and "orders" tables, however, we will select only a few fields from each ...
    • How to change the application's state in run time

      To change the properties of application execution, changing their form of execution than initially planned, Scriptcase has a macro called sc_apl_conf. The macro should be used as follows: sc_apl_conf ( Application , property , value ) ; So, we can ...
    • How to create a capture link

      Capture Link: Used for the grid filter form, it imports data from another grid into the filter form field. Selecting the capture link type will display a list of fields in the filter form so that you select the field that will receive the data ...
    • How to create an application link

      Application Link: This is used to link the application with any other type of project application. This type of link is associated with insert and update events. How to do an application link: Open your application and go to the “Application Links” ...