Button associated with the action allows you to manually refresh the links between sections of the previously selected option to manually refresh tables and spreadsheets. When using these settings, the links between tables are refreshed only when you click.
To change the refresh settings to a spreadsheet or a table, go to the options of the section and select manual refresh (1), and set any formula filter, ie. the formula of type Lookup (2). Then add the action to the button by selecting it in the designer. After button selection the options tab will show the button to add new action (3). Select the rebind sections action (4) and enter sections names to rebind (5).
From now selected sections will be refreshed only when a user clicks the configured button.
Let's create an application that allows you to search the city, depending on a given country. For this purpose we will add 3 widgets in the designer:
- Spreadsheet SECTION1 with a single, editable text cell.
- Table SECTION2 with the filter formula =LOOKUP(CITIES, COUNTRY=SECTION1.A1) and set manual refresh. Presented formula filters out all the cities that belongs to the country entered in A1 cell of SECTION1.
- Button BUTTON1 with the assigned rebind sections action and added SECTION2 as section to rebind.
In addition, we created a simple data table containing the information about cities and countries. The result of our work is a simple application that searches the city after clicking on the search button, rather than automatically updating the data every time you enter the country to editable cell.