Cinchy Platform Documentation
Cinchy v4.0
Cinchy v4.0
  • Dataware Overview
  • Release Notes
    • 4.1 Release Notes
    • 4.2 Release Notes
    • 4.4 Release Notes
    • 4.5 Release Notes
    • 4.6 Release Notes
    • 4.7 Release Notes
    • 4.8 Release Notes
    • 4.10 Release Notes
    • 4.11 Release Notes
    • 4.12 Release Notes
    • 4.13 Release Notes
    • 4.14 Release Notes
    • 4.15 Release Notes
    • 4.16 Release Notes
    • 4.17 Release Notes
    • 4.18 Release Notes
    • 4.19 Release Notes
    • 4.20 Release Notes
    • 4.21 Release Notes
  • Cinchy Guides
    • User
      • My Network
      • User Preferences
      • Table Features
      • Data Management
      • Commentary
      • Query
    • Builder
      • Best Practices
        • Multi-Lingual Support
      • Tables
        • Creating your first table
        • System Columns
        • Column Types
        • Linking Data
        • Indexing and Partitioning
        • Formatting Rules
        • Data Controls (formerly Design Controls)
          • Table Level Entitlements
          • Column Level Entitlements
          • Row Level Entitlements
          • Erasure
          • Compression
      • Building Forms
      • Saved Queries
        • Creating your first query
        • Displaying Query Results
      • Integration
        • BI Integrations
          • Excel
          • Power BI
          • Tableau
        • Other Integrations
          • SAS
      • Data Experience Deployment
    • Frequently Asked Questions
  • API Guide
    • APIs
      • Authentication
      • Saved Queries
      • ExecuteCQL
      • Webhook Ingestion
  • Deployment Guide
    • Planning
      • Deployment Planning Guide
      • Pre-Requisites
    • Installation
      • Maintenance
      • Migration from 1.x
      • Single Sign-On (SSO) Integration
        • Configuring ADFS
        • AD Group Integration
        • High Number of Groups in ADFS
      • Application Experiences
        • Setting Up Experiences
        • My Data Network
        • Custom Data Network Visualizer
      • Advanced Settings
        • Enable Data At Rest Encryption
        • System Properties
  • Other Resources
    • Cinchy Data Sync
    • Cinchy Meta-Forms
    • Cinchy Meta Reports
    • Cinchy Query Language
    • Angular SDK
    • JavaScript SDK
Powered by GitBook
On this page
  • Views
  • Filters
  • Column Display
  • Sorting
  • Scrolling
  • Row Height
  • Freeze Unfreeze Rows
  • Freeze Unfreeze Columns

Was this helpful?

Export as PDF
  1. Cinchy Guides
  2. User

Table Features

PreviousUser PreferencesNextData Management

Last updated 4 years ago

Was this helpful?

There are several table features that can be used to better view, collaborate and analyze the data in Cinchy tables. This section will go over the following features:

Views

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.

Filters

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.

Column Display

Users can add, remove or rearrange the columns in a view based on how they need the data represented in the View.

To add a column to a View, complete the following:

  1. Click Display Columns in the top toolbar

  2. From the ‘Add a Column’ drop down, locate and select the appropriate column.

To remove a column from a View, complete the following:

  1. Click the “X” to the right of the column name to remove.

To rearrange the columns in a View, complete the following:

  1. Drag the column to the appropriate location in the list of visible columns.

Ensure you click ‘Apply’ to save the modified columns displayed.

Please note that Display Columns DO NOT persist. When you move away from the View, any modifications will be lost.

Sorting

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.

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.

Sorting Columns DO NOT persist, when you move away from the View any modifications will be lost.

Scrolling

Scrolling “Top” & “Bottom” allows you to jump from the top to the bottom of a view without scrolling.

Row Height

Row height can be either Collapsed or Expanded using the Row Height drop-down.

In addition to the row height selection, you can now 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.

Freeze Unfreeze Rows

Cinchy allows you to freeze and unfreeze a row similar to Excel.

To freeze or unfreeze a row, complete the following:

  1. Select the row for freezing/unfreezing

  2. Right-click on the row and select Freeze/Unfreeze Row from the menu

Freeze Unfreeze Columns

Cinchy allows you to freeze and unfreeze a column similar to Excel.

To freeze or unfreeze a column, complete the following:

  1. Select the column for freezing/unfreezing

  2. Right-click on the column and select Freeze/Unfreeze Column from the menu

Views
Filters
Column Display
Sorting
Scrolling
Row Height
Freeze Unfreeze Rows
Freeze Unfreeze Columns