In order to create a database first we create a screen and select Data View:
We create a new database by:
Selecting a "New database"
- Enter a name and the number of columns/fields you want your database to have.
- Insert a name for each field and select the type for each field
Some notes about the data types:
-The difference between Date and Dataset: a Date type is only for one data, e.g. 25th December, and Dataset are several dates, e.g. 25th December, 1st January, 6th January.
-Date type is stored in UTC. Therefore it will be visualized in the local time of the device.
-The remote types (audio, images and video) are text types that contain the URL of the remote types.
The cloud Database option is only available if you have an Standard plan or above.
Now click Accept and the database has been created. In order to fill it with data just click Edit:
Here you insert the data of each field created. You can fill as many rows as you need:
Depending on the type of data defined for each field when adding data, different tools are offered:
When finished with all the rows, you want to add the result which should look something like this:
If you decide that you want to add more columns/fields, just click the "+" button and add a column name, type of data and add as many rows as you want:
The data type and column/field holds can be defined or changed in the following way:
Just click Accept and your database will be ready to handle in the following two ways: