With every release, the 4D View Pro features list is growing. And this feature release is no exception: 4D v20 comes with a new version of SpreadJS, the v16, and a Ribbon update that is compatible with it.
Let’s discover the new features offered by this new version.
TableSheet Enhancements
Tablesheet, a separate, high-performance DataTable, has received a couple more features:
Hierarchy in Data Manager
TableSheets now support hierarchy data in the source data. This includes four different types of data for records:
- Properties “id” and “parentId”
- Properties that indicate hierarchy level
- Properties that include hierarchical children
- A primary key that can be parsed to a hierarchy using a custom function
Hierarchy operations have been added as well, giving users the ability to:
- Promote/Demote records
- Move records up/down
- Insert records after/before or above/below
- Delete a record
- Expand/Collapse all record levels or specific levels
- Sort/filter records
TableSheet Hierarchy Data
Another enhancement to the TableSheet implementation in the Designer is the addition of support for hierarchical data in the Columns tab of the Data Source. Columns now have a separate “Hierarchy” section with things like Type, Summary Formula, and Outline Column that can be defined:
Data Manager Field Name Mapping
The data source schema for the Data Manager now supports setting an alias for columns, allowing for different names between the front-end and back-end of a data source. This can be done by simply setting the “Caption” property when adding a view to the Data Manager.
Need more information? Take a look at these SpreadJS v16 advances in detail. And share with us your experience on the 4D forum.