SpreadsheetWEB’s Control Panel offers quick access to many features such as the ability to manage web applications and users in your account, track user analytics, access saved records, and more. This approach works well when you want all features in one place, without having to deal with the backend of things. However, just like in any software, using the Control Panel can take some getting used to, and this may not be ideal in some scenarios where you only want your users to access your applications, and don’t want to deal with anything else. For this purpose, we’ve added the Single Record per User feature in this version. Web applications with this feature enabled will allow users access their own data when they open the web application. In other words, all end users will be assigned one records, and will always be interacting with that same record. This means that you can now configure your applications easily for a scenario like a membership for end user access.

This feature can be enabled from the Edit Application page in the Designer interface. After enabling it, you also need to make sure that the application Access Type is set to either Restricted, or Restricted with Registration. And finally, the end users that are to have a single record assigned to them must be assigned a role that does not have access to the Control Panel.

Let’s take the example of a retirement calculator that calculates how much you will have saved by the time you retire. Running what-if scenarios by changing the values can be something everyone might want to look into, but it would be a hassle to enter all your details from scratch every time you access this tool.

When Single Record per User is enabled, users are going to be able to register for an account, access the application, save their data, and then pick up where they left off, without actually doing anything other than logging into the application. This way, you also end up only exposing the web application interface to your end users.

The next exciting new feature in this version is in Queries, where you can create your own database calls without any coding knowledge. This powerful capability has been allowing SpreadsheetWEB users to easily decouple the data from the Excel workbook, and seamlessly use the data from another application in calculations. The Query Triggers feature added in this version gives you even more control over when and where each database query is to be run. These options can be found on the bottom of the Edit Query page.

query triggers

These properties allow you to enable queries at certain points, such as when an application first loads, and fine-tune the end user experience. Now, you can even assign database queries into Action Buttons as Events.

query triggers

We’re constantly building on our promise of providing Excel users better tools to create, share, and manage their projects. In addition to several bug fixes and performance improvements, we also added address support into Location maps. This way, you can now use either coordinates, or full addresses in this map type. We hope that you’ll like these amazing new features as much as we do! For a full list of changes and new features, please see the change log.

Feel free to sign up for a 14-day free account, convert your workbooks into versatile web applications in no time.