Displaying Data in a Data Table

One of the most valuable features of iRise is the ability to incorporate and display interactive data as part of your simulation. This allows you to show preset sample data or data captured from your reviewers to validate requirements for an application, or even a simulated integration between two or more systems.

While a number of widgets can be used to display dynamic data, for this tutorial, we will be focusing on the iRise Table widget.

Watch a Video

Watch this video for a quick demonstration of the tasks covered in this tutorial.

Table widget overview

Table widget

Tables are primarily used in one of two ways within iRise:

Setting up a Data Table

One common way to display your datasheet data is by connecting it to a Table widget. Insert a Table dialogTo create a Data Table, drag a Table widget from the Widget Toolbar onto a page. The Insert a Table dialog box will appear, prompting you to select the Table type and parameters for the number of Rows, Columns, Headers and Footers.

For the purposes of our example, select the Data tab, enter 3 columns and choose OK.

Your Data Table will appear on the page with the number of columns and rows that you specified. For a Data Table, you will notice a red border around the bottom row.

Data Table

The first row will contain the header labels which will display just as they are entered when we launch the simulation in the browser. The second row that is highlighted in red is referred to as the Data Row. This row will be used to display data records from a datasheet.

Add a Text widget for each of the three columns into the first row of the table (First Name, Last Name and Phone).

Now add a Text widget into each of the cells in the Data Row. Since these labels will be used as placeholders for data, avoid adding spaces between the words and enclose the entire label in brackets (for instance, enter the label for the First Name column as [FirstName]).

Populated Data Table

Import a sample datasheet

In order to display data, we’ll need to create a datasheet and add records to display in our Data Table.

Tip

If you completed the previous Storing Records in a Datasheet tutorial, you can reuse the datasheet you created.

First, create a new datasheet in your Directory panel and call it CUSTOMERS.

With the datasheet still displayed in your workspace, click the Import CSV icon above the datasheet and select the ‘Person.csv’ file (by default, you will be given four existing CSV files that are available as part of your iRise Studio installation).

All of the records will be imported into your datasheet so that they can be used as part of your simulation. Once in the datasheet, you can interact with the data much like you would a spreadsheet. For example, you can create new rows (records) and modify any of the information that was imported.

Connect the datasheet to your Table

Drag the new datasheet from the Directory panel onto the canvas of the page containing your Data Table (the canvas is the gray area outside of the white page area). The Select Action dialog box will prompt you to select a record action type. Choose the default Get Record option and click OK.

A new Get CUSTOMERS icon will appear on the canvas. The text ALL that appears over the icon signifies that you have not limited which records will be displayed.

Drag the Get CUSTOMERS Record widget and drop it over the Data Table to open the Data Flow Editor. The Data Flow Editor allows you to map fields in the CUSTOMERS datasheet to the corresponding Text widgets in your Data Row. In each of the dropdown lists in the left column, choose the appropriate value for each of the text labels that are in brackets.

Data Flow Editor

After choosing Save, you will see that a dotted red line has been added to the page connecting the Datasheet to the Form. This line represents “collapsed” (or “summary”) data flow. If you right-click the line, you will be presented with options to edit the data flow (which reopens the Data Flow Editor) or expand the data flow to see the individual mappings.

When you launch your simulation in iRise Reader, you will be able to see that the data connection has been made, as the Data Row will repeat for each record in the datasheet, and the placeholders will be replaced by the field data in each record .

Data Table in the Reader