App Datasets

Overview

App Datasets allow user to keep tabular data regarding the application. The datasets can be updated through the logic of the app. There are also features to import external data sources. This screen will provide dataset management for the App.

Add New

You can create new Dataset or import from external source.

Below are the options to create new Dataset:

  • Create Dataset manually

  • Import data from external source

  • Import data from Excel file

  • Display push notifications

  • Display app users

  • Display app user groups

You can create Dataset in tabular structure to store data. To build Dataset you need to add Dataset name and field definitions.

image

To add multiple Fields, you need to add Field name and type then press, “Add field” - button. By pressing “X” user can remove added field.

Below Field-types are available:

  1. Text

  2. Rich Text

  3. Number

  4. Timestamp

  5. Boolean

  6. Location

  7. URL

  8. image

  9. File

Edit Dataset

This screen will display list of datasets added to selected App. User can select dataset to edit. , we can see data/items added in the data set. We can add/delete items from the data set in Edit mode.

As show in the below screenshot user can do below function on this screen.

image

Options in Item Data list

  • Sort, Sorting is available on each column/field.

  • Search, Search for items in the grid.

  • Delete, ** It will delete specific items from dataset.

  • Published, An item we enter in dataset can be schedule to publish in app. This field display status of item whether it is published or scheduled to publish.

Add Item

User will get option to add on record in Dataset. Once user click “Save”-button, that Item will get displayed on the grid.

image

Add Column

New column/field can be added in existing dataset. User need to enter new column name & type of the column. Existing record/item will have blank value in newly added column.

Export

Dataset can be exported as an excel sheet.

Settings

Selected item can be schedule to publish. You can specify the in and out timing of a specific record by scheduling it.

Layout

This will enable user to create a view for selected dataset. That can be used in Patchwork to build logic and combine with other views to set navigation.

You can build 3 kinds of views List, Calendar and Map.

Note: We will see more about view design in View.