Table Features
There are several table features that can be used to better view, collaborate and analyze the data in Cinchy tables.
Table of Contents |
|---|
When you first create a table, a default view called All Data will be created for you under Manage Data. Cinchy builders can create different views for users to manage their data in Cinchy where Views can be filtered and/or sorted according to the requirements.
To switch between views simply select the view from the left navigation toolbar under Manage Data (Image 1).
Image 1: Using Views
Users can filter data in a view for one or more columns. Filters persist when users navigate from one view to another. The number of filter criteria is identified against the filter icon (Image 2).
Image 2: Filtering
Users can add, remove or rearrange the columns in a view based on how they need the data represented in the View (Image 3).
- 1.Click Display Columns in the top toolbar
- 2.From the ‘Add a Column’ drop down, locate and select the appropriate column.
- 3.Ensure you click ‘Apply’ to save.
- 1.Click Display Columns in the top toolbar
- 2.Click the “X” to the right of the column name to remove.
- 3.Ensure you click ‘Apply’ to save.
- 1.Click Display Columns in the top toolbar
- 2.Drag the column to the appropriate location in the list of visible columns.
- 3.Ensure you click ‘Apply’ to save.
Image 3: Display Columns
Display Columns do not persist. When you move away from the View, any modifications will be lost.
Users can sort data in a view for one or more columns. Sorting can be done by clicking on a column to sort in ascending or descending order (Image 4).
Image 4: Sorting via a table column
Sorting can also be done by clicking on the Sorting button and selecting the column(s) to be sorted and the order in which the sorting should occur (Image 5).
Image 5: Sorting via the Sort button
Sorting Columns do not persist, when you move away from the View any modifications will be lost.
Scrolling “Top” & “Bottom” allows you to jump from the top to the bottom of a view without scrolling (Image 6).
Image 6: Scrolling
Row height can be either Collapsed or Expanded using the Row Height drop-down (Image 7).
Image 7: Expanding/Collapsing the row height
In addition to the row height selection, you can also manually resize a row (or multiple rows if you select more of them). You can also double click on the default row number on the left to auto expand the row height.
Cinchy allows you to freeze and unfreeze a row/column similar to Excel.
- 1.Select the row/column for freezing/unfreezing
- 2.Right-click on the row and select Freeze/Unfreeze Row/Column from the menu (Image 8).
Image 8: Freezing a Row/Column
Last modified 10mo ago