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

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

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

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

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

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

Conditional formatting

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

if (_out.Publisher == "Humbolt", "red", "aqua")

• Re-load the file and run the stream to populate the new attribute:
  • Open the file browser from the file collector Book List
  • Navigate to the directory …\inputData\Books
  • Load the file BookList.xlsx
  • Run the stream Book List
• Create a new view on the Stream BookList
  • Type: Grid
  • Name: Book List – Publisher by Colour
  • Attributes: add all attributes to the view
  • Press  to save your changes

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

• Go to the stream Overall Debt Levels
• Open the configuration form for the pivot view Debt levels by payment method and date
• Make PaymentMeans a Row Attribute, and CalculationDate a Column Attribute
• Double click on CalculationDate in the field Column Attribute to open the view attribute configuration form:
  • Set Date/Time Format to yyyy-MMM-dd
  • Save your changes to the view attribute
• Save your changes to the view
• Open the view to see the dates as column headings, formatted as you have specified above