We are happy to deliver the brandnew December 2022 release with the new “Aggregate only visible elements” function 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 option for “Aggregate only visible elements”
Until now, on a sum level all values from all elements below were aggregated. This can lead to unexpected and even incomprehensible aggregated values, if there are “dormant” values on records from hidden elements or values that were written to the wrong element type (for whatever reason).
The new option “Aggregate only visible elements” sums up values from subordinate elements with 2 conditions:
- The Treefilter (from the named range “data1_TreeFilter” on the sheet)
- The element attribute “Is Visible = True” (from the dimension table / tree)
The option is activated via a new setting on the workbook:
With the option activated you can be sure that the values on an aggregated level are by guarantee the sum of the visible elements below that node:
(2) Web Client: New option for “Allow Comments”
The “Add Comment” function in the workbook is not in all cases a useful or desired feature:
For this reason we introduce a new setting – also on the workbook level – to activate or deactivate the comments function in the workbook:
(3) Web Client: Sheet changes now with “You have unsaved data” message
A small but important new feature for all multi-sheet applications is the “You have unsaved data” message which is triggered now not only by changing the active element in the dimension tree but also on changing the sheet if you have unsaved data:
This new behaviour makes it more realistic NOT to sync especially the READ process over several sheets of the workbook. That in turn can save a lot of performance in such multi-sheet applications.
(4) Web Client: Display of long tree element names
Until now, long element names in the dimension tree were wrapped over several rows. This looked a little bit messy, now we changed that behaviour that way that each element is shown in one row independently from the text length:
(5) Web App: New table filter “Is Empty”
We have added the new “Is Empty” option in all table filters which makes it much easier now to e.g. delete such records from a table in the backend of your application:
(6) Web App: Table filter with several conditions
There was an issue when you combined several filters on the same table with the “Match Any” option. This is solved now so that you can combine any filters on the same table:
(7) Web App: New retry logic
In the cloud service, we have implemented a new “retry logic”. This helps to handle connection errors, timeouts etc. and makes the Web Client as well as the Web App more stable.
(8) Install data1.io as Browser App
It is possible now to install the data1.io service as a Browser App. Browser apps are supportd in Chrome and Edge but not in Firefox at this time.
Simply click the “Installation” option in the menu of the browser …
… and then install it:
Now you can use the data1.io service like an app on your desktop: you can simply pin it to your Windows Taskbar and start the Web Client or the Web App this way.
(9) Technical Improvements and debugging
There was an issue with the dropdown list for the definition of the element type in the dimension table.
Another issue was solved with cell comments which were not shown correctly in multi-sheet applications.
Then an issue with the READ process in a vertical “data1_CELLS01_ByColumnMapping” scenario had to solved as well as an issue with the ExceptionType2.
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.
Stay healthy and we #StandWithUkraine