Feedback Print

General View

Scriptcase Applications

The Scriptcase offers a wide range of applications that allows the developer to create a complete system. The Scriptcase also allows the integration of the applications with external libraries, boosting its power in the systems development.

See below the available types of applications.

Grid

Application used to display data, this application serves as a report where we can do exports to PDF, XLS, XML, and other formats.

Procedure

Similar to the grid application, this application is available for few databases (MSSQL Server, Oracle and Db2) when selecting the connection, in case the user have a procedure that returns information it will be displayed in this special application.

Form

Application used to insert and update data, there are four different types of orientations.

Tabs

This application allows the creation of tabs where we can put up other applications like grids and forms.

Control

This application is used to create controls in a system, it is not linked to a table, and it needs the creation of one or more fields to its operation. A example of using is in the creation of a login screen.

It is used to create a hierarchical structure to navigate through the system’s applications. There are two types of menu available in Scriptcase, Horizontal Menu and Tree Menu, that differs only in the preview of its items.

Application used to create searchs exclusively to forms.

Report PDF

Application used to generate reports using pre set formats, where we can position the data in the report.

Dashboard

Allows the developer to display applications inserted in widgets.

Blank

This application allows the insert of PHP code / HTML and displays the result of its processing. The advantage of using this application is the possibility of using macros and the native integrations with the other applications.

Calendar

Application where we can maintain an event schedule that can be synchronized to the google calendar.

Batch Applications Creation

With this tool, it is possible to create multiple applications (Form and Grid).

When creating grids and forms using the same table, the applications are created with an application link between them, allowing to edit the record from the Grid application.

To start the process of creating the application, you need to select a connection so that the tables can be listed.

Select the connection that you want to use

Next, you need to select the tables that are going to be used to create the applications. When selecting the tables, you can define which applications (Forms and Grids) are going to be created.

Selecting the tables and applications for the creation

For last, you need to define the name, description and type, in case for the Forms.

Adjusting the applications that are going to be created

  • Name - Name of the application that is going to be created.
  • Description - Application Description.
  • Type - This option is only available for Forms, defines the type of form that is going to be created (Single Record, Multiple Rows, Editable Grid and Editable Grid “View”).
  • Generate Source - Selecting this option all the applications to be created will have their source code generated.
  • To edit - Selecting this option all the applications created will be open for modifications right after creation.

Express Edit

This feature allows to restore the project’s applications that has been modified recently. When saving the application, ScriptCase stores automatically a limited number (defined in Settings > System Settings on the option Number of automatic application copies) of copies of the application, so that they can be restored. First, we need to select the application that you want to restore.

Select the desired application

Previously, you need to select the restore point that you desire and also define a name for the restored application.

Selecting the restore point and defining the app name

Restore Applications

In this article, you learn how to edit various application at the same time. Using the Express Edit tool, you can define values for various common attributes for these applications. It is useful specially to add updates to your applications.

Only some settings are available within the Express Edit tool.

This tool can be accessed from the menu Tools > Express Edit.

Select Application

Firstly, You need to inform which applications You want to edit.

Define the affected applications

All

You edit all the applications in the project, with no exceptions.

Select Applications

All the applications existing in the project are listed so that you can select the applications that you want to edit.

Select the application to edit with the express option

Apply Modifications

After selecting the applications, you define the modifications that you want for those applications. On this page, You can define how the modifications are applied.

Defining the modifications for the applications

Appling to all the applications

This option allows applying the same configurations, to all the selected applications, automatically.

Header Image

Define the image for the header of the applications.

Use Security

Define the use of security on the applications of the project.

Enable direct call by URL

Allow the applications to be called directly by the URL.

Enable CSRF

It enables “Cross-Site Request Forgery” protection. (This option only applies for the Control and Form applications)

Show HTML content

Defines if the HTML code stored in the database is interpreted or not by the browser. (This option only applies for the Grid application)

Remove the HTML tags

Defines if the HTML code stored in the database will have the HTML tags removed for display.

Run content in JavaScript

Defines if the JavaScript code stored in the database runs on the browser.

Save HTML tags

Stores the HTML tags informed within the Application field to the database. (This option only applies for the Form application)

Text input in JavaScript

Stores the JavaScript informed within the Application field to the database. (This option only applies for the Form application)

Fixed Label

It allows you to transform the Fields labels in static labels when you scroll down the page.

Use Select2

It allows you to apply the Select2 as default in the applications.

Grid export modules

It allows you to select the Grid Modules in the exportation.

Export with Password

It allows defining a password in the Applications exportation.

Select columns of Export

It allows selecting the desired application columns in the exportation.

Distinguish uppercase/loYourcase

It allows the Scriptcase to distinguish the letters uppercase and loYourcase.

SYouetAlert

It allows using the alerts messages with SYouetAlert components.

Toast

It allows that all Scriptcase error messages use Toast error messages.

Language

It applies the selected language for all the selected applications in the project.

Connection

It applies the desired connection (Connections created in the “New Connection” module) for the applications.

Connection for fields

It applies the desired connection (Connections created in the “New Connection” module) for the fields in the applications.

Theme

It applies the desired Theme (Only the ones included in the Project properties) to all the applications.

Hotkey Templates

it allows configuring the hotkey template for all applications.

Reset Toolbar

It allows resetting the application toolbar settings.

Template

Change the Header and Footer template of the applications.

After selecting the modifications that you want to do for all the applications, you see a list with all the selected attributes.

Apply the modifications to all the applications automatically

Apply individually

This option allows you to apply the modifications individually for each application selected. This option contains not only the previous attributes, but also three exclusive attributes.

Description

It applies a description individually for the selected applications.

Friendly URL

It applies a friendly URL individually for each selected application.

Title

It applies the title individually for each application.

After selecting the modifications individually for all the select applications, It displays a list with all the selected attributes listed for modification.

Apply the modifications individually

When you apply the modifications, It displays a list of the applications that Youre modified.

Application Generation Log

Save Applications

This option saves the application opened in the edition mode. This option can be found inside the applications menu or in the default toolbar, also being possible to use the shortcut CTRL+S.

Importar aplicação

Generate Source

Different from the generate source code found in Project, this option saves and only generate the source code of the opened application in edition mode. This option can be found inside the menu Applications or in the default toolbar, and it is also possible to use the shortcut F8.

Generate Source

Execute Application

Saves and execute the application that is opened in the edition mode. This option can be found inside the Application menu of in the default toolbar, and it is also possible use the shortcut F9.

Run Application

Export Applications

Every application of a project or some applications can be exported. In this export, not only the application but also the needed archives to its operation of the selected applications are exported.

This option can be found inside the menu Application.

Firstly you need to select if you want to export all applications or if you want to select some applications.

Export application

When select all applications, it will be displayed with the export log and the link to donwload the generated file.

In this example, we choose to “Select Applications”, in this case the applications are listed according to the type or folder.

Application list

To proceed, select the desired applications and click in export. After this it will be displayed a log of the exported files and a link to download the generated file.

Export log

Import Applications

Allows the developer to import applications created in the same version of Scriptcase. This option can be found inside the menu Application.

After the import application screen is displayed, select the file you want to import.

Importar aplicacao

The options are:

Opcoes Importacao

Overwrite - Overwrites the project’s files by the files that are being imported. Don’t overwrite – Keeps the project’s files, ignoring the files that are being imported. Rename – Keep the project’s and import the files selected with the defined names.

In the next step, show a summary that will be restored.

Resumo dos arquivos restaurados

Source code

In this option is possible to see the application’s source code after it generates.

Código fonte

Session data

In this option, it is possible to see every session variable available in the development environment, it is the session tree that Scriptcase stores.

Dados de sessão