Tips for using Abtrac Tables (also known as Data Grids)

Most of the high use screens in Abtrac are data entry tables (data grids).

The support team are often asked simple questions about searching, filtering and getting things just right  – particularly when you are starting out using AbtracOnLine.

  • The way the grids and columns in each screen are displayed can be customised for all users by an administrator
  • All grids can be filtered and sorted as a one-off at any time
  • Some grids (like timesheets) can also be customised at a user level
  • Each Abtrac user can also choose how many rows they see  – for all the grids accessed under their login
  • Using Grid Layout anyone can save their own specific layouts (including filtering and grouping) on certain screens

In this article we’ve included some tricks to filtering and sorting, and a few handy ‘everyday use’ tips for using Abtrac Grids…

To customise your Abtrac grid layouts for all users.

An administrator can define the visibility, position and width of all available fields from Administration >> Settings >> User Control Settings.

2020-08-31_user control settings


How do I set the number of rows that are displayed for all tables?

From the home screen choose >> Edit My Settings.

2020-08-31_home edit my settings

Here you can specify the ‘page size’ – that is how many rows are displayed in all tables in Abtrac –  just for your login (choose between 10 – 50 rows).

2020-08-31_page size

2020-08-31_user specific settings


I always sort and filter this grid, on this page, this way. Why can’t Abtrac remember how I like it to look?

We’re currently working on two options to remember settings for individual users. If it’s not included in User Specific Settings, then the page layout you want to save will likely have a Grid Layout option (pictured below).

Just filter, group, and sort the grid as required and once you are done, choose the ‘Apply’ Grid Layout option.

2020-08-31_grid layout apply

Your current grid changes will be remembered for your particular Abtrac login, for every time you return to that particular page. In order to remove the saved layout choose the undo (‘Reset’ Grid Layout) button.


Tips for filtering, grouping and sorting Abtrac data.

Sorting

Click on a header to sort by a particular column. A black arrow will then display to indicate the sort order.

Click again to reverse the order (eg. A to Z, or Z to A).

2020-08-31_search clients and jobs

Moving Columns

To rearrange the order of columns, click and hold a header and drag it across to your preferred location.

2020-08-31_rearranging grid columns

Grouping data

If your grid has a grouping option (like the Email Management screen) you can drag column headers to group data together. Once grouped you can then choose to expand or hide results for individual groupings.

2020-09-01_email activity and grouping

Filtering Results and Searching

You can filter the results displayed by choosing a drop down option provided.

2020-09-01_search by job type

Or you can also specify a specific filter result by typing into the boxes provided.

2020-09-01_search by typing

Check and choose the search options

By clicking on the search icon you can further refine how the search or filter is run. ‘Contains’ is the most common search method but you can change these options for individual searches

2020-09-01_search result options


Why can’t I find my data in this grid? I know it exists in Abtrac.

Some of the grids in Abtrac have default filters enabled.

These are usually screens that can query a large amount of data – check the header rows to view and amend the defaults.

If you can’t find what you are looking for, then check the current or committed records filters first.

Search Clients and Projects  – you are initially restricted to Current Clients and Projects only.

2020-09-01_search criteria


Load Invoice
– only displays current, uncommitted invoices until you amend the filtering.

2020-09-01_load invoice

Abtrac KB# 2064