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.
Status (Formula)
Goal (in pieces) (Number)
Treat type (Link to table)
Currently collected (Rollup)
Open potential (Rollup)
Current + Potential (Formula)
Current + Potential + 10% (Formula)
All quests (grid)
All quests grouped by status (grid)
🧙♀️ Enchanted quests (grid)
🦉 Owl watch quests (grid)
🕯️ Lantern path quests (grid)
💀 Doomed quests (grid)
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)
All treat types (grid)
Treat types without potential mansions to visit (grid)
Treat types with potential mansions to visit (grid)
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)
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)
Name (Formula)
Quantity (Number)
Mansion (Link to table)
Treat (Link to table)
Created on (Created on)
All items (grid)
All items grouped by treat (grid)
All items grouped by mansion (grid)
Name (Text)
Average expected pieces (Number)
Mansions (Link to table)
Count mansions (Count)
Count enchanted
Count Lantern
Count owl
Count doomed
Get mansions to visit
Get tricked mansions
Get mansions below expectations
Get mansions above expectations
delete_row (8ad00419-ed88-425f-9cf0-74504722fe11_click)
refresh_data_source (8ad00419-ed88-425f-9cf0-74504722fe11_click)
Enchanted quests
Lantern quests
Owl quests
Doomed quests
update_row (click)
open_page (click)
Get mansions
Get treats
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)
update_row (click)
open_page (click)
Mansion details
Mansion treats
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)
Get mansions
Get treats
Loot item
update_row (submit)
refresh_data_source (submit)
refresh_data_source (submit)
refresh_data_source (submit)
refresh_data_source (submit)
open_page (submit)