The CaptureInGrid Command

by Peter on February 28, 2013

in User Reference

The original mechanism for capturing repeated data in the interview was for each instance of the repeater to be presented in the XpressDox interview’s tree view.

There is another way to capture the repeating data, and that is in a grid format –  a bit like a spreadsheet but actually more flexibly, which can be found out by trying it.

For example, there might be some set of commands like:

«ForEach(Child)»
First Names: «FirstNames»
Date of birth: «FormatDate(DateOfBirth,'MMMM d, yyyy')»
Attends School: «AttendsSchool»«ChooseUsingCheckBox(AttendsSchool,Yes,No,No)»
«End()»

With the inclusion of «CaptureInGrid(Child,Yes)», the interview would look something like this:

Grid

Notice that an empty row is provided.  As soon as the user enters data into any part of the grid row (i.e. into FirstNames, or DateOfBirth or AttendsSchool), then a new empty row will be added for further items to be included into the repeater.

Notice that the controls in the grid are exactly the same as if they were included in a normal interview screen accessed via the tree view – i.e a text area, a date picker and a checkbox.  Other controls such as drop-downs and radio button lists are also possible.  All of the interview layout commands are available – e.g. Caption, Width, Font and even Heading and Footing, although the latter two are likely to cause unwanted effects on layout of the grid.

Expanded View and ExcludeFromGrid

An expanded view of a repeating grid item is available, which shows the controls in a vertical layout, one under the other. This means, amongst others, that controls need not be restricted in width. (In the Desktop version of XpressDox, the <Right-Click> menu has an Expanded View entry).

Because the space available for the data elements in a grid is limited by the width of the particular screen, it is possible to exclude some of the repeater items from the grid. This could be done using the ExcludeFromIV command, but this would exclude the data element(s) from the expanded view as well. For this reason the ExcludeFromGrid command was introduced, so that data elements could be excluded from the grid view but nonetheless will display in the expanded view.