Data sheet view

The data sheet view in data forms lets you visualize form data as a grid. The column headings represent the selected data form fields and system fields, whereas the rows display the values captured in each field.


Suppose you're adding rows or modifying data within rows that consist of form fields. In that case, sequence number fields generated using form data for that row will not be generated, and integrations and field validations will not be triggered.

Creating a data sheet view

  1. Sign into Kissflow > open your App > Application builder.
  2. Navigate to the data form tab > open a data form.
  3. Click Views > Create view.
  4. Click Data sheet.
  5. Enter a name for the data sheet > click Create.


Configuring the data sheet view

General settings

You can modify the name of the data sheet here.

Sheet settings

Click Add columns to create columns in the data sheet view. You can select columns from form fields or system fields. Click Select all to add all the fields as columns in the data sheet view.

Under Manage columns, you can drag-and-drop the fields to rearrange the order of the columns. You can also delete the columns if they are not required. Click Save to complete the configuration.

Data filter

You can use the data filter to determine how to show the data in the data sheet view. To do this, under Data filter > Advanced filters, you can apply conditions using operators and values. In an advanced filter, you can select a field, an operator such as Equal to, Not equal to, Part of, etc., specify if it is a value, field, or parameter, and match it with a  corresponding value. You can add additional conditions, such as AND/OR, to these filters.


Quick filter

A quick filter helps you view the filtered data in a separate tab. You can drag-and-drop the added filters to rearrange them You can also configure quick filters within a page where you use the data sheet view. The filter can be turned on/off inside the page.

Sorting data

You can sort the data inside the data sheet view in ascending or descending order. You must first select a column to apply the sort feature. Once the sort button is used, you can click the Expand button on the column title to sort values from the data sheet view.

Adding the data sheet view component to a page

You can add a data sheet view component onto a page by simply dragging and dropping it to the page. Once you add it, you can configure the following options under the Settings menu:

  • Show form: You can turn on the show form button to allow users with Manage permission to view and edit the form during runtime.
  • Quick filter: You can enable or disable the quick filters set up for the data form on the page.
  • Export: You can turn on the export button to grant yourself the ability to export the data from the data sheet view as a downloadable CSV file.


Working with the data sheet view

During the runtime, users can add, modify, and delete data from the data sheet view. Users will also be able to add multiple rows using the Add button.


You can add up to 100,000 rows in a data sheet view.

You, as a user, have the ability to bulk copy and paste values into the data sheet view. Ensure the values in the data sheet view fields match the corresponding field type. 

Content aside

  • 7 mths agoLast active
  • 22Views