4D View Pro: What’s New in 4D v20

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.

Fabrice Mainguené
• Product Owner •Fabrice Mainguené joined 4D Program team in November, 2016. As a Product Owner, he is in charge of writing the user stories then translating it to functional specifications. His role is also to make sure that the feature implementation delivered is meeting the customer need.After obtaining a Bachelor degree in Computer Science at CNAM, Fabrice joined a small software publishing company as a Windev developer. Then he worked for different companies in industry and trade areas as a Windev and web developer as well as technical advisor on new features.