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.
SpreadSheet Web Scripting support screen
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.
For example, PayPal is an e-commerce business that allows users to make safe and secure payments and money transfers over the internet. Since PayPal offers an open API to users, it’s possible to incorporate PayPal’s payment system into a SpreadsheetWEB-created web application.
This is a rudimentary example of PayPal integration with a SpreadsheetWEB application. The cost calculator is on top, allowing the client to select the type of good that they want as well as the quality. The page automatically calculates the tax, shipping, and total costs and then allows the client to use PayPal directly to pay for their purchase.
With just the click of a button, the client is forwarded to PayPal’s website where they can safely transfer money to make their purchase.
With scripting support, the possibilities for integration become endless.
