Data Sheet Enhancements

This page lists all the enhancements that have been released for the Data Sheet. Use the walk-throughs below to understand what changed and how to use each enhancement.

Summary of enhancements

  • Add Row (+) — Add a new row in the Data Sheet.

  • Ability to Freeze Columns — Enable Frozen Column from the Properties tab provided for the Dataset.

  • Edit the Frozen Column — Frozen columns are non-editable in Preview mode; however, cells under a frozen column in a newly added row are editable.

  • Pagination Property — Enable Pagination within General Properties to show page numbers on the Data Sheet component.

  • Delete Row — Use Delete Selected Row with a confirmation message (available in Preview mode).

  • Save Option Update — The Save option turns red when something is edited in the datasheet.

  • Library updates — Updated JExcel DataGrid and JSuites library to 4.6.1; able to retrieve more records of data.

Add Row (+)

What: Provided the Add Row (+) option to add a new row in the Data Sheet. How to use:

  1. Open the Data Sheet on the canvas or in Preview mode.

  2. Click Add Row (+).

  3. Enter values for the new row and Save.

Ability to Freeze Columns

What: The Freeze Column option can be enabled from the Properties tab provided for the Dataset. How to use:

  1. Open Dataset Properties for the Data Sheet.

  2. Select a column.

  3. Enable Frozen Column from the Properties tab of the Dataset.

Behavior:

  • The selected column gets frozen and becomes non-editable in Preview mode.

  • Exception: If you add a new Row, the cell added under the frozen column is editable (for that new row).

Pagination Property

What: Provided Pagination within the General Properties option. How to use:

  1. Open General Properties of the Data Sheet component.

  2. Enable Pagination.

  3. The page number displays on the Data Sheet component.

Delete Row

What: Introduced Delete Selected Row with a confirmation message before a row gets deleted in Preview mode. How to use:

  1. In Preview mode, select the target row.

  2. Click Delete Selected Row.

  3. Confirm deletion in the pop-up.

Save Option Update

What: The Save option gets updated in red color when something is edited in the datasheet. Why it helps: Visually indicates there are unsaved changes.

Notes:

  • Reload/Refresh:

    • Use Refresh Data Stores/Services as applicable to sync schema or service changes before editing the Data Sheet.

  • Libraries:

    • JExcel DataGrid and JSuites library updated to 4.6.1 (latest stable at time of release).

    • Enhancement allows for the retrieval of more records of data.

Tips & edge cases

  • Frozen Column editing rule: Expect read-only behavior in Preview for frozen columns, except cells of newly added rows, which remain editable under the frozen column.

  • Pagination + large data: Enable Pagination when working with big Data Sheets to improve usability and navigation.

  • Track unsaved edits: If the Save button is red, review your recent changes and Save to persist.

  • Before deleting: Consider exporting or duplicating the Data Sheet if you need an audit trail outside the platform.

PreviousData Sheet ConnectionNextWebSocket Connection