Cambridge, MA, January 13, 2020 – Pagos, Inc. announces the release of SpreadsheetWEB 6.15, now featuring record locking, and a major rework of the internal application workflow.
One of the most important updates in this release, server-side caching, was a substantial revision that changed the way SpreadsheetWEB applications handle user data. With this, the majority of the processing during application runtime was moved from the client-side to the server-side. In addition to performance gains, this change also paves the way to other changes in the future.
Implementing server-side caching enables the software to be significantly more aware of each user’s current state, and capable of complex processing and rule generation that relied on changes in that state. Essentially, the system can now detect and isolate whether a specific user interface control has been modified. This feature will not immediately affect any of the current features in the system. However, the software can now allow for other functionalities in the future that depend on such actions, like deploying a robust set of validation rules, or special actions.
Another important feature introduced in this version is record locking. With this implementation, web applications with save events enabled can now be set to lock records that are currently in use by another user. Locked records will give exclusive access to the user that opened it, and will not allow any other user to open that same record until the owner closes the record, or the unlock timeout kicks in. This allows for controlling the concurrency properties of database records to prevent data loss when two or more users try editing the same record. This property will be enabled by default in all new web applications, and can be disabled.
“We have made considerable changes to the way our system handles application workflow. Server-side caching may not have a direct effect the features currently available, but you can be certain that we will have several new functionalities that rely on this type of manipulation in the near future, such as formula-based inputs.” says Ugur Kadakal, CEO of Pagos.
Pagos helps businesses translate their employees’ collective Microsoft Excel expertise into robust web applications, empowering them to create secure, responsive, database-driven applications directly from their Excel spreadsheets. This provides companies with a higher level of governance for critical information and – combined with built-in workflow and reporting capabilities – offers an end-to-end platform for business users seeking to create and manage their own web applications.