SpreadsheetWEB 6.6 update brought many new features for helping our users do more with their designer and dashboard applications, as well as in the control panel.
SpreadsheetWEB platform ties applications and users on the basis of groups, as well as other user rights to allow for a highly customizable application and data access structure. One of the biggest updates in this version is in our user management module. System administrators can now give certain user roles the ability to manage other user roles in the system. This effectively means that our clients can now build a hierarchy inside their SpreadsheetWEB license, where a multi-layered user management system can be implemented. Please note that custom roles are not available in our public cloud accounts.
Dashboards now enjoy the addition of 3 new map types – Density, Location, and Route maps. These maps feature a new way to plot data using latitude and longitude values, instead of region names. You can now plot any data with coordinates, even geographic events! Below is a density map showing the concentration of hurricanes between the years 2009 and 2013.
In addition to the new maps, we’ve also improved dashboard filters to automatically narrow down available options, when you activate another filter that affects your visualizations. This means that you won’t see any irrelevant filter options anymore when drilling down into your data.
In Excel, you often find sections that group inputs and calculated fields in the same table, for the sake of easy data access. You can now do the same in SpreadsheetWEB 6.6! We’ve introduced the ability to enable or disable certain rows in input and output grids, by tying them to a Boolean field in designer applications. This essentially means that you can create fully dynamic tables and manipulate them using Excel formulas to create flexible grids where users can enter data and get results.
SpreadsheetWEB’s self-service approach to web applications and reporting tools allows Excel users to do much more, without going through the hoops of dealing with IT projects or learning how to code.
This ‘quality of life’ update brought more flexibility to our designer and dashboard modules, and we hope that you’ll like these new features as much as we do. For a full list of changes, fixes, and new features, please see our user guide.
Don’t forget to sign up for a 30-day free account if you haven’t done so and start transforming your Excel spreadsheets into web applications in no time.
Also check out our video to see all new features in action!