Scriptcase 9.1

A new universe of possibilities with the APIs

A new interface for managing APIs directly from Scriptcase. This new interface will turn the integration of Scriptcase with external APIs easier. Sending emails using automatic integration with email APIs services like: Mailchimp, Mandrill and Amazon SES will be a simple task on release 9.1!

For those who require further settings there will be two new macros: _ sc_call_api and sc_send_mail_api for advanced implementations with APIs integration within Scriptcase events, control and blanks.

In addition, other APIs will be available in upcoming releases.

Complete reports direct to your inbox

A new way to share reports! Now with Scriptcase 9.1 you have a new button to send emails from Grids, Pivot Tables and Charts with reports attached in pdf, html, xls, xml, csv, rtf, word or images. Push settings can easily be shown within the interface using SMTP, Amazon SES or Mandrill.

Samples

Grid Summary Chart

New export settings

For Chart applications, besides the option to send via email with the new button “Send”, there are also new settings to export to formats: xls, xml, csv, rtf, word and image.

For HTML and Images exports from Chart applications, it was added a new important option for Chart depth output selection, according to the metrics used. This option is also available for PDF exports within Grid Application.

New Advanced Search for Grids and Charts

Within the Advanced Search there are two important new features to improve data analysis and management with dynamic conditions selection, these are:

• New dynamic tags that allow you to select or manipulate the conditions and fields with ajax directly within the application with a simple and modern interface.
• New configurations options that allows, for example, to add buttons within the Search form body.

Samples

Grid Summary Chart Inline buttons

Summary and Chart user search

In the Summary and Chart Search feature were added new relative period conditions to Filter: “Current quarter until today” and “year to date”. In addition to the options for creating customized periods with related conditions directly within the Filter interface. It gives you freedom to create special conditions to your reports!

Productivity now also on your keyboard

Added new keyboard shortcuts for performing basic functions of Scriptcase as: Generate the source code, Save application, Run, Closing/Opening tabs, access SQL Builder and others. In addition, Scriptcase codes editor, used within the events, control and application blank, won new options that will help a lot in programing, among the options there can be highlighted:

• New viewing with lateral expansion or fullscreen code area and access to new themes.
• Integration with shortcut keys from editors Emmet and Sublime Text, that is, the shortcut keys of these editors will be recognized within the Scriptcase.
• CSS and Javascript language interpretation support.

Shortcut keys are available in all browsers that are compatible with Scriptcase. So now coding inside Scriptcase editor gets faster and more comfortable.

Learn more

Database Builder

More fluid Interface facilitating performance for creating and changing your database. New theme, store server-side to avoid excessive requests, accessibility labels (HTML5) and new languages: Danish, Greek, Galician, Bulgarian, Bosnian, Finnish, Hebrew and Malay. Besides these we can highlight:

• MySQL: Support connecting to MySQL via SSL, support JSON data type, Support MySQL 8
• MariaDB: Support JSON since MariaDB 10.2 and support fulltext and spatial indexes in InnoDB
• PostgreSQL: Support binary files in bytea fields, support JSON and JSONB data types, materialized views
• SQLite: Allow deleting PRIMARY KEY from tables with auto increment, enable FOREIGN KEY CHECKS
• SQL Server: Support freetds, support pdo_dblib