Mileage Tracker App

In this example we’ll build a simple “gas mileage tracker” app. The basic idea is just to keep track of one’s own (vehicles’) gas mileage.

To do that we’ll need some extra tables in our database, e.g. (at least) a “vehicles” table and a “mileage entries” table. We’ll expose those tables for CRUD in the web app, then add a simple chart to show mileage over time.

• Create the first App Table (vehicle)
  • New App Table Wizard
    • Enter Details
    • Write Model
    • Confirm Model
    • Write Migration
    • Confirm Migration
    • Migrate Database
    • Confirm Table
    • Commit Code
  • Viewing the Table
• Create the Master View (/vehicles/)
  • New Master View Wizard
    • Choose Model
    • Enter Details
    • Write View
    • Confirm Route
    • Add to Menu
    • Grant Access
    • Commit Code
  • Browsing the View(s)
• Create another App Table (mileage_entry)
  • Referencing another Table via foreign key
• Create another Master View (/mileage-entries/)
• Customize the Master Views
  • Adding hyperlinks for grid column cells
  • Fixing a foreign key reference form field
  • Setting default column sort for a grid
  • Setting custom grid cell rendering
  • Setting custom form field types
  • Adding “rows” grid when viewing a record
  • Summary
• Add a custom “Charts” page
  • Defining the view callable
  • Defining the template
  • Configuring the route
  • Adding a link from the “View” page
  • Improving the Charts page title/header
  • Fetching the chart data
  • Displaying the charts
  • Summary