Value lists (Beta)

Add a value list element to create an organized display of details from one or more data sources. You can customize the value list to show custom formula results, control values, static values, and more. When paired with a single row container, you can create a dynamic list that shows individual records from a data based on user input. To see an example of a value list paired with a single row container, see Example: Create a gallery of national parks.

This document explains how to create and customize a value list element.

User requirements

To add and edit value list elements:

• You must have Can edit or Can explore access to the individual workbook.
• You must be in Edit or Explore mode for the workbook. See workbook modes overview.

Create a value list element

To add a value list element to a workbook:

1. Open a draft, custom view, or saved view of a workbook.

2. In the Add element bar, select UI > Value list. The new value list element appears on the page.

Customize fields in a value list

By default, a value list element contains three empty fields. You can add and customize additional fields to display more information:

• Configure a field in a value list
• Add a field to a value list
• Remove a field from a value list
• Organize fields in a value list

Configure a field in a value list

1. Select the value list element on the workbook page.

2. In the editor panel, under Properties, in the Fields section, select the field you want to configure.

3. If the value list is connected to a single row container, choose whether to display a value from a Source column or a Formula. If it is not connected to a single row container or repeated container, you can only configure fields using a formula.

   • For Formula, use the formula bar in the Value section to configure the value fo the field. Optionally, enter a Label for the field.

• For Source column, select a column from the connected data source in the Value section. Optionally, enter a Label for the field.

💡

Fields in a value list can only display one value. If your selected data source or formula returns multiple values, the field reads Multiple values.

Add a field to a value list

1. Select the value list element on the workbook page.

2. In the editor panel, under Properties, in the Fields section, click Add field.

3. A new calculated column appears at the bottom of the Fields section.

4. Select the calculated column to configure its contents.

Remove a field from a value list

1. Select the value list element on the workbook page.

2. In the editor panel, under Properties, in the Fields section, click More options for the field you want to remove.

3. Click Delete.

Organize fields in a value list

1. Select the value list element on the workbook page.

2. In the editor panel, under Properties, in the Fields section, drag and drop fields to organize them in the desired order.

Customize value list

You can customize the appearance of the value list and its fields.

1. In the editor panel, select the Format tab.

2. In the Element style section, customize the following:

   • Padding: On by default. Turn off the toggle to remove padding between elements.
   • Background color: Change the background color of the value list using a hex code, color palette, or color picker.
   • Border: Add a border around the value list.
   • Corner: Select whether to have square, round, or pill-shaped corners for the value list.

3. In the Field style section, customize the following:

   • Label format: Change the font size, weight, and color of the field label.
   • Value format: Change the font size, weight, and color of the field value.
   • Layout: Choose whether to organize fields and labels in a grid, compact, separated, or stacked layout.