Repeatable Sections: Summary Table

Available on all tiers, with more options on the Advanced and Enterprise tiers:

Contents

• Repeatable Sections: Summary Table
  • About
  • Video demo of a Repeatable Section Summary Table
  • Inline editing
  • Enterprise tier options
  • Add a Column to a Summary Table
  • Modify Column Settings
  • Remove or Re-Order Columns

About

Repeatable Sections allow mobile users to provide multiple entries for the same set of questions—like line items on an invoice, parts or labor on a work order, or time entries on a timesheet.

Once mobile users have added entries to a Repeatable Section A Repeatable Section is a subform that contains a set of related questions. The data captured is “repeating”, because the field user can complete the same subform more than once, which creates multiple entries., the entries are summarized in a table view in the main form in the Mobile App. This is called the "Summary Table." Every Repeatable Section has one, and its purpose is to give mobile users a summary of the work they have completed.

Info:The topic Repeatable Sections on the Mobile App describes the field user experience in more detail.

Video demo of a Repeatable Section Summary Table

In this video, you’ll learn about how Repeatable Sections and Summary Tables help you to:

• Handle the complexity of work in the field.

• Manage large amounts of data collected in the field.

• Assess the field situation at-a-glance.

The video describes row-level features such as Custom Column Setup, Inline Editing, and how to set them up in the Form Builder.

Inline editing

You can set up a Summary Table with inline editing to make it simpler for users to edit answers. When a field user taps the edit icon, only the selected question opens, not the whole subform. Inline editing works in both the Compact The term "compact view" refers to a Summary Table in a Repeatable Section. The compact view displays the Summary Table "inline" with the rest of the form. The "full view", by contrast, displays only the Summary Table. and Full The term "full view" refers to a Summary Table in a Repeatable Section. When a field user selects the "View All" option, the table opens in full view, and no other part of the form is visible. The "compact view", by contrast, displays the Summary Table "inline" with the rest of the form. views.

Available on the Advanced and Enterprise tiers:

Supported question types

Inline editing is available for the following question types:

• Button Group

• Geo Location

• Multiselect

  • No more than nine options
  • Manually-defined options only (not Data Sources Data sources, also known as "Lookups", are external sources of data that you upload or connect to TrueContext. You can reference this data in a form to populate answers or answer options. Data sources save typing, reduce errors, and make it easy to provide mobile users with only the relevant, most current data.)

• Radio Button

  • No more than nine options
  • Manually-defined options only (not Data Sources)

• Single Checkbox

• Slider

• Text Field

Display Value or Answer Text

You can set Button Group questions to show the Display Value, and Text Field questions to show the Answer Text. Users can still edit the question inline without opening the subform, but they edit the question in a separate window.

The following example shows how inline editing works when a Button Group question is set to the Display Value.

Control

Available on the Enterprise tier only:

Users on the Enterprise tier can edit Button Group and Text Field questions directly in the Summary Table. To set these up, select Control as the Answer value to display.

The following example shows how inline editing works when questions are set to Control.

Enterprise tier options

Users on the Enterprise tier can further customize the display of Summary Tables in the Mobile App. The following image shows the display options available.

Wrap rows to new line

On a small screen, when a long row wraps to a new line, users can see all of the information without scrolling. This setting applies only to the compact view The term "compact view" refers to a Summary Table in a Repeatable Section. The compact view displays the Summary Table "inline" with the rest of the form. The "full view", by contrast, displays only the Summary Table. of the Summary Table.

This example shows what the Summary Table looks like when a row wraps to a new line. The headers are displayed within each table cell.

Hide headers

Choose the option to hide headers on the Mobile App if:

• You want to simplify the display, especially on small screens.
• Field users don't need the headers to understand what’s in each table cell.

Hiding the headers also applies when you set the compact view to Wrap rows....

This example shows the Summary Table with both the Wrap rows… and Hide headers options selected. This simplifies the on-screen display and saves space.

Sort by column

With this option, users can sort all the rows in the Summary Table Full View The term "full view" refers to a Summary Table in a Repeatable Section. When a field user selects the "View All" option, the table opens in full view, and no other part of the form is visible. The "compact view", by contrast, displays the Summary Table "inline" with the rest of the form. based on a single column.

If the contents of the column are numerical, the column is sorted in an ascending or descending order. If the contents are text-based, the column is sorted alphabetically.

This example shows the Summary Table full view sorted by the Cost column in ascending (increasing) order.

Filter by column

With this option, users can enter a filter to narrow down the number of rows displayed in the Summary Table Full View. If the row partially matches the filter, then the row is displayed.

Users can add filters to multiple columns and further narrow down the data displayed.

This example shows the Summary Table full view filtered by the Availability column. Only the rows with matching values are displayed.

Tip:You can filter on more than one column to limit the results even more.

Add a Column to a Summary Table

Prerequisites:

• A Repeatable Section
• At least one question in it that is not an Information Label or Resource Image question.

Steps to add a column to the Summary Table

1. Navigate to the Repeatable Section.

2. Select Edit Summary Table or Questions.

   

   Result: The Form Builder The Form Builder is the tool that form designers use to create forms. In the Form Builder, accessed from the TrueContext Web Portal, form designers can add and edit pages, sections, and questions, as well as attach data destinations and configure the form's settings. displays the Repeatable Section main editing window.

3. In the Summary Table area at the top, select Add a column.

   

4. Choose the kind of column you want to add:

   • If you want to create a column that displays an answer from the Repeatable Section, select the question from the list.

     Result: The Form Builder adds the column to the Summary Table. Optionally, you can Modify Column Settings to specify display options and make the column editable.

   • If you want to set up a custom column to provide your field users with additional context, select Custom Column Setup (DREL Data Reference Expression Language (DREL) is used to get form data and metadata and add it to a string, such as dates, usernames, or answers to questions in forms.). Go to step 5.

   

5. When you select Custom column (DREL), the Form Builder displays the configuration settings.

   • Enter a name for the Column Header.

   • Enter the Text Displayed in Cell. This can be a DREL expression, static text, or a combination of both.

     Info:The TrueContext Mobile App only accepts certain DREL expressions for custom Summary Table columns. The topic Overview: Repeatable Sections provides a list of supported DREL expressions for Repeatable Sections.

     Note:

     • DREL in a custom column can only reference questions within the same Repeatable Section.

     • DREL in a nested section can only reference questions within that nested section.

     • Fields in a custom column are read-only, and you can’t configure them for inline editing.

   • Set the column display properties.

6. Select Save.

   Result: The Form Builder adds the custom column to the Summary Table.

Modify Column Settings

1. Select the pencil icon inside of the desired column.

   

   Result: The Edit Table Column window opens for the selected question.

   

   The following table describes each setting.

   Number	Setting	Description
   1	Column Header	Enter the text that you want to display as the column header in the Mobile App. The column header doesn’t have to match the question text.
   2	Column display priority...	Select a display priority for the column. Mobile devices can fit a different number of columns depending on their screen size. Priority determines which columns display on the device: Low priority columns hide first on smaller device screens. High priority columns stay visible even on smaller device screens. If a Summary Table has multiple High priority columns, smaller screens hide the rightmost columns.
   3	Text Alignment	Choose an alignment for the column text. For example, you may want numeric columns right-aligned and text columns left-aligned.
   4	Minimum column width...	Choose a minimum column width based on the column contents. For example, set a Text Area question column to Large since it may need more space to display the text properly. Device screens can display more Small columns at once than Large columns.
   5	Answer value to display	Show field users either the data Options-based questions have a display value and a data (server) value. The data value is the answer submitted to the TrueContext server. The Form Designer can choose whether the display and data values are the same or different. or display Options-based questions have a display value and a data (server) value. The display value is the answer shown in the Mobile App. The Form Designer can choose whether the display and data values are the same or different. value of an answer. This setting is available for the following options-based question types: Button Group Card List Dropdown Multiselect Radio Button (On the Enterprise tier, there’s also a Control option. This is useful for inline editing.) On the Enterprise tier only, Text Field questions can display the Answer Text or the Control. These apply when you enable inline editing for the column. Tip:If you select the Display Value and your team has the Multi-Language add-on, the column shows the translated value on the device.
   6	Column can be expanded...	Select the checkbox to let the column expand to fill any empty space. For example, if the Summary Table has three columns, but the device can display 3.5, the column fills the extra space.
   7	Allow users to edit answers... Available on the Advanced and Enterprise tiers: Essentials Advanced Enterprise	Select the checkbox to let Mobile App users edit their answers from the Summary Table without expanding the whole row. The following example shows what inline editing looks like on the device. In this example, a Button Group question is set to show the Display Value. The question opens for the user to edit. The inline editing option is available for the following question types: Button Group Geo Location Multiselect No more than nine options Manually-defined options only (not Data Sources) Radio Button No more than nine options Manually-defined options only (not Data Sources) Single Checkbox Slider Text Field Info:The section Inline editing includes more details about how inline editing works and how to set it up. On the Enterprise tier, you can set the Button Group to Control. The user edits directly in the table.

2. Edit any of the column settings.

3. Select Save to save your changes.

   Result: The system saves your changes and displays the Repeatable Section page.

Remove or Re-Order Columns

Remove a Column:

1. Select the pencil icon on the desired column to open the edit window.

   

2. Select Remove Question from Table at the bottom of the pop-up.

   

3. The column will be removed (the question it referenced will still exist in the Repeatable Section).

Re-Order Columns:

1. Select and hold on the dotted "move" handle in the column header.

   

2. Drag the column sideways to the appropriate spot in the table.