What is filtering?
Filtering gives us an answer to this question: which options in option list B should be available when specific option in option list A is selected?
Options of option list B can be filtered by option selected in option list A.
Filtering is great to provide users only with desirable combination of options.
How to define filtering?
You can set up filtering in def_index_filter sheet of your spreadsheet.
On the first row, starting with column G, enter IDs of option list you want to filter by. Then in cells under each option list ID you can define filtering. To better understand filtering, let’s examine an example below.
Sem vložiť embed číselníkov material a material type
Sem vložiť obrázok definície filtrovania číselníkov
There are two input cells: Material and Material type. Option list linked to Material type input cell is filtered by option list linked to Material input cell.
Let’s look at cell H11. There is a value: 1. It means following:
„When option with ID of 1 (Wood) from option list material_list (Material) is selected, then option on current row (Oak) will be available in the option list type_list“.
If we would leave cell H11 empty, Oak would be available in Material type input field without any dependency on option list material_list.
Good to know
- One option list can be linked to many input cells.
- Option list is filtered in every input cell that it is linked to.
- When all options of an option list are filtered out, input cell with this option list is set as invisible. Input cell remains without any value, thus any visibility or editability conditions based on this input cell won’t function.