By the end of this exercise you will be able to:

• Understand the components of a

• view
• Create a grid view

Finding

Tables and

Table Data

1. Click Analysis in the header to show the list of

1. Analysis Models.
2. Find and open the

1. model Screens and Forms 01-08: Views, filters and

1. screens.
2. In the model

1. place your

1. mouse over the

1. table Overall Debt Levels.
2. A hover menu will appear

1. , press 

   Insert excerpt
   _view_show _view_show nopanel true

    and select Default View.
2. The data contained in the

1. table will appear.

Create New

View

You will create a new grid view to show the data in the

table in a table format

:

1. Create Screen:
   
   1. Click on Screen on the Header bar.
   2. Click 

      Insert excerpt
      _add _add nopanel true

      .
   3. Set the screen name to Overall Debt Levels.

1. 1. Select a Template e.g. Tile No Buttons.
   2. Click the Create Screen button.
   3. A new

1. 1. screen will appear.
2. Now create a new view on the

1. screen:
   1. Use the

1. 1. tabs to navigate back to the analysis model

1. 1. Screens and Forms 01-08: Views, filters and

1. 1. screens.
   2. Double click on the

1. 1. table Overall debt levels

1. 1. .

   2. Insert excerpt
      _pin _pin nopanel true

       this table's settings tab.
   3. Using the tabs, select the

1. 1. screen you just created (Overall Debt Levels) to bring this back to the front.
   2. Drag the

1. 1. table icon 

      Insert excerpt
      _tables _tables nopanel true

       from the top of the table settings (see below) onto the screen.
      1. Image Added
   2. A popup box will ask you how you would like to display the attributes - choose 

      Insert excerpt
      _grid _grid nopanel true

      .
   3. This creates a view on the screen, and the properties opens on the right.
   4. An Available Attributes box will appear - drag the attributes you want (in this case, all of them) from the list onto the

1. 1. view.
   2. Close the Available Attributes box.

You can also see your new view in the list of views for the

table:

1. Hover over the

1. table Overall Debt Levels in the Screens and Forms 01-08: Views, filters and screens model.
2. From the hover menu press 

1. Insert excerpt
   _view_show _view_show nopanel true

    and select Overall Debt Levels.
   

Editing a

View

1. Click on the tab for the screen Overall Debt Levels.
2. Right click on the

1. grid in the

1. screen, select 

   Insert excerpt
   _view_show _view_show nopanel true

    configuration
2. You can edit details of the view in the

1. settings on the right, but there are a number of

1. changes you can make directly to the view in the

1. screen:

Re-order

Columns

To re-order columns:

1. Grab a column heading
2. Drag it, drop it in a new position.

Freeze

Rows

You can freeze a number of columns.

First prepare some data:

1. Open the analysis model

1. Screens and Forms 11-13. Actions to update, insert, delete.
2. Run analysis on the

1. table Wisteria Books Inventory - this will load data into the

1. table.
2. Create a new view:
   1. Create a new

1. 1. screen: Wisteria Books Inventory
   2. Template: Blank
   3. Drag the

1. 1. table Wisteria Books Inventory onto the

1. 1. screen
   2. Select Grid view
   3. Add all of the attributes
2. Widen the columns so that you can see all (or most) of the text in each column - eventually you will see a horizontal scroll bar appear at the bottom of the view.
3. Image Added

Freeze a column:

1. Freeze the second column (this should be Subject): right-click on the column heading and select Freeze column.
2. Slide the horizontal scroll bar - you will see the first 2 columns are frozen.

Set

Width

You can fix the width of a column. By default, columns are flex

, which means they will consume the available space. To fix a column width:

1. Grab the right hand edge of a column heading

1. and move it to set the width.
2. Click on 

   Insert excerpt
   _lock _lock nopanel true

    in the toolbar.
3. Maximise the view - you will see that the set column stays the same size, while the remaining columns flex

1. .
2. Right click on your screen and select 

   Insert excerpt
   _unlock _unlock nopanel true

    to continue editing your screen.

Set Flex

If you fix the width of a column, you can return it to being a flex column:

1. Right-click on a column heading.
2. Select Set flex column.

Column

Filtering

As well as building permanent filters (you will do this in the next exercise), column filters (sometimes called quick filters) are available to you and the users you are creating this view for. To use a column filter:

1. Hover over a column heading

2. A 

   Insert excerpt
   _filter _filter nopanel true

   .
3. You can select operators and enter

1. values to filter on the values in that column.
2. You can add clauses to this filter.
3. You can additionally filter on other columns, and these filter will apply together to further filter the data.

Column

Sorting

As well as building permanent sort orders (you will do this in a future exercise), you can apply a column sort:

1. Right click on a column heading in the

1. table view
2. Select Sort Ascending or Sort Descending