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.


  • Discover and use templates to create apps
    Plan the structure of an app by preparing its data and display
    Create, add and manage data models
    Add and edit fields
    Configure different fields types
    Create fields with a spreadsheet
  • Manage field organization and set a primary key and display field
    Use data for table and form creation
    Find, configure and manage datasources
    Add, configure and manage model relations
    Manage events and security settings for models


  • 5m 39s
    The 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 12s
    It'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
  • Locked
    3.  Creating data models
    4m 46s
    Creating 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
  • Locked
    4.  Creating fields
    4m 53s
    Fields 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
  • Locked
    5.  Configuring fields
    5m 42s
    Having 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
  • Locked
    6.  Creating fields with a spreadsheet
    3m 38s
    Google 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
  • Locked
    7.  Managing fields
    4m 1s
    Once 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
  • Locked
    8.  Using data models
    6m 29s
    After 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
  • Locked
    9.  Working with datasources
    4m 53s
    Knowing 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
  • Locked
    10.  Working with relations
    4m 13s
    You 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
  • Locked
    11.  Configuring data models
    5m 21s
    You 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