Tables is presented in a familiar spreadsheet view, allowing you to easily browse and edit your data. In this article, you'll learn about the views and tools you can use to quickly access the information that's relevant to you.
Overview
Tables groups your people data into five default Tables:
People - comprising 3 views
Active employees
New hires
Offboarded employees
Time away - Comprising 2 views
Time away adjustments
Time away entries
Equipment - Showing all Equipment entries for active and offboarded employees
Compensations - Showing all Compensation entries for active and offboarded employees
Job roles - Showing all Role entries for active and offboarded employees
You can switch between these Tables in the left hand side of the Tables dashboard.
โ
At the top of the Tables dashboard, you can access the Search, Columns, Sort and Filter tools.
Searching Tables
You can find people, roles, functions and any relevant data set with Search. Results will show up highlighted in green.
Selecting Columns
With Columns, you can add and remove relevant data columns from your view. You can enable or disable either individual columns by clicking the checkbox, or whole sections by clicking on the section title (Employment, Offboarding etc...).
Sorting
With Sort, you can organise the table by any available column (eg. A-Z, Oldest to Newest, Smallest to Largest).
Filtering
With Filter, you can pinpoint data from all columns by choosing the values you wish to see within that column.
All the selected filters and sorting parameters you have chosen display in the top left-hand corner of the Tables dashboard. You can edit or remove individual filters by clicking on them, or remove them all by clicking Clear filters.