Go to Scriptcase store

# Creating a Grid/Report Application
View video

## New Application

The process of creating an application is quite simple and intuitive.

You only need to select the type of application you want to generate from the list of applications available in Scriptcase, and it will be generated automatically.

## Application Data

#### Connection

Defines the connection used for the creation of the application. The existing connections in the project will be listed.

#### Name

The name of the application being created. It cannot contain special characters.

#### Table

Defines the tables to be used in the application. (Form and Calendar can only use one table).

#### Fields

Defines the fields that will be part of the applications.

#### Localization

The language of the application to be created. The project’s default language is automatically selected.

#### SQL

Displays the SELECT command generated after selecting the tables and fields. This field also allows the insertion of a previously created SQL statement, as long as it uses tables that exist in the database selected in the connection.

#### Create also a Form to edit the Grid

This option creates a form application linked to the grid, automatically establishing an edit link between the applications. For more details about the edit link, click here.

> This option is available only when the grid is created using a table.

When this option is selected, a dialog box will appear asking the developer to define the default behavior for creating future grid applications.

- Create also a Form to edit the Grid - Defines the default behavior for creating future grid applications.
- Always display this message - Determines whether this dialog box will always be displayed.

> This configuration can be modified later by accessing the menu Options > My Scriptcase.

After confirming the default behavior, you will need to specify the name of the form to be created.

#### Run application after creation

This option defines whether the grid will be executed after it is created.

When this option is selected, a dialog box will appear where the default behavior of Scriptcase for creating other grids in the project must be defined.

You can configure the grid to run by default by selecting the option Run the application after creation and clicking save.

If you deselect the option Always show this message, this dialog box will no longer appear.

> This configuration can be changed later by accessing the menu Options > My Scriptcase.

## Relationship

When select two or more tables, the tab “Relationship” will be displayed. In this tab we can see the relationship created between the tables, where we can edit the related fields.

When we click in a link, in the screen above, it will displayed the related field’s edition form, as you can see in the image below.

## Editing Fields

This screen displays the fields of the selected tables and allows adjustments to be made before creating the application, such as changing the data type, display name, and other configurations.

#### Fields

Names of the database fields.

#### Label

Names of the fields in the generated application’s interface.

#### Datatype

Specifies the field’s data type.

#### Grid

Defines the fields available in the grid.

#### Search

Defines the fields available in the filter.

#####