If Spreadsheet or Table section has Filter formula, refresh mode defines how and when data bound to section is refreshed. There are three modes:
'After change' - data is refreshed when app is created and after change of every cell used in filter query formula.
'Manual' - data is refreshed after user click button with Rebind sections action.
'Always' - data is refreshed when app is created, opened and after change of every cell used in filter query formula.
Section has the following Filter formula: =Lookup(PRODUCT, PRICE > Section1.A1)
Whenever cell Section1.A1 value changes, section will be rebinded.
After value is changed in search_criteria price cell, results section will be rebinded