← Back Published on

Creating a Table using App Engine Studio (AES)

Data is Key!

In an application, data is key. Data is used for a collection of reasons such as storing information on users or items. It's stored in a table, which collects data in fields. You'll notice that when creating a table, there's a label and a system name. You may be curious as to what the difference between the two is, let me explain. 

  • Label: The name the user sees when interacting with the form. 
  • System name: The technical name of the field. Typically has zero spaces and any spaces are replaced with an underscore. 

When you create a table there are 5 fields added to the table by default. These fields can't be modified or deleted. They are: 

  • Created - date and time the record was created
  • Created by - user who created the record
  • Updated - date and time the record was updated
  • Updated by - user who updated the record
  • Updated - how many times the record has been updated

When creating the fields for your table, you can also set a display value. A Display Value is what shows on the record as the form header. For instance, in my video below, I set Cardio Machine as the display value. That way, when a record is opened, the value entered in the Cardio Machine field displays as the form header. 

ATTENTION (PLEASE READ) I do want to bring attention to something in my video. Towards the end of the video when I'm setting my display value, I made the comment that ONLY string fields can be set as display values. That is FALSE. The only thing to note is that only ONE field can be set as the display value for a table. 

If you're interested in seeing me create the table for my Fitness Tracker App, create fields, set field types, setting a UI policy, and submitting records, then check out my below videos.