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.