Multi-Column View and Default Sort Options

A Multi-Column ViewClosed A Multi-Column View is an Enterprise-tier display option for options-based questions that reference a Data Source. The Multi-Column view displays more than one column from the Data Source to help users select the right answer. is a way to display options-based questions that reference a Data SourceClosed 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. (“lookup” questions). To help users select the right answer, the Multi-Column view displays more than one column from the Data Source. Default Sort Options are columns and sort types that you set up to “pre-sort” the information displayed to your field users. This topic describes these options and explains how to set them up.

Available on the Enterprise tier only:

Essentials
Advanced
Enterprise

Contents

What is a Multi-Column View?

A Multi-Column View is a way to display options-based questions that reference a Data Source (“lookup” questions). To help users select the right answer, the Multi-Column view displays more than one column from the Data Source.

This example shows a Dropdown question without the Multi-Column View. The app displays a single column that the Form Designer selected. With a single-column view, field users might not have enough information to choose the right answer.

Dropdown list of options that shows two items with the same description "Air Handler Control Board". Field users can't tell the difference between these two options.

The next example shows a Multi-Column View for the same Dropdown question. Field users can see that the two options have different manufacturers and part numbers. The additional information helps them to choose the right answer.

Dropdown list of options that shows two items with the same description "Air Handler Control Board". The Multi-Column View also displays the "Manufacturer" and "Part Number" columns to help the user choose the right answer.

Tip:You can also apply this view to Radio Button and Multiselect questions.

When you enable the Multi-Column View, users can sort and filter the information based on any of the displayed columns.

Dropdown list on the device that shows an arrow next to each column header. Users can select the arrow to sort all of the rows based on the selected column. The sort can be ascending (least value first) or descending (greatest value first).

Info:You can pre-filter the list even without the Multi-Column View. The topic Filter a List of Options in a Lookup Question explains in detail how filtering works.

What are Default Sort Options?

If left unsorted, the TrueContext Mobile App displays the lookup information in the same order as in the Data Source. Default Sort Options are columns and sort types that you set up to “pre-sort” the information displayed to your field users. This makes it easier for users to find the most relevant or frequently-used values near the top of the list.

Tip:You can use Default Sort Options with or without the Multi-Column View. If you do enable the Multi-Column View, field users can re-sort the list themselves.

The following example shows the parts list sorted by Manufacturer first and then by Part Number. Notice that the Description column is not in alphabetical order.

Parts list that shows "ACME Equipment" for all rows, with the part numbers in order of least to greatest.

Because this example displays a Multi-Column View, field users can re-sort the list themselves. This next example shows that a user re-sorted the list on the Description column.

Parts list sorted on the Description column in ascending order, from the least to the greatest values. The Manufacturer column now shows "Pronto HVAC Systems" because the rows are different from the previous sort.

When you set the Default Sort Options, you can select up to three columns. Field users, however, can only sort on one column at a time.

Set up a Multi-Column View

Tip:When you enable the Multi-Column View, you also allow field users to sort on any of the columns. If you want to display one sortable column, enable the Multi-Column view and select only that column in step 5.

Prerequisites

Steps to set up a Multi-Column View

  1. From the Manage Forms menu, navigate to the form you want to set up.

  2. Create or edit a Dropdown, Radio Button, or Multiselect question.

  3. On the Options tab, select Use Data Source for Options, and then complete the Data Source section.

    Info:The topic Use Data Sources in Forms describes this step in more detail.

  4. Switch on the Multi-Column View toggle.

    Result: The section expands to show the column selections.

  5. Select up to three columns from the Data Source that you want to display.

    Tip:Keep in mind that:
    • The first column defaults to the “display” column that you selected in the Data Source section of this tab. You can change this to a different column as required.

    • Your goal is to provide context for the field user when they make their selection. The columns that you choose to display don’t have to include the column that contains the actual answer sent to the server. This means that the user might see a value in the main form that they didn’t see in the Multi-Column View. For example, in the Multi-Column View, you might display Part Name, Manufacturer, and Price. In the main form, the answer displayed might be the Part Number.

    • The TrueContext Mobile App displays the columns in the order that you see in the Form Builder. To change the order, select and drag an item.

  6. Do you want to change the displayed column header to something different? For example, if the Data Source column header is “Part Code”, you can change the displayed header to “Part Number”.

    • If yes, enter a Custom header displayed on device.

    • If no, the device displays the same header as the Data Source column.

  7. Do you want to “pre-sort” the list of options based on up to three columns?

    Result: When a field user opens the question, the TrueContext Mobile App displays a tabular view that displays the columns you selected. Users can filter and sort on each column.

How the Multi-Column View works

Column headers

The maximum column header length is 255 characters.

Location-based features

You can set up a Multi-Column view and still Use Location-Based Features for a lookup question. To optimize the user experience:

  • The Distance column is always displayed last, with the header “Distance”.

  • Users can sort on the Distance column.

Set up Default Sort Options

Tip:You can use Default Sort Options with or without the Multi-Column View. If you do enable the Multi-Column View, field users can re-sort the list themselves.

Prerequisites

You must be either a TrueContext Admin user or a member of a FormSpace group with Can Create permissions.

Steps to set up Default Sort Options

  1. From the Manage Forms menu, navigate to the form you want to set up.

  2. Create or edit a Dropdown, Radio Button, or Multiselect question.

  3. On the Options tab, select Use Data Source for Options, and then complete the Data Source section.

  4. Switch on the Default Sort Options toggle.

    Result: The section expands to show the column selections and sort types

  5. Select up to three columns that you want to sort on. Select Ascending or Descending for each column.

    Tip:Keep in mind that:
    • The first column defaults to the “display” column that you selected in the Data Source section of this tab. You can change this to a different column as required.

    • The Default Sort Options use a lexical (alphanumeric) order. You can’t sort on dates.

    • The TrueContext Mobile App sorts the columns in the order that you see in the Form Builder. To change the sort order, select and drag an item.

    • Your goal is to position the most relevant or frequently-used answers near the top of the list. This means that you might sort on a column that you don’t necessarily display. For example, in the selection view, you might display the Part Name. In the sort options, you might sort on the Part Number.

  6. Do you want to allow field users to re-sort the list?

    Result: When a field user opens the question, the TrueContext Mobile App displays a pre-sorted list based on the selected columns and sort types.

Tip:If you choose to Use Location-Based Features, the list is sorted by Distance. If you define Default Sort Options, those override the sort on the Distance column.