Dropdown cells are created by a cell editor with a dropdown list, the designer has to provide a list of items by Items option.
Formula inside a cell is default value.
Example of Items formula.
=LOOKUP(Product, Code) - returns a list of product codes
=ARRAY(‘yes’, ‘no’) - returns a list with two items
=Section1.A1:A6 - returns a list of values from range A1:A6
Dropdown definition
Dropdown preview
Designer can easily create dropdown cell from Data dictionary list, just drag drop Data column on cell. Section has to be unbound, or bound to another data object.
Dragging data column on a cell to create dropdown
Remark: If the items in the drop-down list are retrieved using a LOOKUP formula, e.g. =LOOKUP(SYSUSER,NAME), the list will display a maximum of 50 items.
However, if the items in the drop-down list are retrieved from a table section, e.g. =section2.a, there is no limit on the number of items.
0 Comments