Blink Tables allows for basic and advanced view changes, to allow filtering, sorting, ordering and browsing the 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 Table Filter applies conditions to individual fields, allowing you to refine your data based on specific criteria. It consists of three key components:
The table filter is applied to each field individually and works as follows:
Select the Field to Filter
Choose the Field Name from the dropdown menu. This determines which column in the table will be filtered.
Choose an Operator
Operators define how the filter applies to the selected field. Available operators vary based on the field type:
Is equal to
, Is not equal to
, Contains
, Does not contains
, Starts with
, Ends with
, Is empty
, Is not empty
).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
)Contains
, Does not contains
, Is empty
, Is not empty
)Is equal to
, Is not equal to
, Contains
, Does not contains
, Starts with
, Ends with
, Is empty
, Is not empty
)Is between
, Is before
, Is after
, Past
)True
, False
)Contains
, Does not contains
)Enter a Value for the Filter
You can reorder your table fields by dragging a selected field and dropping it into the new place.
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 icon to open a modal with the fields. Any fields that are selected will be presented:
Table pagination helps manage large datasets by controlling record display and enabling easy navigation. Below are details on setting record limits and moving 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.
When clicking on a single cell, a “Copy” icon will be presented. Click the copy icon to copy the cell value.
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’ refers to a saved configuration that combines specific filtering and sorting of your table data. These views can be set as either public (accessible to all users) or private (restricted to the user who created it).
Access Table View Options
In the dropdown menu in the top-left corner, you will find out of the box options for reviewing your Table Views.
Create a Custom Table View
You can create a custom table view by opening the dropdown menu in the top-left corner, selecting “Add View,” and entering a name for your view.
If you want the view to be private, check the corresponding box. This will ensure that only you can see and use the view, keeping it hidden from other users.
If left unchecked, the view will be public and accessible to all users with access to the table.
Customize the Table View
Next, click the to define a conditional statement to filter the data displayed in your custom table view.
You can further customize the view by:
Clicking the icon to select which columns to display.
Once you’ve configured the view to your preference, click “Save View” to apply the changes.
Manage or Delete a Custom 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.
Learn more about best practices for table and field naming conventions
Learn more about creating and using table actions in Workflows
Learn more about basic table operations
Learn More About Table Limitations