Refreshing sections - tutorial

In this tutorial you will learn how to use section refreshing options.

We will show section refreshing by a simple data searching app. 

1.List

First, create a new list. It will be a list containing information about different countries from all around the world. You can use data from the table below.

Afganistan	Asia	low	35530000
Australia	Australia & Oceania	very high	24511800
Bolivia	South America	medium	11071000
Brasil	South America	high	207679000
Canada	North America	very high	36708083
China	Asia	high	1390080000
Egypt	Africa	medium	94800000
Eritrea	Africa	low	5933000
Indonesia	Australia & Oceania	medium	261989000
Mexico	North America	high	124574795
Moldavia	Europe	medium	3553100
Mozambique	Africa	low	26573706
Nepal	Asia	medium	30485798
Netherlands	Europe	very high	17108799
Paraguay	South America	medium	6943739
South Korea	Asia	very high	51454000
Tunisia	Africa	high	11403800
Turkey	Europe	high	82835090
USA	North America	very high	326079000

Name the table fields as below and choose accurate types for them.

2.Sections

2.a

Add a new spreadsheet section with two columns. Fill it as below and B1 cell bind with 'continents' field from countries list by dragging it from the 'data' tab, list 'world_countries'.  

2.b

Add a new table section and bind it with the list of countries by finding the list in 'data' tab and dragging it to the section. Next table columns bind with list fields by dragging field names to the columns. Change column headers as below.

2.c

We want the table to view information about all countries from the chosen continent. That is why we need to fill the lookup formula for our table with search criteria. 

=LOOKUP(WORLD_COUNTRIES,continent=section1.b1)

3.Workflow

Add workflow actions widget. 

Let's create a simple workflow. It will consist of two states: 'sent' and 'accepted' and two actions: 'send' and 'accept'.

On enter to 'sent' state add 'set editors' actionstep. In it add yourself as the editor.

4.Refresh mode

a) after change

It's a default refresh mode.

In our case this will mean that the table section will refresh after change of continent in spreadsheet section. Even after editing the country data in the countries list the refresh will not happen. It also means that the section will not refresh after changing the state.

Start:

sent:

Data in the table changed only after changing the continent in the spreadsheet.

b) always

Set the 'always' refresh mode for the table. It means that the data in our table changes both after changing the continent and after changing the data in the countries list.( we can notice the list data changes after opening the app again).

Start:

Next, add one european country to the list.

In the next state the added country is visible:

c) manual 

The manual mode is useful when we have a couple of search criteria e.g. beside the continents we also have the level of the development. If we want to first fill in the search criteria and then get search results this mode is the best choice for us.  

So now let's add a second search criteria. In next row of the spreadsheet type 'choose level'. Bind the B2 cell with 'level of development' field from countries list.

Next, to the table lookup formula add the search criteria connected with the level.

=LOOKUP(world_countries,continent=SECTION1.B1 && level_of_development=section1.b2)

To be able to use the manual mode add the button widget. Name the caption 'search' and add 'rebind sections' actionstep. In 'sections' field type section2 - the table section.