Layout & User Interface

Let us now explore the PowerTable interface. It has the following sections:

Menu bar

PowerTable contains the Home and the Setup menus.

On the right, there are additional tabs for managing column width, approvals, comments, and saving changes.

Toolbar

The toolbar displays relevant features and settings based on the selected menu.

• The Home tab includes the following options: row import, row insertion, appearance and display settings (such as row height, word wrap, and header fit), conditional formatting, sort, search, and filter options, find and replace, audit, and undo/redo operations.

When you select a row or a column, the toolbar displays basic and advanced formatting and editing options, as shown below:

• The Setup tab enables you to configure column properties, manage row and column access control, create automation workflows, and view and manage table settings.

Table

This section displays your source table, as well as the results of any editing, sorting, filtering, formatting, commenting, or other actions you perform on it. Here is where you will interact with the data and configure other functionalities that you choose.

Status bar

The status bar displays source and table information, settings, and pagination controls.

On the left, the total number of rows, columns, the source and table details are displayed.

• Rows: The total number of rows in the source table is shown here.

• Columns: The total number of columns in the source table is shown here.

• Source: The database connection name and the table name are displayed here. Hovering over it displays the complete source details.

• Sync (Data Refresh): Click on this option to sync your table data with the source data. This is similar to a source data refresh.

• Zoom-in and zoom-out controls: Users can click on the '+' and '-' icons to zoom in and out, respectively. Alternatively, the Ctrl + and Ctrl - shortcut keys can also be used.

On the right, you can view page display settings and pagination controls:

• Pagination controls: Use these controls to go to the first page, previous, next, and last page, and also navigate to a specific page by entering the page number.

• Settings: Here, you can choose whether you want the table to span multiple pages or have a scrollbar. It also allows you to change the number of rows displayed per page by selecting 'All', 'Auto', or a specific range from 10 to 75 rows.