Viewing Capabilities of Tables
Blink Tables allows for basic and advanced view changes, to allow filtering, sorting, ordering and browsing the table records.
Supported Viewing Capabilities Include:
- Sorting
- Filtering (including advanced filtering)
- Changing fields order
- Hiding/Exposing fields
- Pagination
- Copying a cell's value
- Changing the table field's width
- Table Views
Sorting Table Records
When you hover over a field header, the up and down arrow icons indicate the sorting option.
- The default sorting of the table is done according to the record creation time.
The first click will trigger a sort in descending order.
The second click will trigger a sort in the ascending order.
The third click will return the sorting to be as it was before the first click.
Filtering Table Records
Click the filter feature above the table to filter table records:
The table filter is applied to each field individually and works as follows:
Field Name - Select the field that you want to filter in the Table from the dropdown.
Operators:
- Text - (
Is equal to
,Is not equal to
,Contains
,Does not contains
,Starts with
,Ends with
,Is empty
,Is not empty
). - Number - (
Is equal to
,Is not equal to
,Is less than
,Is less than or equals to
,is greater than
,is greater than or equals to
,Is empty
,Is not empty
,Is between
) - Multi-select (
Contains
,Does not contains
,Is empty
,Is not empty
) - Single-select (
Is equal to
,Is not equal to
,Contains
,Does not contains
,Starts with
,Ends with
,Is empty
,Is not empty
) - Date / Date + Time (
Is between
,Is before
,Is after
,Past
) - Checkbox - (
True
,False
) - User - (
Contains
,Does not contains
)
- Text - (
Values:
- Text - Free text box
- Number - Free text to insert a number. When the operator is "Between”, you’ll see fields to specify the “from” and “to” of your range.
- Multi-select - Allow to select multiple options of the values in the records
- Single-select - Allow to select one option from the values in the records
- Date: Yesterday, today, last 7 days, last 30 days, last year, custom date - allow to select specific dates in additional text box
- Date & Time - like Date but with the option to set Time
Changing Fields Order
You can reorder your Table fields by dragging a selected field and dropping it into the new place.
Hiding/Exposing Fields
You can decide which fields to display in the table and which fields to hide.
The following table fields are System Fields: and will not be presented by default: Created At
, Created By
, ID
, Updated At
and Updated By
- Click on the “eye” icon to open a modal with the fields. Any fields that are selected will be presented:
Table Pagination
- Pagination
- Navigation between pages
The Table pagination settings are at the bottom of the Table, offering the following options: 10, 20, 50, 100 records. The default number of records is 10 and it can be modified by selecting another number from the drop down.
When the number of records exceeds the value of the selected records, it creates a new page.
The navigation between the Table’s pages can be done via the arrow at the bottom of the table.
Copying A Cell's Value
When clicking on a single cell, a “Copy” icon will be presented. Click the copy icon to copy the cell value.
Changing the Table Field's Width
You can change the width of a specific field by clicking on its border and dragging it to the specific width you want
Table Views
There is an option to manage table views by selecting or adding your own table management views.
In the dropdown menu in the top-left corner, you will find out of the box options for reviewing your Table Views.
You can also create your own table view by selecting the dropdown menu in the top-left corner, choosing the "Add View" option, and providing a name. If you want the table view to be private, check the corresponding box.
- If you check the box next to "Private," this view will be private to other users. Otherwise, it will be public to all users.
Proceed by creating a conditional statement you would like to apply to the table view you just created. You can also click on the eye icon to choose which columns you would like to display, drag columns to change their order in the table or sort the columns by hovering over the column header and clicking the up or down arrows. Then click "Save View."
You can also edit the Table View you created by clicking on the dropdown menu and selecting the "Manage View" option. To make any changes, click the "Manage View" button. If you want to delete the view you created, click the "X" button.