How to use data?

In this tutorial you will learn how to create apps which use data.

In Qalcwise you can create two different data structures: lists and data tables. You can use them in creating your apps.

1.List

1.a

Start with creating a list. To do so click 'Create a new list' button in designer. This list will contain information about different countries, for example countries of Europe.

1.b

First list field name 'Country_name' and then add three more fields named: 'Capital', 'Population' and 'Group'. Set 'Population' field type as Number.

 You can use data from this table:

Belgium Brussels  10449361  western 
Belarus Minsk  9608058  eastern 
Bosnia and Herzegovina Sarajevo  3871643  southern 
 Bulgaria Sofia   6924716  eastern 
 Croatia Zagreb   4470534  southern 
 Czech Republic  Prague 10627448   eastern 
 Denmark Copenhagen   5569077  scandinavian 
 Estonia Tallinn  1257921   baltic 
 Greece Athens  10775557   southern 
 Spain Madrid  47737941   southern 
 Netherlands Amsterdam   16877351  western 
 Liechtenstein Vaduz  37313   western 
 Lithuania Vilnius  3505738   baltic 
 Luxembourg  Luxembourg 520672   western 
 Germany Berlin  80996685   western 
 Norway Oslo  5147792   scandinavian 
 Poland Warsaw  38346279   eastern 
 Sweden Stockholm  9723809   scandinavian 
 Ukraine Kiev  42805731   eastern 
 Italy Rome  61680122   southern 
Latvia Riga 2165165 baltic

Screen_Shot_09-18-18_at_11.42_AM.PNG

2.Choose country

2.a

Now create a new app. Add a spreadsheet widget with two columns. In first column put 'choose group' and 'choose country'.

2.b

Then go to 'Data' tab, find your list there and drag 'Country' and 'Group' fields to the spreadsheet.

Screen_Shot_09-18-18_at_11.51_AM.PNG

2.c

To be able to choose country from the group you have to change field 'Elements' LOOKUP formula in cell B2.

Screen_Shot_09-18-18_at_11.57_AM.PNG

'group=B1' fragment was added.

(More about LOOKUP formula here)

 

3.Country information

3.a

Add a new spreadsheet widget. It will be showing data about chosen country.

3.b

To make it possible you need to bind this section with your list. You can bind one section with only one list record(row) - it means that a spreadsheet can view information about only one country at a time.

In order to bind this spreadsheet go to 'Data' tab and find your list there and drag it to the section's name.

Screen_Shot_09-18-18_at_12.11_PM.PNG

3.c

In column A cells write: 'Country','Group', 'Capital' and 'Population'.

3.d

Now drag all of the list fields to column B.

Screen_Shot_09-18-18_at_12.15_PM.PNG

Your spreadsheet should now look like this:

Screen_Shot_09-18-18_at_12.17_PM.PNG

 

*By dragging fields from a list without binding the list to the section you automatically create a dropdown in the cell you dragged it to. This is what you did in your first spreadsheet.*

3.e

In order to make this spreadsheet view information about the chosen country you need to change the LOOKUP formula in this spreadsheet:

Screen_Shot_09-18-18_at_12.26_PM.PNG

You have to add 'country=Section1.B2' in 'Filter' field. 

Sections and cell names may differ from yours. Make sure that you've added them correctly.

 

4.Table

4.a

Add a new table.Just as you did with the previous spreadsheet you need to bind it. The difference between a table and a spreadsheet is that in a table you can view information about multiple records at a time. One table row contains information about one list row.

4.b

Drag 'Country' field to column A and 'Population' field to column B.

4.c

In order to make the table view information about countries from the chosen group you need to fill LOOKUP formula in 'Filter' field with search criteria:

Screen_Shot_09-18-18_at_12.39_PM.PNG

Fragment 'group=Section1.B1' was added. Section1 is the first spreadsheet that you created and B1 is the cell where the group is chosen.

4.d

We want to view population in millions in column B. That's why we have to divide population by million. Simply add: /1000000.

Screen_Shot_09-18-18_at_12.44_PM.PNG

4.e

You can change column A and B headers.

4.f

Change column B type to 'Number'. Put 0.00 in 'Display format' field. To be able to compare chosen country to the group choose sorting option.

Screen_Shot_09-18-18_at_12.48_PM.PNG

 

5.Preview

5.a

Now by clicking 'preview' button you can check if the app works properly.

It should look something like this:

Screen_Shot_09-18-18_at_12.53_PM.PNG

5.b

The last thing that you need to do to make the app fully work is to add yourself or 'All' as app creators.

Screen_Shot_09-18-18_at_12.55_PM.PNG

And voila - your app is finished!

 

 

 

 

 

 

 

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk