Chapter 12. Detail Windows and Task Panes

Chapter 12. Detail Windows and Task Panes

We may use another technique to show details in windows and task panes using the SelectionChange handlers.

Detail Windows

Let's select the handlers worksheet and add the SelectionChange handler:

Sample of the SelectionChange handler

Complete table:

A complete sample of the SelectionChange handler

Switch to the payments worksheet and click Reload, Reload Data and Configuration to reload the configuration.

Then select another row in the Payments table. You will see the window with row details:

A context window updated on selection change

You may select another row. The window will stay on top and show related information.

_Transpose

You may transpose row to columns in the output window. Just add the _Transpose word in TARGET_WORSHEET:

The _Transpose option in TARGET_WORSHEET

 

Switch to the payments worksheet and click Reload, Reload Data and Configuration. A new window looks like

Sample of the transposed data

Task Panes

Use of detail windows is a good solution when you need windows that are always visible.

If you need context windows, you may use task panes. Just add the _TaskPane word in TARGET_WORSHEET:

Sample of the _taskpane option

A new task pane window will look like

A context task pane updated on selection change

 

You may customize column formats using the context menu.

Also, you may dock task panes and turn them on/off using the SaveToDB, Options, Show Task Panes option.