Creating a Form 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

When selecting the application, the following screen will appear.

On this tab, you must select the connection to be used in the application. Once the connection is selected, the tables will be loaded and displayed in the Table field.

You can select more than one table when creating applications.

After selecting the tables and fields to be part of the application, the application name will be generated using the type + table name.

Example: form_orders
However, you can change the application name to any other name you prefer.

Connection

This field lists all connections in the project and defines the connection that will be used by the application.

Select the connection to list the database tables.

Connection with Data Dictionary

When the selected connection has a Data Dictionary linked to it, the dictionary name will be displayed below the Connection field.

This information indicates that the connection has a configured dictionary, which can be used to fill in the field labels with lang in the generated applications.

By clicking the dictionary name, a screen will be displayed where you can link new tables to the Data Dictionary. Use this option if the table selected to create the application has not yet been configured in the dictionary.

For more details, access the Data Dictionary documentation.

Name

Defines the name of the application that will be created. This field is required and must contain between 1 and 64 characters.

Alphanumeric characters, period (.), hyphen (-), and underscore (_) are allowed. Spaces and other special characters are not allowed.

Table

Defines the table that will be used as the application’s data source.

After selecting the table, the available fields will be listed in the Fields field, allowing you to define which fields will be part of the application.

Localization

Defines the default language of the application that will be created. By default, Scriptcase selects the Inherit project default language option, making the application automatically use the language defined as default in the project properties.

If necessary, you can select a specific language for the application. In this case, the application will use the selected language, regardless of the default language defined in the project.

After creating the application, the application language can be changed in Application > Settings. If the Inherit project default language option is selected, the language used will be defined by the project’s default language, which can be changed in Project > Properties.

Edit language charset

You can also change the charset used by the language in the application being created. To change the charset, click the edit button displayed next to the language selection field.

When clicking the button, the option to change the charset of the selected language will be displayed.

Note: This change will be applied only to the application being created. The charset defined for the languages in the project settings will not be changed.

Create application as a multi step form

When this option is selected, the form will be configured in a step format, dividing the filling process into multiple pages.

This functionality is available only for single-record forms. After creation, it is possible to revert to the traditional format by adjusting the page settings.

Number of steps

Defines the initial number of steps the multi-step form will have, creating the blocks and pages that compose the form automatically. The fields will be distributed across the created pages and can be rearranged later by adjusting the field positioning.

Edit Fields

This screen displays the fields from the selected tables and allows you to make adjustments before creating the application, such as changing the data type, display name, and other settings.

• Fields - Lists the fields from the table used to create the application.

• Label - Defines the text displayed for the field in the generated applications. When the table is associated with a data dictionary, Scriptcase uses the language variables associated with the fields and displays the translation icon, allowing you to change the text of the lang used in the label.

• Data type - Defines the field data type, such as text, number, date, or other formats used by the application.

• Insert - Defines whether the field will be available to be filled in when inserting new records.

• Update - Defines whether the field will be available for editing when updating records.

• Read-only - Defines whether the field will be displayed as read-only, preventing changes while the application is running.

• Required - Defines whether filling out the field will be mandatory.