Scriptcase Timeline

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.

Documentation

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

New project with GoJS: Mind Map diagram

New example with the powerful HTML diagram library of GoJS for creating Mind maps. A Mind map is a type of spider diagram that organizes the information around a central concept with binding branches. Focused on information management, knowledge and intellectual capital; for understanding and troubleshooting; in memorization and learning; In the creation of manuals, books and lectures; As brainstorming tool (storm of ideas); And in the assistance of the strategic management of a company or business.

This example will be available within the Samples project, which can be imported into your Scriptcase.

Chart Application

• New aggregate functions have been added to Chart metrics (Count (COUNT), DISTINCT COUNT, Variance (VAR), Standard deviation (STD);
• New date dimensions for date fields (Semester, Quarter, Trimester, Semester and others);
• Analytical combination of different dimensions in the same Chart, multi-series option. Check out a Multi-Series Chart sample;
• Added a new Filter type to the Summary module (User Search), using this filter the final user can select values dynamically within the application. Check out User filter sample;
• New LIMIT function that can be used to rank the values within the grid or summary. For example: summary with the 10 best customers, 10 cities that have sold less in 2016, etc;
• New chart types (Scatter, bubble, Semicircular and Linear Gauge, 2D Funnel and 2D Pyramid);
• New customization options that are specific to bar, column, pizza, and gauge Charts (Values Positioning, Values Orientation, Format of values and others);
• Possibility to export charts to: PNG, JPG, PDF, SVG and XLS.

Dashboard Application

• New interface, with drag and drop to configure the widgets dynamically;
• Responsiveness for displaying widgets in Dashboard view;
• New index widget for displaying KPIs (performance meters) within the Dashboard. Check out a Business Intelligence sample;

Grid Application (Reports and Pivot Table)

• New interface for the Grid creation with the option of selecting multiple tables and fields directly in the creation interface;
• Added new features for Summary metrics (Count (COUNT), DISTINCT COUNT, Variance (VAR), Standard deviation (STD);
• New dimensions for date fields (Semester, Quarter, Trimester, Semester and others);
• Possibility of dragging the same dimension (for different date period fields) or metric (with different SQL aggregate functions) more than once into the group by and summaries;
• Added a new Filter type to the Summary module (User Search), using this filter the final user can select values dynamically within the application. Look how User filter works;
• New LIMIT function that can be used to rank the values within the grid or summary. For example: summary with the 10 best customers, 10 cities that have sold less in 2016, etc; Look how Summary LIMIT works;
• New configuration options within the summary aggregation: display the count of rows in the summary, hover showing column values and display the value in the subtotal line.

Control Application

• New option within the Control application that will allow the integration of Scriptcase forms with customized HTML and CSS or importer from external libraries. This option gives total freedom for forms layout customization;
• Body handling variables from HTML, visual can now be changed completely and adapted to the form with the proper Scriptcase Marchkups;
• Possibility of integration between the layouts created by the control application with the security module login screen. Take a look in a Login Form sample and in a Contact Form sample.

Report PDF Application

• New drawing option with drag and drop and dynamic configuration of fields within the same interface. Check out a Report PDF sample.

Menu Application

• New option "menu structure" for layout customization with the option to use external libraries, methods and dynamic variables;
• Option to expand/collapse the menu to hide the items and expand the desktop within the application generated.
Check out a Menu Structure sample.

Scriptcase Interface

• Most of Scriptcase interface has been modified, thus improving the usability of the tool for developers;
• New interface for creating projects with Search option;
• New interface for building grid applications (grid, search, chart and PDF Report) with a multiple-table grid, multiple fields and validation of dependencies while creating the application with automatic identification of JOINS. New graphical interface to change the relationship between the tables;
• Option to expand/collapse the top and side menus to hide items and expand the desktop inside Scriptcase interface.

Environment and Security

• Support to PHP 7.0;
• Connection PDO drivers updated (MSSQL Server, MySQL);
• Added the PDL Dlib driver for MS SQL Server;
• Added the new MySQLi drive for MySQL connections;
• SSL for secure connections with MySQL;
• New version of Apache 2.4.25;
• WKHTMLtoPDF library update;
• Fusion Chart library update;
• ER Diagram - New feature to improve the database management options, in addition to the SQL Builder and DATABASE Manager, was implemented support for creating ER Diagram for databases connected to Scriptcase;
• Project Diagram - New tool for generation of the Project Diagram. With advanced viewing and printing options;
• Social login option with Google, Facebook and Twitter automatically using the Security module;
• New encryption options for the password field in the login application (MD5, SHA1, SHA256, SHA512);
• Security module integration with the new option of free-form control with templates responsive to login screen;
• Creation of a new "default group" in the security module group table (in that group will be added new users that enter through the new user form generated by the module or by social login optio;
• New option of integration with LDAP and groups creating on the Scriptcase users administration environment (development environment);
• Component update for automatic generation of captcha function to the login screen generated by Scriptcase security module.

Scriptcase Environment

• Now its possible to send messages between Scriptcase users;
• New tool for managing Scriptcase images;
• Tool for creating TO-DO list among users;
• New tool for editing Chart themes;
• New library manager;
• New HelpCase generator;
• Added new configuration interface for Form and Grid applications.

Database

• Tool for converting MS Access, CSV and XLS databases to MySQL, SQLite, PostgreSQL and MS SQL Server.

Grid Application

• Added new parameters in the Refined Search theme editor;
• Added a new totalization of the "Weighted Average" type;
• Added new field to accumulate values of other fields.

Menu Application

• Added new parameters in the theme editor for Menu Tabs;
• Added new parameters in the theme editor for Menu Navigation Path;
• Added option for background image in advanced theme settings for Menu application;
• Added new path (breadcrumb) navigation in menu application.

Others

• New version of the security module with user login and blocking by Brute Force;
• Implemented mobile responsiveness to applications Form;
• Added support for the TCPDF class in the Report PDF application;
• Added new sc_webservice macro with support for soap, curl, file_get_contents and sockets services;
• Button grouping option in applications that have toolbar;
• Implemented improvements in calendar application;
• Added support for the sc_url_library () and sc_include_library () macros;
• Added new button of type Ajax.

Scriptcase Environment

• Option for grouping buttons on the application toolbar to optimize usage on mobile devices;
• New configuration interface for form and Grid applications.

Tools

• Implemented a new messaging tool for users of the same Scriptcase installation;
• New tool for managing all Scriptcase images;
• New tool for creating Message List among users of the same Scriptcase installation;
• Added new tool for editing graphic themes.

Form Application

• Implemented mobile responsiveness to applications Form;
• Implemented dynamic search in Form applications.

Grid Application

• Implemented new dynamic filter, break, and summary functionality in Grid applications;
• New options for aligning and positioning the number of pages in the PDF export.

Chart Application

• Created Chart application to create charts separated from the Grid.

Calendar Application

• Improved visualization of past, future and present events.

Report PDF Application

• ​Support for the TCPDF category in the Report PDF application.

Scriptcase Environment

• Multithreaded processing in source code generation of applications;
• Added friendly URL option in the Project home area in the application listing.

Grid Application

• Added support for Ajax in Grid applications.
• Added option to create links to Grid or sub graphs (more than one field per order by) in the summary chart settings.
• Added end-user configurable chart option in summary graph settings.
• HTML5 graphics support.

Menu Application

• Mobile menu support.

Tools

• Added toolbar customization tool for user in the Scriptcase configuration menu.

Others

• Added friendly URL option in general application settings;
• Integration with PayPal;
• Buttons with social media integration (Facebook, Twitter and Google).

Authentication options

• New authentication options for applications developed with Scriptcase: Facebook, Twitter and Google.

LDAP Security Control

• Scriptcase will provides application security using LDAP. Offering full user control through local network administration.

HTML5 Charts

• All Charts will be available in HTML 5, compatible with mobile platforms. New types of Charts have been added.

Upload "drag n drop" from multiple files

• New upload component of multiple files and images, all that with “drag and drop” features and progress bar available.

Listview Menu

• Listview menu is commonly used in mobile applications. This new option will help development of systems for mobile platforms.

Menus Toolbar

• Toolbar option is now available for Menus applications.

Ajax Events Grids

• Ajax technology has been incorporated into Grid applications, allowing the Ajax processing in lines of records of the Grid.

Reports with Dynamic Group by

• This new option allows the end user to select from several options to Group by at run time.

Modal insertion in an Editable Grid

• Option to add records in an editable Grid by opening a single record form in a modal window.

New PDF Generator

• The PDF generation component has been changed to fit HTML5. The new component will also allow the PDF generation in the Forms.

Master/Detail with Single Registration Forms

• Master / Detail Forms can now use Single Signature Forms as a detail.

New Percentage Field

• New field type that performs automatic percentage calculation.

Labels under the field

• New option in blocks to use labels below the fields.

PDO Connections

• New PDO driver for MySQL, PostgreSQL and MS SQL Server connections. Faster and more consistent connections.

Others

• Control of users logged into applications;
• Time field option with am/pm values;
• Macro for time difference;
• Display values in multiple languages;
• New Google Maps API v3;
• Integration with Paypal.

Scriptcase Environment

• New interface for editing and viewing header, footer and freeform;
• Support for multi-byte characters;
• New event editor with higher performance and autocomplete of macros.

Tools

• New tool for management, creation, edit and updating in SQL tables, for the following databases: MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle;
• New graphics configuration interface.

Others

• Automatic creation of security to applications;
• Creating security on three levels: user/user and application/user group and application;
• Automatic creation of security management applications and their SQL tables to record the information;
• Control user access to include, change, and delete operations in SQL tables and information export operations(Log Module);
• Option to access through pre-registration by the users;
• Automatic password recovery;
• Unblock login only via email.

Applications

• New Search button available in the Toolbar;
• Display Summary with number of records and records in view;
• New button with the option to go straight to a particular record or page;
• New button to specify number of records per page. informing the quantity or selecting it in a combobox;
• Option to create labels for grouping titles of fields;
• New interface for selecting fields that will be part of the inclusion and / or change;
• QRCODE type field support;
• Displays page numbering for easier navigation;

Form Application

• New button to clone Form records(copy);
• Identification of unique indexes - Creates automatic validation and placement of fields as required in the Form;
• Foreign key identification - Creates automatic validation and pre-coding of automatic lookup;
• Identification of not null fields, assigning mandatory completion automatically;
• JQUERY calendar in the Search allowing to display period;
• Added new SPIN type field in Forms;
• Added option for the Combobox field with multiple choices with checkbox;
• New Calculator operating in normal or scientific mode;
• Added the color palette field.

Grid Application

• Added option for generating Gantt Chart;
• Export of Grid records in DOC format;
• New Chart types: Gauges, Radar and Polar;
• New Charts format settings: Cylinder, Pyramid, Cone and Funnel.

Menu Application

• New images for use of icons in the Menu.

Search Application

• Validation of required fields in the Search.

Scriptcase Environment

• Improvements in Scriptcase performance;
• Added new languages: Slovenian, Hindi and Finnish.

Applications

• Option to validate fields with image;
• RTL(Right to Left) writing direction support. For Arabic languages.

Form Application

• New option to disable fields in certain mode(INSERT, UPDATE);
• Automatic tabbing, advancing when the field reaches its maximum size;
• New option to group date and time;
• New option to use Year as combobox;
• Focus on the field with error when submitting the form;
• Field with focus when starting the application.

Calendar Application

• ​Created Calendar Application.

Applications

• ​Added new types of Google Maps, Youtube and Barcode fields.

Grid Application

• ​Added new quick search button in Grid toolbar;
• Support to Charts in flash.

Container Application

• ​New Container/Dashboard application.

Grid Application

• Support to Flash graphics.

Scriptcase Environment

• Added express application creation option.

Form Application

• Added option to use Captcha in Security.

Menu Application

• Support for creating dynamic menus;
• Added Tree type for Menu applications.

Scriptcase Environment

• Support to multiple languages.
• Navigation using tabs on the interface within Scriptcase.

Form Application

• Master-Detail functionality;
• New Form types added: Editable Grid and Editable Grid(view);
• Added new HTML Editor field type.

Tools

• Added Helpcase tool (Project documentation generator).