Working with Tables

Everything you need to know about working with the data tables found throughout Texada Web and Texada GateWay.

Ticket List - Table Only

The Ticket List table in Texada Web.

Quick Reference

  • Tables are commonly found throughout Texada Web and Texada GateWay. While no two tables are exactly alike, many of them share features in common.
  • Tips for adjusting a table’s appearance:
    • To change the sorting of a table, click on the header of the column you want to sort by.
    • To resize a column, click and drag the thin vertical lines between the column headers.
    • To change the order of the columns, click and drag the column headers.
  • Tips for accessing additional options:
    • To access more options for a column, click on the hamburger icon (Hamburger Menu) next to that column’s name.
    • To access more options for a row, click on the three dots (Vertical Dots) at the left side of that row, or click or double-click that row (only available for some tables).
  • Other useful features:
    • Use the ‘Columns’ button on the right side of a table to view a list of columns, and select which columns to display or hide.
    • Use the ‘Filters’ button on the right side of a table to filter a table’s rows.

Introduction

Tables are a common feature of pages throughout Texada Web and Texada GateWay. They provide a clear and concise way to display large quantities of data at once, and offer several options to make searching, sorting, and viewing this data easier. 

While no two tables are exactly alike, many of them share features in common. The following article will cover a number of techniques applicable to most tables in GateWay and Web.

The Elements of a Table

Below are two examples of tables found in Texada’s products: the Open Rentals table in Texada GateWay (above), and the Work Order list in Texada Web (below).

  1. Column Headers
    You can adjust columns in various ways by using their headers:
    • Click on a column’s header to change the sorting of that column. The three sorting options are ascending (up arrow), descending (down arrow), and none (no arrow).
    • Click and drag the thin vertical lines between the columns to adjust their width.
    • Click and drag a column’s header to rearrange the order of the columns.
  2. Column Options Menu
    Click the hamburger icon (Hamburger Menu) next to a column’s name to open its options menu. See ‘Column Options’ for more details. Note that, depending on the table, you may need to hover your mouse over the column header to see the hamburger icon.
  3. Row Options Menu
    Some tables, such as the Open Orders table above, feature an additional options menu at the left side of each row. Click the three dots (Three Dots) to view this menu. Some tables will instead feature checkboxes for selecting rows, or a draggable area indicated by six dots (Six Dots).
  4. Row Body
    Each of the entries in a table are displayed in their own row. Depending on the table in question, clicking or double-clicking a row may open additional options.
  5. Columns Button
    Use this button to quickly see a list of all the columns available for a table, and select which columns to display. See ‘The Column Manager’ for more details.
  6. Filter Button
    Use this button to see a list of columns and apply filters to them. See ‘The Filter Menu’ for more details.
  7. Page Navigator
    Tables with a large number of rows may be split into several pages; use this tool to move between them. Click ‘Prev’ or ‘Next’ to see the previous or following page, or click a page number to jump directly to that page.
  8. Results per Page Drop-Down
    Use this drop-down to adjust how many rows are displayed on a single page. Up to 100 rows can be displayed at once. If your table contains more than 100 rows and you wish to see them all at once, you can use the Export button to download the table and view it in an external program, such as Microsoft Excel.

Column Options

Click on the hamburger icon (Hamburger Menu) next to a column’s name to access its options menu. This will provide a number of additional options for displaying and filtering data. Depending on the table, this menu can have up to three tabs: the options tab, the filter tab, and the columns tab.

Options Tab

Column Options - Options Tab
  • Pin Column: Use this option to pin the column to the left or right side of the table, ensuring the column will remain visible as you navigate the table.
  • Autosize This Column: Adjusts the column’s width to snugly fit all of its data.
  • Autosize All Columns: Autosizes all columns simultaneously.
  • Reset Columns: Resets all columns’ widths and sort type. Note that this will not reset any filters you have applied.

Filter Tab

                          Column Options - Filter Tab          Column Options - Filter Tab 2 

This tab allows you to filter table rows based on specific criteria. Note that the appearance of this tab will change depending on the column selected; some columns will offer a choice of pre-existing options, while others will allow you to filter by text.

Columns Tab

Column Options - Column List Tab

This tab offers the same functionality as the ‘Columns’ button found on the right side of the table. This functionality will be the same regardless of the column selected. 

  • To show or hide a column, click the checkbox next to its name.
  • To show or hide all columns, click the checkbox next to the search bar.
  • To search for a particular column, begin typing its name into the search bar.

The Filter Menu

Filter Menu

The filter menu allows you to quickly view and apply filters across all columns. To open the filter menu, click on the ‘Filters’ button found on the right side of the table.

  • Click on a column to view and modify its filters. Columns that are currently being filtered will have a filter icon (Filter Icon) next to their name.
  • To search for a column, start typing its name into the search bar.

The Column Manager

Column Manager

The column manager allows you to view a list of all columns available for a table, and select which ones to display or hide. To open the column manager, click the ‘Columns’ button found on the right side of the table.

  • To show or hide a column, click the checkbox next to its name.
  • To show or hide all columns, click the checkbox next to the search bar.
  • To search for a column, start typing its name into the search bar.

Related Articles