Introduction to Google App Maker Part 3 of 5

Explore data models in App Maker, learn how tables, rows, and columns organize data as records and attributes, and implement one-to-many, many-to-many, and one-to-one relationships with primary and foreign keys.

Explore data model options in Google App Maker, focus on Google Cloud SQL, and practice by creating a new model called tickets in a service desk app.

Learn how to define string fields with validation and constraints in Google App Maker, including primary keys, auto-incremented IDs, regex rules, and unique name fields.

Create a description string with a 255-character limit to expand the text area, then configure a choice field with possible values and a default, and preview the form.

Build and bind form fields in Google App Maker by adding text boxes and drop-downs, wiring labels and descriptions to the data model, and configuring choices with options.

Add a date box in the app and label it. Select the tickets model and the today field to display the date value.

Create a new data model called tickets with fields date reported, status, title, description, and assigned to you, then update the description default and status options to in-progress and closed.

Explore model events in Google App Maker, learning how event handlers automate record creation and trigger behind-the-scenes tasks, including adding an email field to the form.

Explore model events in Google App Maker by practicing on after load and before create event handlers, using console log for debugging, and manipulating record fields with an active user.

Explore model events in the service desk app, using on before create, on after create, and on before save to log data and store the session email in reported by.

Learn to implement model events in the service desk app by creating a notes model with date created, created by, and note fields, plus a before create event.

Learn how to model a one-to-many relationship by linking a ticket to multiple notes. Use the relations tab in App Maker to set up and manage this note-to-ticket association.