Structuring your data model
Google App Maker
| Intermediate
- 11 videos | 53m 46s
- Includes Assessment
In this 11-video course, learners will explore how to set up the different data models, fields, and data sources that are needed to build the foundation of an app. You can also use the Google App Maker templates to give you a kick-start in the right direction. Begin by discovering how to use templates to create apps, and learning how to plan the structure of an app by preparing its data and display. You will explore how to create, add, and manage data models; add and edit fields; configure different field types; and create fields with a spreadsheet, manage field organizations and set a Primary Key and Display field. Next, learners will begin using data models for table and form creation; observe how to work with data sources by finding, configuring, and managing data source; and learn to work with relations by adding, configuring, and managing model relations. Conclude this course by observing how to manage events and security settings for models.
WHAT YOU WILL LEARN
-
Discover and use templates to create appsPlan the structure of an app by preparing its data and displayCreate, add and manage data modelsAdd and edit fieldsConfigure different fields typesCreate fields with a spreadsheet
-
Manage field organization and set a primary key and display fieldUse data for table and form creationFind, configure and manage datasourcesAdd, configure and manage model relationsManage events and security settings for models
IN THIS COURSE
-
5m 39sThe Google App Maker templates can make it easier for you to create your different apps. You will have access to the full list of templates if you set up a Cloud SQL database. This video will show you how to creat an app from a template. FREE ACCESS
-
4m 12sIt's important to take into consideration the different tasks your app will perfroma and who will use it. This is going to help you create the three main components for your app; the data, pages and scripts. This video will show you how to plan the stucture of your app with Google App Maker. FREE ACCESS
-
4m 46sCreating models is especially important when creating your apps. Models organize and store data in a similar way to a sheet in a spreadsheet allowing you to organize the data that you enter into fields and records. This video will show you how to create, edit and manage data models. FREE ACCESS
-
4m 53sFields are an integral part of the models you create in your Google App Maker app. Therefore, it's important to know how to create different types of fields, edit fields and delete the fields you no longer need. FREE ACCESS
-
5m 42sHaving creating different fields, with different types, it's important to know how to configure them so that your app runs smoothly. In Google App Maker you can configure your fields from the advanced options. FREE ACCESS
-
3m 38sGoogle App Maker allows you to create models directly from spreadsheets. Adding a spreadsheet from your computer or Google Drive will save you valuable time while creating your models. FREE ACCESS
-
4m 1sOnce you have inserted fields into your different models it's important to know how to organize them. For example, you can change their order, set one of them as Primary Key and you can choose the display field for your model. FREE ACCESS
-
6m 29sAfter adding data models you can prepare them to be able to use them in different widgets. This video will show you how to add a form and table widget to a page in your application using the data in your models. FREE ACCESS
-
4m 53sKnowing how to find, manage and edit datasources is an important part of using Google App Maker. For example, datasources can be used as a type of filter for displaying specific information in a table widget, for example. FREE ACCESS
-
4m 13sYou may have data in different models that have a direct link that you may to portray on your app. Such a customer data and purchase data. In Google App Maker you can create relations to link the records in your different SQL models. FREE ACCESS
-
5m 21sYou can configure you data models in different ways. You can create events which are custom actions triggered by other actions performed on your records. You could also set up security options for protecting confidential data that you might be using in your application. FREE ACCESS