Set Content of FieldFilter Dropdown

The contents of a FieldFilter control can be set to items entered in a static list.  For example, you could easily create a static list of product values to use as a filter.

Step 1:  In the Page Layout Spreadsheet, select a FieldFilter dropdown list control and open the Formulas tab.

Step 2:  In the Formulas tab, select the ‘Populate from Static list’ event and enter a list of values and their corresponding display values.

Step 3:  Build and run your application.

See Also

Common Formula Examples