We are happy to deliver the brandnew May 2026 Release with many new frontend functions! Try it now!

Remember, the Frontend is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Admin Center is the tool for the Power User to setup and control your organization’s collection workflows.

(1) Frontend: Performance impact of conditional formatting

We have learned that a large number of conditional formatting rules in the Excel sheet, which is uploaded as workbook into your data1.io application, can cost a lot of READ performance.

To find out, what is the impact of the conditional formatting rules in your workbook, simply open the “Spreadsheet Options” (available for admins of this application) …

… and you will find a new button “Clear conditional formats” and the number of existing rules. By pressing the button, you can remove all formatting rules from your workbook:

Now you can test the performance of the read process of your worksheet with the performance analyzer (Strg + Alt + P):

Please be aware that the conditional formatting rules are removed from the workbook permanently – you have to upload the workbook again to restore the conditional formatting rules!

(2) Frontend: Improved Calculation Wizard

We have introduced the Calculation Wizard back in July 2023. With this release we add the possibility to define which calculation modes should be supported.

a) New definition

Until now, you could only define the reference column / row for the calculation. With this release, you can add the calculation mode after a pipe | as a separator:

• [column]
• [column] | *
• [column] | */
• [column] | */+-

b) How to use

Of course you can enter “*3” and the value of the reference column …

… will be multiplied by 3 and the result will be written into the cell:

The new thing is, that you can now enter normal negative values (“-50”) or normal positive values (“+50”) without triggering a calculation executed by the calculation wizard:

(3) Frontend: New mode for Write Validations

We have added a new mode for Write Validations. Until now, write validation had only 2 states – none ore blocking writeback. With this release, we have added the warning which still enables writeback of the data:

The parameter data1_Write_Validation knows 3 states now

• 0 = no message
• 1 = message & writeback is blocked
• 2 = message & writeback is still active

(4) Frontend: Changed Cell Format

There were some issues with the Changed Cell Format feature. That means, when you change the value of a cell, this cell will be formatted in the defined way (here: turquoise background).

a) with % sheets

Until now, sheets with the entry of exclusively % values, were not formatted as defined. With this release, this also works now without any restrictions.

b) with conditional formatting

If you define your “yellow cells” as a conditional formatting, then this was stronger than the Changed Cell Format definition. If the base colour was yellow and the top level formatting was defined as conditional formatting, then the Changed Cell Format definition worked on the bottom level.

With this release, the Changed Cell Format is now stronger than the conditional formatting rules of the worksheet.

(5) Frontend: Write Always On now also with Aggregated Level Queries

We have introduced the “Write Always On” parameter with Release November 2024 and we have extended this function to sum levels with Release March 2025.

Until now, the Write button was automatically deactivated when the sheet contains aggregated level queries. With this release, the “Write Always On” function activates the Write button in such scenarios.

Please be aware that rows or columns with aggregated level queries are always read-only and furthermore cannot be activated for writeback. With the new function you can use writeback

• in other rows or columns without aggregated queries in the same CELLS0x area
• in other CELLX0x areas within the same sheet

This new feature can be used for instance

• enter comments directly in aggregated reports
• enter adjustment bookings directly in aggregated reports

This new feature opens many possibilities to create combined workbooks for (aggregated) reporting and planning.

(6) Further Improvments

We have improved the loading process of the “Your active collections” page. This is done now workflow by workflow which is more interesting if you have more than one active workflow.

Also on the “Your active collections” page there was a miscalculation in “Finished” time on the workflow tile due to UTC conversion topic.

On the “Public Showcases” page there were some minor issues (also the space between the tiles were linked etc.).

In the frontend there was an issue with triggering changes in the visibility settings (with formulas) after changing a dropdown.

In the frontend we have improved the performance of ExceptionType0 definitions (which was slow with 100 or more rows).

In the frontend the comments (“red cell corners”) were not shown correctly under some circumstances.

In the mobile frontend view the dimension tree was not refreshed when switching the sheet of the workbook.

In the Admin Center we have improved the upload of the RLS definitions and we have removed the “Update” mode for the RLS table and all other UID-based tables (since an update is not possible in those cases).

In the Admin Center the “View” button in the Import/Upload screen did not show the records in some cases.

In the Admin Center there were some minor issues in the workflow editor.

We hope you like the new features – we are very curious about your feedback!

Please let us know what you think about data1.io and what kind of planning and data collection processes you evaluate to automate.

we #StandWithUkraine

We are happy to deliver the brandnew March 2026 Release with the new New Security Policies and New Workbook Folders! Try it now!

Remember, the Frontend is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Admin Center is the tool for the Power User to setup and control your organization’s collection workflows.

(1) Admin Center: New Password / 2FA Policy Settings

a. Personal Security Settings

You as a user now have the possibility to define your personal security settings. For this reason we have removed the “Forgot Password” link on the user profile page …

… since you`ll find the new ribbon Account Security with the button to Change password:

Just enter your old password and the define and acknowledge your new password:

Furthermore, you can activate 2-Factor-Authentication (2FA) for your account in order to increase dramatically the security level of your account:

You can use any Authenticator app (Microsoft, Google, etc.) – simply scan the QR code in your personal Authenticator app and verify it with the code from the app:

b. Tenant Security Policies – Definitions

We have even more than the increase of personal security settings. As a tenant admin now you can also define your tenant wide security policy!

You`ll find the new ribbon Authentication settings in your Organization settings:

First, define 2FA authentication to be obligatory in your tenant or optional:

Second, define the password policy for your tenant:

• Requirements for password length etc.
• Max Age for passwords (= in days)
• Password history count (= after how many pwd changes the same pwd can be used again)
• Max password changes per day

c. Tenant Security Policies – Users

Your (End & Power) Users are forced to fulfil the defined tenant wide security policy, e.g. change their password after the defined period of time:

Your individually defined password rules are – of course – shown also to your end users:

2-Factor-Authentication is forced if set to “Required“:

d) Tenant Security Policies – Multi-tenant scenarios

Please be aware, as a user you can be part of different workflows in several tenants. In this case, data1 determines your personal security rule which will fulfil all tenant policies you are involved in.

e) Tenant Security Policies – Recommendations

All existing tenants stay on their existing security level, no changes are done automatically. Therefore we recommend you as a tenant admin to check the policy settings in your tenant.

Please also be aware, that e.g. more stringent password rules will be in effect only after the next password change.If you want to have the rules in effect immediately, you must set the existing passwords to expire.

(2) Admin Center: New Workbook Folders

We saw that many of our users have not only 1 or 2 workbooks but a whole bunch of workbooks. With this release it is possible to organize your workbooks in folders!

Simply click on Add new folder …

… enter the name for the new folder …

… and allocate your workbooks by drag & drop:

Create another folder …

… and allocate the other workbooks:

Sure the folders can be expanded and collapsed:

(4) Admin Center: Improved Multi-Tenant Screens

We have worked on the multi-tenant functionality of the Admin Center.

(a) Improved Organization Screen

Until now, the Organization screen could only show the first tenant. With this release you`ll find a dropdown which enables you to select the tenant:

(b) Improved Multi-tenant presentation

Until now, the tables in the Tenant Settings were not sorted intuitively. With this release we have sorted all tenant related tables and furthermore we colored the tenant column in all screens light purple:

(5) Admin Center: E-Mail Adress in User Dropdown

For users who have several accounts it is useful to see the active account directly in the user menu:

(6) Frontend: Improvements for Dynamic List Queries

Dynamic List Queries were introduced with the July 2025 Release and are still a preview feature.

This month we have solved an issue with long running dynamic list queries due to problems with the re-allocation of named ranges. Furthermore dynamic list queries are now also executed in the Workbook preview mode.

(7) Further Improvements

We have dramatically improved the load performance of the dimension tree table in the Admin Center.

Furthermore the load performance of the Landingpages for “Your active Collections” and the “Public Showcases” is much better now.

We have removed an error when creating a new application.

Until now, in all download dropdowns of the Admin Center the xlsx option was not shown although it is the default download option. To make this clear, we have added the xlsx option to the dropdown.

There were a few issues due to the .NET migration last month (user login, date values in the dimension tree, validation during upload, fact records which could not be edited, workflow e-mails could not be sent).

We hope you like the new features – we are very curious about your feedback!

Please let us know what you think about data1.io and what kind of planning and data collection processes you evaluate to automate.

we #StandWithUkraine

We are back with the brandnew January 2026 Release with the new Import/Upload area and the new Admin Center navigation! Try it now!

Remember, the Frontend is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Admin Center is the tool for the Power User to setup and control your organization’s collection workflows.

(1) Admin Center: New area “Import / Upload your data”

Until now, actuals and other reference data had to be uploaded directly into the fact table. Now you can use additionally the new menu item “Import / Upload” which was designed especially for importing / uploading actuals.

Please be aware that this new screen shows only new uploads either here or in the fact table – formerly imported / uploaded actuals cannot be shown here. You can download and delete your existing actuals from the fact table and upload it once in this new area.

a. New menu item “Import / Upload”

In the main menu you`ll find now the new entry “Prepare your Data” with the new “Import / Upload” area:

Pressing the “Upload” Button will open the already from the fact table known dialog with the selection Replace or Append mode:

The uploaded data are not shown in detail but as aggregated “upload records“:

b. View and Delete Records

The detailled records behind an “upload record” can be analyzed with the “View” button:

We guess that the new “Delete” button can be very useful for many of you since you can delete accurate all the records from one upload batch:

c. New Replace Mode

Please be aware that we have changed the Replace mode. Until now, this replace mode referred to the field “SYS_Delta”. This was in many cases not useful – therefore we have changed the criteria for the replacement to the name of the uploaded file:

Before you execute the import with the replacement you`ll get an preview where you can check if this is plausible:

d. New column in Fact Table

We have added a new column “Is From Upload” to the Fact Table. With this column you can filter exactly the records that you see in the new screen “Import / Upload” …

… and also vice versa the records which were written back from the frontend:

(2) Admin Center: Adopted main menu structure

We have changed the main menu structure …

… by adding the new item “Prepare your data” and the new combined item “Run your Workflow(s)”

(3) Admin Center: New horicontal navigation

We have redesigned the horicontal navigation in the Admin Center with a second level.

a. New horicontal navigation

We have changed the layout and usability of the horicontal navigation …

… and we have added an optional second level to the horicontal navigation:

c. Adopted “Run your Workflow(s)” menu

This is the new menu structure in the new combined “Run your Workflow(s)” main item:

You can compare it with the old navigation structure:

b. Adopted “Use your collected Data” menu

We have moved the item “Copy Data” to the new main item “Prepare your data”.

(4) Discontinued Excel Add-In

In the January 2020 Release have launched the current Frontend which was called then “Web Client” and it took us only about 1 year to reach production readiness. Until then the “Excel Client” – which was an Javascript Add-In – was the major frontend for the collector users. We have stopped investements in this Excel Client years ago since we realized that we could not reach our strategic goals with this client.

In order to streamline the data1.io ecosystem, we retire now this Excel Add-In and removed it from the Office Store:

Just for nostalgic reasons let me show some last screenshots from the login screen …

… and from the dimension tree:

(5) Further Improvements

There was an issue with the logging of capacity changes if the change took longer than 12.5 minutes.

There was an issue with the Finish Workflow button if the collector organizer is not part of the “Define your users” table.

We hope you like the new features – we are very curious about your feedback!

Please let us know what you think about data1.io and what kind of planning and data collection processes you evaluate to automate.

we #StandWithUkraine

We are happy to deliver the brandnew October 2025 Release with the new Writeback for Dimensions and many other Features! Try it now!

Remember, the Frontend is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Admin Center is the tool for the Power User to setup and control your organization’s collection workflows.

(1) Frontend: Writeback for Dimensions (Preview)

Until now, Writeback from the Frontend was only possible into the fact table. With this release, it is also possible to edit data from the dimension tables directly in the frontend by your end users!

(a) Fields of application

Think of a data entry sheet which gives your users not only the possibilty to enter weekly data but also to edit the attributes for the dimension tree elements – in our case the columns “Type” and “Budget (h)”. With this release, changes in dimension attributes can also be written back to the dimension table:

As a result, the records in the dimension table are updated directly from the frontend:

(b) How it works

Writeback into dimensions is possible via list queries. That means, the editable field(s) must be attributes in a list query. In our showcase we have two columns which are filled by list queries:

• data1_LISTQUERY01_T_DIM001_A011 = Column “Type”
• data1_LISTQUERY01_T_DIM001_N001 = Column “Budget (h)”

Then, you need to define the new parameter “AllowEdit” in order to activate Writeback for a certain list query in your sheet:

• data1_LISTQUERY01_T_DIM001_CmdAllowEdit
  0 = default
  1 = Writeback is active

Last but not least it is a prerequisite for every editable list query to deliver the key column:

• data1_LISTQUERY01_T_DIM001_KEY

This is necessary since the update of the attributes is done via the keys in the key column.

Please note, that every attribute from every dimension table can be edited – but not the keys.

(2) Frontend: Streamlined READ algorithm for Comments

The allocation of comments and other fact attributes to records in the fact table on WRITEBACK are nothing new in data1.io. But there were some blurrings between the two modes – the Plus mode (+) and the Star mode (*) – when READING the comments back into the workbook. Those blurrings sometimes led to desired results although the definitions were not correct and in other cases it simply did not work as expected. With this release we have streamlined the READ algorithms for the two modes so that they both now work as they should.

(a) Plus Mode (+)

Plus mode is the default mode and means that the comments are strictly written on “comment records” of their own using exactly the dimension keys from the workbook. And this is true now also for the READ process – data1.io will show only the comment which exactly matches the dimension keys that are defined in the workbook.

You will use the Plus mode when you have more than 1 comment per row:

And the READ mode will use exactly the dimension keys from the workbook:

(b) Star Mode (*)

Star Mode means that a comment basically is NOT written on a record of its own but will be added to already existing “measure records” of the same row (or column) in the workbook. Therefore the dimension keys defined are only directly relevant for comments in a row without any values in the other cells of the row.

You will use the star mode if you have only 1 comment per row and when you want to save the comment on every “measure record” of this row.

The READ process works the same way: if there is any “measure record” in this row available then the comment is taken from the first record found. If none is found then a “comment record” with exactly the dimension keys from the workbook definition is searched for. This algorithm is used from now on only for Star definitions (*) and no more for Plus definitions (+).

Please check your workbooks if all comments and all other fact attributes (text, dates, numbers) are allocated in your workbook as expected.

(3) Frontend: Multiple Tree Selection for Advanced Scenarios

We have intdroduced the Multiple Tree Selection in September 2025 Release. With this release we have made this feature ready for advanced scenarios with sum-level trees (which were also introduced in September 2025 Release).

• Improvement for Alternative Level Queries
• Improvement for Write button activation / deactivation
• Improvement for visible / invisible rows refresh

Therefore the multiple tree selection can now be used in every scenario.

(4) Admin Center: Consistent Workflow Times

There were inconsistencies with the display of workflow times throughout the data1.io application. With this release, workflow times are consistently the same in Workflow e-Mails …

… on the workflow landing page …

… and in the workflow box of the frontend:

(5) Discontinued Showcases

We have decided to remove two of our Public Showcases since they did not meet our current technical demands:

• Financial Forecast
• Weekly Cash Planning

The remaining 6 showcases are up to date and highly relevant for the demonstration of the feature set of data1.io.

We hope you like the new features – we are very curious about your feedback!

Please let us know what you think about data1.io and what kind of planning and data collection processes you evaluate to automate.

we #StandWithUkraine

We are happy to deliver the brandnew July 2025 Release with the new New Dynamic List Queries and many other Features! Try it now!

Remember, the Frontend is the user friendly spreadsheet for your Collector Users to deliver their monthly/weekly/daily data. The Admin Center is the tool for the Power User to setup and control your organization’s collection workflows.

(1) Frontend: New Dynamic List Queries (Preview)

List Queries have become a powerful feature and are essential for many advanced applications in data1.io. Until now it was necessary to define a maximum number of rows or columns which could be filled by the list query and then fade out the rows / columns not used.

We are very happy to present the new dynamic List Queries which generate automatically the needed number of rows or columns. Have a look on this top level query – there are no additional (hidden) rows:

But have a look on this team level query – there are also no additional (hidden) rows:

For a dynamic List Query only one row (or column) is defined which will be duplicated as often as there are hits in the list query. You need two additional parameters for the list query to make it dynamic:

• data1_LISTQUERYxx_T_DIMxxx_CmdDynamic
  1 = dynamic list query
  The named range for the List Query is dynamically reduced or expanded by rows or columns. The first row or column is copied (copy/paste) to the new row(s)/column(s) so that the formulas and conditional formatting are retained and automatically adjusted to the new row/column (behaviour as in MS Excel).
  0 = static list query = default
  The name range is filled to the stop, rows/columns beyond this are not created.
  
• data1_LISTQUERYxx_T_DIMxxx_CmdExpansion
  row = new data is added row by row = default
  column = new data is added column by column

Dynamic List Queries are a complex feature with many interactions with other features:

• Clean removal of the existing rows from the last list query
• Clean format for the generated rows/columns and clean application of the changed cell format
• Sheet Protection
• Row Level Security (RLS)

This complexity is the reason why dynamic List Queries are currently in preview.

(2) Frontend: Writeback Optimiziation for List Queries

We have introduced the writeback functionality for List Queries in March 2025 Release. We`ve learned that the writeback in large lists was very slow since for every entry in the SysDelta parameter a separate SQL statement was sent in order to replace the already existing records for this batch.

With this release, the deletion of the existing records is executed with only one single SQL statement …

… which makes the writeback process performant:

(3) Frontend: Dimension Tree Sorting

The order of the sum level nodes in the dimension tree is determined …

… by the assigned elements with the lowest SORT information:

Until now, this algorithm used only the visible elements of a (filtered) dimension tree. Therefore the following constellation …

… led to a dimension tree with reversed order of the the two companies on Level 2. With this release we have changed this algorithm and the order of the sum level nodes results from all existing elements – visible or not:

This is a major change, since the dimension tree in an application has now always exactly the same order in all filtered variations of the tree.

(4) Admin Center: Dependent Filters in Tables

We have introduced the new column filter experience in November 2024 release. With this release we are happy to introduce dependent filters. That means that existing filters on one column …

… reduce the number of hits in all other column filters:

(5) Admin Center: RLS Improvements

We have learned that the RLS definition can be difficult due to the default column names in the RLS dialog. With this release we have added the individual column names to the dialog which will make it easier to see which attributes e.g. belong to the same hierarchy:

(6) Admin Center: Copy Data Improvements

We are happy that it is now possible to change the sort order of the filters in the “Filter condition(s)” block as well as in the “Target rule(s)” block:

Furthermore, we have also optimized the column order in the “Filter Condition(s)” block:

Last but not least, we have added the date to the timestamp in the execution bar.

(7) Further Improvements

We have solved an timing issue with the “Read Validation” (which was initially released in February 2025 release). In rare cases the validation message was shown altough there was no issue since the validation message was shown earlier than the READ process for the sheet was finished.

There was an issue in the Copy Data feature. The number of records shown which will be replaced (as preview before you start the copy data job) was not correct in some cases.

We have found a solution for the limitation for the execution of SQL statements with more than 2100 parameters – SQL statements are now executed piece by piece with 2000 parameters maximum.

We have also solved issues in the Admin Center in the Collector Users and in the RLS definition screens.

We hope you like the new features – we are very curious about your feedback!

Please let us know what you think about data1.io and what kind of planning and data collection processes you evaluate to automate.

We`ll be back after the summer break with the September Release!

we #StandWithUkraine