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.
Rebinding table depends on selecting the allow add rows option. When a table has no allow add rows option selected, the refreshed data replaces the data that was previously in the table. On the other hand, when the table has the allow add rows option selected, the next refreshed data are added to the table one by one.
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