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.

Administration > User Control Settings - AbtracOnLine

Administration > User Control Settings – AbtracOnLine


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

From the home screen choose > 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).

AbtracOnLine - Grid Page Size

AbtracOnLine – Grid Page Size

AbtracOnLine-User specific settings

AbtracOnLine-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 Save Grid Layout option.

AbtracOnLine - Save Grid Layout

AbtracOnLine – Save Grid Layout

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).

Search results sort order – AbtracOnLine

Search results sort order – AbtracOnLine

 

Moving Columns

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

AbtracOnLine - Rearranging Grid Columns

AbtracOnLine – 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.

AbtracOnLine - Email Activity Grouping

AbtracOnLine – Email Activity Grouping

 

Filtering Results and Searching

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

Filter search – AbtracOnLine

Filter search – AbtracOnLine

 

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

Search options – AbtracOnLine

Search options – AbtracOnLine

 

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

Search results options – AbtracOnLine

Search results options – AbtracOnLine


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 the check the current or committed records filters first.

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

AbtracOnLine - Search Criteria

AbtracOnLine – Search Criteria

 

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

AbtracOnLine - Load Invoice Current Batch

AbtracOnLine – Load Invoice Current Batch

Abtrac KB# 2064