Spreadsheet refresh mode

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.

 

Example:

Section has the following Filter formula: =Lookup(PRODUCT, PRICE > Section1.A1)

Whenever cell Section1.A1 value changes, section will be rebinded.

 

image01.png 

After value is changed in search_criteria price cell, results section will be rebinded

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk