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)