Trick or Treat Management
Categories
Business Operations
Level
Beginner

The Trick or Treat Tour Template transforms Halloween night into an exciting, organized adventure. It lets you plan your route through spooky mansions, forecast how much candy you hope to collect, and keep a detailed record of every treat you’ve received. As you explore, the template captures which mansions you’ve visited, tracks your candy haul, and helps you see how close you are to achieving your goals. Designed with both fun and structure in mind, it brings playful energy to Halloween while adding just enough order to make your candy quest legendary.

Database: 🎃 Trick or Treat Management

Quests

Fields

  • Status (Formula)

  • Goal (in pieces) (Number)

  • Treat type (Link to table)

  • Currently collected (Rollup)

  • Open potential (Rollup)

  • Current + Potential (Formula)

  • Current + Potential + 10% (Formula)

Views

  • All quests (grid)

  • All quests grouped by status (grid)

  • 🧙‍♀️ Enchanted quests (grid)

  • 🦉 Owl watch quests (grid)

  • 🕯️ Lantern path quests (grid)

  • 💀 Doomed quests (grid)

Treat types

Fields

  • Name (Formula)

  • Icon (Text)

  • Examples (Text)

  • Candy (Text)

  • Mansions (Link to table)

  • Loot (Link to table)

  • Total collected (Rollup)

  • Potential mansions (Count)

  • Average collected (Rollup)

  • Potential mansions not visited (Formula)

  • Potential average collection (Formula)

Views

  • All treat types (grid)

  • Treat types without potential mansions to visit (grid)

  • Treat types with potential mansions to visit (grid)

Mansions

Fields

  • Name (Text)

  • Address (Text)

  • Latitude (Number)

  • Longitude (Number)

  • Expected (Link to table)

  • Loot (Link to table)

  • Visited (Boolean)

  • Generosity level (Link to table)

  • Meets expectations (Formula)

  • Average expectation by treat (Formula)

  • Geocoord (Formula)

  • Tricked (Boolean)

  • Icon (Formula)

  • Generosity level average (Lookup)

  • Status (Formula)

Views

  • All mansions (grid)

  • All mansions grouped by status (grid)

  • Visited mansion above expectations (grid)

  • Visited mansion below expectations (grid)

  • Visited mansions where tricked (grid)

  • Mansions to visit (grid)

Loot

Fields

  • Name (Formula)

  • Quantity (Number)

  • Mansion (Link to table)

  • Treat (Link to table)

  • Created on (Created on)

Views

  • All items (grid)

  • All items grouped by treat (grid)

  • All items grouped by mansion (grid)

Generosity levels

Fields

  • Name (Text)

  • Average expected pieces (Number)

  • Mansions (Link to table)

  • Count mansions (Count)

Views

  • All generosity levels (grid)

Application: Trick or Treat App

shared

Data sources

  • Count enchanted

  • Count Lantern

  • Count owl

  • Count doomed

Homepage

Data sources

  • All mansions

Route

Data sources

  • Get mansions to visit

  • Get tricked mansions

  • Get mansions below expectations

  • Get mansions above expectations

Loot

Data sources

  • Loot

Actions (event)

  • delete_row (8ad00419-ed88-425f-9cf0-74504722fe11_click)

  • refresh_data_source (8ad00419-ed88-425f-9cf0-74504722fe11_click)

Quests

Data sources

  • Enchanted quests

  • Lantern quests

  • Owl quests

  • Doomed quests

Mansion details (not-visited)

Data sources

  • Mansion details

Actions (event)

  • update_row (click)

  • open_page (click)

Add treat

Data sources

  • Get mansions

  • Get treats

Actions (event)

  • create_row (submit)

  • update_row (submit)

  • refresh_data_source (submit)

  • refresh_data_source (submit)

  • refresh_data_source (submit)

  • refresh_data_source (submit)

  • open_page (submit)

Mansion details (tricked)

Data sources

  • Mansion details

Actions (event)

  • update_row (click)

  • open_page (click)

Mansion details (visited)

Data sources

  • Mansion details

  • Mansion treats

Actions (event)

  • delete_row (cebf3a49-e0e6-4714-9469-675a7c162768_click)

  • refresh_data_source (cebf3a49-e0e6-4714-9469-675a7c162768_click)

  • open_page (1bdbe4f5-c24a-4cb1-94e1-25408403a2b8_click)

  • refresh_data_source (cebf3a49-e0e6-4714-9469-675a7c162768_click)

  • refresh_data_source (cebf3a49-e0e6-4714-9469-675a7c162768_click)

  • refresh_data_source (cebf3a49-e0e6-4714-9469-675a7c162768_click)

  • refresh_data_source (cebf3a49-e0e6-4714-9469-675a7c162768_click)

Edit treat

Data sources

  • Get mansions

  • Get treats

  • Loot item

Actions (event)

  • update_row (submit)

  • refresh_data_source (submit)

  • refresh_data_source (submit)

  • refresh_data_source (submit)

  • refresh_data_source (submit)

  • open_page (submit)