Version 6.1

Released on May 21, 2018

Major

• Added functionality to include Password Reset upon next login (when generating new users).
• Added functionality to auto-generate user passwords when creating new users.
• Added Send Email functionality for new user creation – the target user will receive an email indicating the user’s new account information.
• File saving added for primary and secondary tables via API.
• Formula added with support for Designer applications: SpreadsheetWEBRecordInfo. The formula allows user to pull in data about the current record into their spreadsheet for reference.
• Implementation of charts and maps for the Designer.
• Implementation of Goal Seek functionality for API.
• Added scheduling feature for custom notifications.
• Added Data page column layout, re-ordering, and value formatting features.
• Added batch calculation request service endpoint to the API.
• Added Button Event Triggers model to Designer, which allows us to generate new Event-based modules that hook into actions throughout the applications. Preliminary implementation includes Calculate & Save actions for buttons being moved into the Event model. Buttons now include multi-select dropdown to define list of events that the button will trigger.
• Added the ability to define print processes in the Designer using Word-based templating with support for complex, multi-page documents, value formatting and mapping to named ranges. This is hooked into the new Events-based model and the action can be triggered using buttons.
• Added the ability to define email processes in the Designer with support for print process output document attachment. This is hooked into the new Events-based model and the action can be triggered using buttons.
• Encrypting additional user information when storing in database (i.e. first and last name, email).
• JSON-based API rewrite, breaking backwards compatibility.
• Created Client Key Management module in Control Panel for Designer, Web Service, and Custom Web Page applications. Also, Fill Database button in Server Configuration to handle migration from older versions of the software.
• Created pass-through web methods in the custom web page base page that will auto-append security features without requiring the developer to manually handle those scenarios.
• Added the ability to code .NET hooks matching our pre-defined interfaces to inject code processing for Designer applications in the following 4 places: BeforeCalculate, AfterCalculate, BeforeSave, AfterSave.
• Support for 83 new Excel formulas. Complete list of supported formulas.

Minor

• Only auto-generate configured available languages when it is not already set (i.e. need to set it to empty in order to regenerate based on files).
• Updated Designer record deletion to use BULK deletion rather than single record-by-record.
• Optimized data record import for Designer-based applications to use bulk insertion rather than single record-by-record.
• Added auto-generating client secret when creating a new site.
• Designer linkage from Output.aspx to SSO into Designer when the user is already authenticated and has the right to access the given record.
• Rewrite for the Custom User Fields in order to align the custom fields with the standard ones on My Account and User Wizard pages.
• Fixed broken URL linkages in Excel files when uploaded to the Designer, which were causing “Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.”
• Selected input grid cells no longer include blue background.
• Fixed redirection to login screen in Designer when the user isn’t authorized to access a record. The attempted action is now retained (e.g. VIEW/EDIT/COPY, etc.).
• Designer Input Grid performance optimization
• General Designer performance optimization.
• For standard converted applications, file-based database columns are now being generated as VARBINARY data types rather than IMAGE.
• Extended timeout for Designer application creation from Control Panel.
• When logged into the Designer while accessing an application, added log out button to the navigation bar if it is enabled.
• For Designer, only allowing Site Admin to use the Import Application functionality.
• Fix for unlocking nodes when running in a multi-engine server environment.
• Applied all filters to the map on the analytics page.
• Added new chart to the analytics page, breaking down the analytics data.
• Added logging for anonymous access to standard converted applications.
• Updated API’s database storage routines to also massage Boolean values for parsing.
• Preventing users from creating Designer database columns with system-specific column names, which can cause issues.
• Configurable reCAPTCHA keys to enable SpreadsheetWEB server owners to configure their own reCAPTCHA settings.
• Updated minimum length for user secret question to 3 characters.
• Update JSON API to get saved values directly on its own from the engine without requiring them to be inputs or outputs.
• Added MirrorProcessCount parameter as a hidden input on custom web pages.
• Maintenance refactor of all Designer control scripts, allowing for caching and performance benefit on initial load.
• Added text alignment to Designer textbox controls.
• SystemAdmin granted access to all designer applications but not able to edit them.
• Ability to create basic one-table dashboards corresponding to Designer application single tables.
• Added record edit link tag ({RecordEditLink}) to notifications.
• Changed the record user assignment list to be in alphabetical order.
• When data structure was changed across versions of converted application files, the system told user to create new application rather than editing existing one. Now, we are allowing the option to update the application anyway with the caveat that any column types that were changed in the file will not be altered but any new columns will still be added.
• Update to allow SystemAdmin to download spreadsheet files.
• New validation rules for Designer save buttons.
• Designer input grid performance updates.
• Designer validation rule to ensure primary table has user-defined columns.
• Designer textbox properties updated to show multi-line inputs when textbox is multi-line.
• Auto-update site maximum values in accordance with license modifications.
• Designer textboxes new property ValidationTriggerType, allowing users to control which types of actions will trigger validation for that textbox’s properties.
• Added GetDocumentStubs method to the API.
• Added two buttons on groups page that allow you to retrieve a list of associated users and applications for a given group.
• Added groups list to the users grid.
• Designer calendar control input year range increased to go as far back as 1900 in grids.
• Added visibility options to Designer input and output grid columns.
• Added pagination feature for input and output grids.
• Better distribution of web service engine requests by busy-ness (made busy-ness a factor instead of a boolean). This helps balance requests across nodes more aptly.
• Added New, Append, Replace options and fixed validation issues on import data page.
• Some minor adjustments for standard converted application input grid aesthetic.
• SendMail API function refactored and updated.
• Implemented interval-based node cleaning and moving the node memory check to the outer engine.
• Multi-line textboxes updated to be readonly instead of disabled when relevant.
• Updates to Dashboard component to resolve issues with re-ordering and deleting tabs.
• Terms of Service Compliance added to the user wizard.
• Support for parentheses and single quotes in worksheet names for the Designer.
• Using JSON.NET serializer for API rather than default serializer for performance boost.
• Optimizing properties (for travel across the wire) of Input Grid, Content/Label, and DateTimePicker in Designer to make significant minification to request size and decrease network-based performance detriments.
• Designer calculate response serialization ignores null values to improve size of response.
• Exposing Application ID in the custom web page base page as a hidden input.
• Added size property to Designer’s dropdown controls.
• Added ability to hide labels for textbox, calendar, dropdown, and file upload Designer controls (by setting Label Size to 0).
• Added toggle style to Designer checkbox.
• Added input caching to the engine when handling web service requests.
• Adding performance counters to collect diagnostic and timing information for numerous events throughout the web service processing life-cycle.
• Further Designer minification by removing default values propagation on subsequent server requests.
• Adding the ability for the Site Admin to override the HasFormulas metadata flag on the InputGridColumnProperties.
• Adding diagnostic performance counter and logging through the Designer layer.
• Updated engine to check memory size on a background thread rather than as part of every request.
• Add regenerate button for client identifier and secret at the Site-level.
• Rearranged footer information of table-based Designer pages.
• Added the ability to clear input grid combo boxes.
• Added options for alignment to input and output grid column properties.
• Added support for special attachments (i.e. camera, video) for mobile devices to the Designer File Upload control.