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.
More convenience in configuring fields with inputs for data entry with 100% width as standard. The option is available for the Form, Control and Calendar applications.
New option to display the label as a watermark, available only in the control application.
New sc_statistic macro
Calculates and returns a matrix with statistical values, you can now easily calculate: median, variance, standard deviation, amplitude, number of different values, number of values, number of non-zero values, lower value and higher value.
Save button improvements
The save grid option stores views created with the grid and summary applications, now with more options.
Native option in the security module to remember password
'Remember me' option for login and password automatically generated now by the security module. Also included is a new option to define the position of the labels on the login screen.
Create your own rule, a very interesting resource has been added, which allows you to define the size of the files for the upload field in bytes, MB, or GB, it is also possible to define a specific rule by an extension (Ex: PDF up to 5MB and PNG up to 4MB), this new option is available for all fields that upload files and images.
Connection with cloud databases
Scriptcase now connects to the WS, AZURE, GOOGLE CLOUD, and ORACLE CLOUD databases.
New Option of integration with cloud storage services
The option integrates with cloud storage services like Google Drive, Dropbox, and Amazon S3. You can now safely read and store files and images from your Scriptcase systems.
With the sc_api_download and sc_api_upload macros, it is now possible to create and customize the way you manage your files into the storage services.
New quicksearch options
Quicksearch received new search options with the simple or extended option, the possibility to search in multiple fields, and dynamic configuration of the displayed fields.
A brand-new class of Scriptcase action buttons is ready, you can keep using your own system theme and add in a jiffy.
Real-time JSON
Now in simple steps, it is possible to generate real-time data in JSON format, available at the Grid application, using the macros: sc_set_json_name and sc_set_export_name.
POS Template system
The Point of Sale sample project uses some main resources of Scriptcase such as images, pricing calculations, forms, master-detail, multi-language login and security module including user authentication.
Other implementations
New option to remove the border from applications on the Dashboard;
Added regional configuration parameter in the sc_date_conv macro;
Added file name and size options in the Simple Upload and Multi-upload field settings;
New option on the form to notify the user of discarded changes.
Create your own rule, a very interesting resource has been added, which allows you to define the size of the files for the upload field in bytes, MB, or GB, it is also possible to define a specific rule by an extension (Ex: PDF up to 5MB and PNG up to 4MB), this new option is available for all fields that upload files and images.
Connection with cloud databases
Scriptcase now connects to the WS, AZURE, GOOGLE CLOUD, and ORACLE CLOUD databases.
New Option of integration with cloud storage services
The option integrates with cloud storage services like Google Drive, Dropbox, and Amazon S3. You can now safely read and store files and images from your Scriptcase systems.
With the sc_api_download and sc_api_upload macros, it is now possible to create and customize the way you manage your files into the storage services.
New quicksearch options
Quicksearch received new search options with the simple or extended option, the possibility to search in multiple fields, and dynamic configuration of the displayed fields.
A brand-new class of Scriptcase action buttons is ready, you can keep using your own system theme and add in a jiffy.
Real-time JSON
Now in simple steps, it is possible to generate real-time data in JSON format, available at the Grid application, using the macros: sc_set_json_name and sc_set_export_name.
POS Template system
The Point of Sale sample project uses some main resources of Scriptcase such as images, pricing calculations, forms, master-detail, multi-language login and security module including user authentication.
Other implementations
New option to remove the border from applications on the Dashboard;
Added regional configuration parameter in the sc_date_conv macro;
Added file name and size options in the Simple Upload and Multi-upload field settings;
New option on the form to notify the user of discarded changes.
The exportation component for Excel (XLS, XLSX) in the main Scriptcase applications have been updated to PHPSpreadsheet improving 40% the performance of the exportation process also increases the supported number records.
Automatic execution option for Grids, Forms, and Calendars
The option “Run after creation” was added to the grids, forms, and calendars creation interface. This option allows the generated application to be executed automatically after creation.
The steps are now simpler than ever, you can now set up the initial options of your project in an intuitive and quick way abiding future charset errors into your system.
New template theme for dark tone applications for you to apply to projects developed in Scriptcase. With a few clicks you can completely modify the layout of your applications.
Create, update and delete form confirmation alerts were natively included with the SweetAlert Toast component after adding, updating, and deleting records.
New option to link the Chart’s theme to the application's CSS theme.
More dynamism now in the Charts layout too! With this new option you will be able to associate the chart theme with the project's main CSS theme, so it’s easier to configure and standardize your charts with the new themes released in release 9.4.
New “initial value” option for Advanced and Dynamic Search fields
Your Advanced and Dynamic Searches can now be set to default, with this option you can choose a default value for the Search, so the end user can already have a starting value to optimize the filter's use.
For all tastes, based on the material design concept, new themes generating harmony and softness within your applications, as well as 'action buttons' including stronger colours and flat designs.
Improved the interface for CSS buttons customization
New configuration options for the buttons to provide more freedom to the developer in the customization of themes of buttons. Among the changes are the possibility of inclusion of Font Awesome and Google Fonts, and new options for creating CSS classes for styling. It was also included in a new toolbar option for grouping function side by side inside the application.
'Icons' turned into fonts have now arrived to Scriptcase. These ‘icons’ will always maintain the resolution, including the style configuration of your entire theme.
Friendly and customizable 'SWEET ALERT2' now available for your applications. Scriptcase is giving its users a better notification experience, fully compatible with required fields and macros: sc_ajax_message, sc_error_messageupdate.
Others
Progress bar for XLS (Excel), XML, DOC (Word), CSV, RTF and print export;
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.