Table#
Tables can be used for both displaying and editing data.
Table data#
Array of objects to be displayed on the table. It is commonly used to display data from query * {{queries.restapi1.data}}
). Data expects an array of objects, example: {{[{ id: 1, name: 'Sarah', email: 'sarah@example.com'}]}}
Columns#
Cell data types#
- String ( Default )
- Text
- Badge - can be used to display and edit predefined badges such as status of shipment.
- Multiple badges
- Tags - similar to badges but the values are not predefined.
- Dropdown
- Radio
- Multiselect dropdown
- Toggle switch
- Date picker
Displaying Data#
The data object should be an array of objects. Table columns can be added, removed, rearranged from the inspector. key
property is the accessor key used to get data from a single element of a table data object. For example:
If the table data is:
1 2 3 4 5 6 7 8 9 10 11 |
|
To display email column, the key for the column should be user.email
.
Saving data#
Enable editable
property of a column to make the cells editable. If a data type is not selected, string
is selected as the data type.
If the data in a cell is changed, changeSet
property of the table object will have the index of the row and the field that changed.
For example, if the name field of second row of example in the 'Displaying Data' section is changed, changeSet
will look like this:
1 2 3 4 5 |
|
Along with changeSet
, dataUpdates
property will also be changed when the value of a cell changes. dataUpdates
will have the whole data of the changed index from the table data. dataUpdates
will look like this for our example:
1 2 3 4 5 6 7 8 9 |
|
If the data of a cell is changed, "save changes" button will be shown at the bottom of the table. This button when clicked will trigger the Bulk update query
event. This event can be used to run a query to update the data on your data source.
Action buttons#
Action buttons will be displayed as the last column of the table. The styles of these buttons can be customised and on click
actions can be configured. when clicked, selectedRow
property of the table will have the table data of the row.
Property | Description |
---|---|
Background color (Action Button) | Background color of the action button. |
Text color (Action Button) | Color of button-text of the action button. |
Options#
:::info
Any property having Fx
button next to its field can be programmatically configured.
:::
Server-side pagination#
Server-side pagination can be used to run a query whenever the page is changed. Go to events section of the inspector and change the action for on page changed
event. Number of records per page needs to be handled in your query. If server-side pagination is enabled, pageIndex
property will be exposed on the table object, this property will have the current page index. pageIndex
can be used to query the next set of results when page is changed.
Server-side search#
If server-side search is enabled, on search
event is fired after the content of searchText
property is changed. searchText
can be used to run a specific query to search for the records in your data source.
Show download button#
Show or hide download button at the Table footer.
Show filter button#
Show or hide filter button at the Table footer.
Show bulk update actions#
It's enabled by default. Toggle off
hide bulk update actions.
Bulk selection#
To let the user select one or more rows from the current page of a table, enable 'Bulk selection' from the inspector. The values of selected rows will be exposed as selectedRows
.
Highlight selected row#
Activate this option on the inspector to have the last selected(clicked on) row to be highlighted.
Show search box#
It can be used to show or hide Table Search box. Client-side search is enabled by default and server-side search can be enabled from the events section of the inspector. Whenever the search text is changed, the searchText
property of the table component is updated. If server-side search is enabled, on search
event is fired after the content of searchText
property is changed. searchText
can be used to run a specific query to search for the records in your data source.
If you don't wish to use the search feature altogether, you can disable it from the inspector.
Loading state (Boolean)#
Loading state shows a loading skeleton for the table. This property can be used to show a loading status on the table while data is being loaded. isLoading
property of a query can be used to get the status of a query.
Client-side pagination#
Client-side pagination is enabled by default. When the client-side pagination is enabled({{true}}
) the number of records per page is 10 and if it is disabled({{false}}
) then it will show all the records in the single page.
Event#
On row clicked#
This event is triggered when a table row is clicked. selectedRow
property of the table object will have the table data of the selected row.
Bulk update#
If any cell of the table is edited, the save changes
button appears at the footer of the table. Bulk update event is triggered when this button is clicked.
Page changed#
If server-side pagination is enabled, this event is fired when the current page is changed. This event is triggered after updating the pageIndex
variable.
Search#
This event is triggered when a text is entered to the search field of the table. searchText
variable is updated before triggering this event.
Exposed variables#
variable | description |
---|---|
currentData | Data that is currently being displayed by the table ( including edits if any ) |
currentPageData | Data that is displayed on the current page if pagination is enabled ( including edits if any ) |
pageIndex | Index of the current page, starting from 1 |
changeSet | Object with row number as the key and object of edited fields and their values as the value |
dataUpdates | Just like changeSet but includes the data of the entire row |
selectedRow | The data of the row that was last clicked. selectedRow also changes when an action button is clicked |
searchText | The value of the search field if server-side pagination is enabled |
Styles#
Style | Description |
---|---|
Text color | Change the color of the text in table by providing hex color code or choosing one from the picker |
Action button radius | This field can be used to give a radius to all action buttons. The default value is 0 |
Table type | Select a type of table from the dropdown. |
Cell size | This decides the size of table cells. You can choose between a Compact size for table cells or a Spacious size |
Visibility | Toggle on or off to control the visibility of the widget. You can programmatically change its value by clicking on the Fx button next to it. If {{false}} the widget will not visible after the app is deployed. By default, it's set to {{true}} . |
Disable | Toggle on to lock the widget. You can programmatically change its value by clicking on the Fx button next to it, if set to {{true}} , the widget will be locked and becomes non-functional. By default, its value is set to {{false}} . |
Border radius | Use this property to modify the border radius of the button. |
:::info
Any property having Fx
button next to its field can be programmatically configured.
:::