Anchor
_Toc402702617 _Toc402702617

Anchor
_Toc442889146 _Toc442889146

Changes row colour

• Open the model Dashboards and Forms 09, 10: Linked Views and presentation that you created in the previous exercise
• Open the configuration form for the view Book List on the Stream Book List
• In the list of Stream View Attributes double-click on Publisher
  • Tick the flag Changes Row Colour
  • Press 
• Press  in the main view configuration form to save your changes
• Open the view and sort by Publisher – simply click on the heading of the Publisher column
• You will now see that the colour of the rows changes when the Publisher changes

Anchor
_Toc402702618 _Toc402702618

Anchor
_Toc442889147 _Toc442889147

Grid column width

• Open the configuration form for the view Book List on the Stream Book List
  • Remember you can right-click on any data row and select Show View
• In the list of Stream View Attributes double-click on Publisher
  • Set the field Grid Default Width (pixels) to 150
  • Press 
• Similarly, set the grid width for Synopsis to 400
• Press  in the main view configuration form to save your changes
• Either open the view – or if you already have the view open, press Refresh
• You will now see the data displayed with the column widths you have set

Anchor
_Toc402702619 _Toc402702619

Anchor
_Toc442889148 _Toc442889148

Record detail field sizing

• Double-click on any row of data in the view Book List – a form with the details of the record will pop up
• Close this detail view
• Open the configuration form for the view
• In the list of Stream View Attributes double-click on Synopsis
  • Set Width On Form (pixels) to 300
  • Set Height On Form (pixels) to 200
  • Press 
  • Notice that when you update these values the Size On Form box changes to indicate the size that the field will now have on a form
• Press  in the main view configuration form to save your changes
• Double-click on any row of data in the view
• In the record details form you will see the Synopsis field resized to the new settings

Anchor
_Toc402702620 _Toc402702620

Anchor
_Toc442889149 _Toc442889149

Layout of record details form

• Open a record details form: double-click on any row of data in the view Book List
• Press - Modify the form layout
• Grab the corner of the form and expand it
• Grab one of the field names and drag the field to a new position on the form
• Update the name of the details form to Book Details
• Press - Save and lock the form layout
• This will update the layout of the details form for any record – open the details for another record by double-clicking it
• You will see the details form pop up with the new layout

Anchor
_Toc402702621 _Toc402702621

Anchor
_Toc442889150 _Toc442889150

Set field alias

• Open the configuration form for the view Book List on the Stream Book List
• In the list of Stream View Attributes double-click on Subject
  • Set the Alias to SubjectOfBook
  • Press 
• Press  in the main view configuration form to save your changes
• Either open the view – or if you already have the view open, press Refresh
• You will see the new view attribute name appear as the column heading in the view

Anchor
_Toc402702622 _Toc402702622

Anchor
_Toc442889151 _Toc442889151

Hover text for descriptions

• Open the configuration form for the view Book List on the Stream Book List
• In the list of Stream View Attributes double-click on Synopsis
  • Set the Alias to Description
  • Press 
• Press  in the main view configuration form to save your changes
• Either open the view – or if you already have the view open, press Refresh
• Hover over one of the book descriptions – you will see the text pop up in a hover box

Anchor
_Toc402702623 _Toc402702623

Anchor
_Toc442889152 _Toc442889152

Conditional formatting

• Add an attribute to the Stream Book List:
  • Name: gridRowColour
  • Type: String
  • Length: 50
  • Expression:

...

Open the new view – you will see records for the publisher Humbolt highlighted in red, other rows shown in light blue.

Formatting numbers

Open the dashboard Debt Investigation (you created this in exercise 2). You will format the numbers that appear on this dashboard:

• Open the configuration form for the view Overall Debt Levels
• Open the configuration form for the view attribute DebtLevel:
  • Set Decimal Places to 2
  • Save your changes to the view attribute
• Save your changes to the view
• Refresh the dashboard – you will now see the debt level reported with 2 decimal places

Formatting dates on pivot views

Open the model Dashboards and Forms 01-08: Views, filters and dashboards (you created this in the Introduction to Modelling Course; if this is not available, open Dashboards and Forms 01-08: Views, filters and dashboards R).

...