All implementations in chronological order. Please make sure that your Scriptcase is updated to receive all new implementations. To verify the update date access your account.
In the form, calendar, control and Grid applications, new field types have been implemented:
Field with "Select 2" component: for select and auto-complete field types a new option to the drop down will provide more performance and accuracy in the select results. The new component allows you to perform a search within the select result, limit the characters and number of records displayed.
Digital signature field: allows the user to use his finger, mouse pointer or a digital pen to make signatures or drawings, it is stored in the database as an image format. It is also available for Grid application.
Rating star field: This field allows you to qualify with stars (or any other image), where the user can select the classification according to a scale previously configured. It is also available for Grid application.
Slider Field: available for integer fields, the field shows a slider component (jQuery range) to allow the user to select a value within a range defined in the application.
Switch toggle field: Available for radio and checkbox field types, the switch uses a component "JS iOS toggle" to check the values on the form.
Continuing the implementations of APIs already released in version 9.1 (Mandrill, Amazon and Mailchimp), we bring in this new version the automatic integration with the APIs for payment and sending of messages (SMS Marketing), which are:
Clickatell, Twilio or Plivo to send SMS.
PagSeguro and Paypal Express for payment services.
We will keep working hard to bring new options to integrate with other APIs in upcoming releases.
We keep extending the filter options for better Scriptcase Grids and reports:
In the advanced and dynamic filters for date/time type fields we have added the relative period customization option, as already available in the summary and chart filters. So now you can have more options with specific periods options within your search options.
We have also added an option in the advanced search tags to save searches in the selector, so the end user can reuse previously saved searches.
In the filter selection it was added an option to display the actual values of the table itself, so that the values will not be repeated within the selection.
We have expanded the options in shortcut keys that were released on the V 9.1, enabling new combinations for both Scriptcase as for the generated applications:
Shortcut keys for Scriptcase applications: option for creating shortcut keys also available for applications created by Scriptcase. The key combinations can be defined according to the functions of each application. The new functionality brings also the possibility of creating templates that can be reused in multiple projects.
New area to customize the hotkeys from Scriptcase: new interface for creating and customizing shortcut combination from Scriptcse’s development environment, with this option you can also share or import a shortcut setting from one dev environment to another.
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:
Added support for XML export and WORD in Nested Grids.
Added option to set generation of XML elements, such as attribute or value.
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.
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.
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.
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
2018
New template system released
New Health and Medical System template released for clinics, hospitals and doctors to create medical schedules and manage electronic health record of patients. The template has all the essential pages pre-made and plenty more for your convenience. Doctor profiles, patient profiles, reports, tables and many more extra pages. Check out the system
RTL (Right-to-Left) text targeting support in Grid Summary Filter: Arabic, Aramaic, Hebrew, Urdu…
Advanced SQL support in Auto-complete type lookup: JOIN, UNION, CASE, INTERSECT e etc.
2017
Improvements in the Report PDF application
Added new text fonts to the Report PDF application: Dejavu sans, Kozminpro regular, Aefurat, Cid0jp, Cid0ct, Cid0kr, Aealarabiya, Free serif, Free sans, Kozgopro medium;
Added support to SELECT fields with checkbox to select multiple values in the filter, dropdown option.
Added support for the third digit in the version increment of the projects;
Added "Start by Filter" option in the Chart Application;
Added the "Between two values" option in the Filter conditions for numeric fields;
Added button to print in the Print export of Grid.
Language Enhancements
Added support for new languages in the calculator used in numeric fields: Catalan, Simplified Chinese, Croatian, Danish, Dutch, French, German, Italian, Norwegian, Spanish, Polish, Brazilian portuguese, Russian, Slovenian, Turkish, Ukrainian.
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 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.
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.
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.
Performance Improvements
Enhanced performance in the recovery of tables and fields, using the application creation interface.
Added treatment in the name of downloaded files in documents fields with exclamation marks (!), Comma (,), period (.), Hyphen (-), plus (+), single quotes (') and spaces.
Grid application enhancement
Added charts link option in pivot table type summary.
See video
Documentation
Français
Español
Italiano
Facebook
Twitter
Youtube
Linkedin
Google+