Single and multiple selects

How to use single and multi-select control cells.

Insert the control cell

Use the canvas toolbar to insert a single or multiple select control cell:

Configure the control cell

For single and multiple-selects, there are several options for configuring the control cell:

Dynamic

This is the default option for these control cells - the values in the dropdown will be populated from the table or cell that you choose. The top 1000 entries will be shown, ordered by frequency. If another value is required that doesn't occur in the list, it can be entered manually.

Static

If the values of this control cell do not need to change, it can be made static. Options can be entered manually and ordered arbitrarily. If the selected values should be interpreted as a number, select that option from the Format list. In this case, any non-numbers will not be selectable.