We are happy to deliver the brandnew September 2023 release with the new welcome pages, new sheet navigation and many other new features! Try it now!
Remember, the Web Client is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Web App is the tool for the Power User to setup and control your organization’s collection workflows.
(1) Web Client: New Welcome Pages
We are happy that you can create now Welcome Pages in your data1.io Workbooks! These new Welcome Pages can be used to structure the content of your workbook and are mainly enabled by the new sheet navigation feature (see next item):
Furthermore we have solved an issue with dark backgrounds on the sheet – there was an issue with the gridlines which became visible under certain circumstances (depending on the screen resolution).
(2) Web Client: New Sheet Navigation
With the new sheet navigation it is possible to use Excel Hyperlinks (“Bookmarks”) to create a sheet navigation from the welcome page to the detailled pages …
… and back to the welcome page. Other than in Excel all sheets can be hidden and the hyperlinks still work since data1.io makes the target sheet visible when clicking the hyperlink navigation.
Hyperlinks for the sheet navigation are created in the Excel version of your data1.io workbook. Simply create a link on a cell …
… and create a bookmark with reference to the target sheet:
Tipp: you can use the font “Wingdings” to create symbols for the “navigation buttons”:
(3) Web App: Configuration of the “Finish” button
With this release you can customize the “Finish” button in the “workflow box” in the Web Client. Until now, the button was green coloured and named “Finish” …
… with this release you can change the title as well as the color of the button:
This customizing can be done very simple in settings of your workflow:
(4) Web App: Streamlined workflow e-Mails
With the last releases we have made many extensions to the configuration of your workflows. With this release we have streamlined the submission of the workflow e-Mails. For instance, until now, reminder e-mails were only sent to your collector users if the received an invitation e-Mail within this workflow. With this release we removed such “hidden” conditions …
… so that only the visible settings control the submission of the workflow e-Mails:
(5) Web App: Finish e-Mails as cc to organizer
With this release you as a workflow organizer can define to get every individual Finished / Not Finished e-Mails of your collector users as copy (cc):
(6) Web App: Performance Analyzer improvements
We have improved the Performance Analyzer (started with the shortcut “Ctrl + Alt + P”). Until now, the share for the SQL queries was too low for applications with the “Always Encrypted” security feature activated.
(7) Web App: Key Wizard improvements
We removed the Upload button and the Delete button since they were actually not active here. Instead, we have added the useful download button and now you can see the number of records also in the Key Wizard:
(8) Web App: Read Process Dialog improvements
We have also improved the Read Process Dialog which shows now also the origin of the values. This is especially useful for the reconstruction of the result of aggregated queries:
Furthermore we have added download buttons for the lists in order to improve analysis of the data in Excel.
(9) Web Client: Warning unsaved data
If your collector users press the back button of their browser with unsaved data, they get now a warning which helps them to prevent the loss of the unsaved data:
(10) Web Client: Improved copy & paste capabilities
We solved the following error when pasting values from special formatted Excel sheets and improved the copy & paste capabilities between different workbooks in different browser tabs.
Furthermore we improved the copy & paste behaviour when pasting date values which are formatted as string.
(11) Debugging and further improvements
We have solved an issue with so-called ExceptionType definitions within the workbook. They were applied also to other sheets within the same workbook.
We have solved an issue with poor workbook performance when validating if the Write button should be active or not after a change in the sheet. And we have solved issues with poor write performance under special circumstances.
We have solved an issue with the upload of the workflow users list (in general there was an issue with all uploads into tables with active validation rules).
Another issue was an inconsistency of the “Workbook wizard” with the Upload button for workbooks.
Furthermore we have improved the READ performance when the browser tab is not active.
There was also an issue in the dimension tree which reloaded under special circumstances on the first selection of an element.
Last but not least we solved an issue with heavy RAM usage when using the Iterate function.
Hope you like the new features – we are very curious about your feedback!
Please let us know what you think and what kind of collection processes you would prefer to automate with data1.io.