With the release of Pagos SpreadsheetWEB 3.0, a host of brand new features will enter the framework of SpreadsheetWEB. One of the most pertinent new installments is the addition of scripting support. Support for scripting enables end-users to implement Javascript code as well as html tags into their web-based applications, broadening the functionality of their finalized web pages. Using Javascript, end-users will be able to seamlessly integrate utilities hosted by other organizations with open APIs into their own web applications.

Adding new script to an existing spreadsheet is as easy as writing Javascript code in an HTML editor. Developers will be able to reach HTML fields and even spreadsheet cells by adding Javascript/HTML codes from the script editing page. They will be able to validate their forms, override before and after calculation calls and even integrate 3rd party products such as Google Maps, PayPal, 3rd party charting and visualization products, etc… with their final web pages. Since scripting also supports adding HTML tags directly, users will be able to add new input fields, styles, embedded scripts, embedded objects (like Flash)  directly to their final pages.  Scripting gives unlimited flexibility to development-oriented users to integrate their custom web pages/parts with SpreadSheetWEB generated web pages.

The Scripting functionality can be found under the worksheet controls page of the wizard. To enable Scripting support, simply tick the check box next to "Scripting/HTML". To edit the script, press the "Edit" button next to "Scripting/HTML". You will be greeted with the following pop-up:

Bear in mind that you must have at least one input for Scripting support to be enabled. If you do not have an input, pressing the "Add Script" button will return an error message. To add scripting to the web application, press the "Add Script" button and a pop-up (like the one below) will show up, allowing you to input script. This script can either be Javascript or HTML. When you are done, press OK.