Bed and breakfast

Glenhallow Way Inn · Bed and breakfast · Harpswell, ME

Ines Northcote is the innkeeper at Glenhallow Way Inn, an eight-room bed and breakfast, and she uses this to answer every guest's request and close it the same week, drilling from kind of request down to who handled what.

Food and hospitalityCustomer serviceDrill-down4 tables · 5 views · 1 form · 1 dimension set · 1 drill-down · 1 digest · 1 notification · 1 agent
Use this template

All requests

Guest requests
RequestRequest numberKind of requestStayHow it came inWhere it standsHandled by
Bring a crib to the roomREQ-26-527HousekeepingSTY-26-409PhoneNew—
Whale watch tour for fourREQ-26-530Local bookingsSTY-26-410PhoneNew—
Fresh towels mid-stayREQ-26-520HousekeepingSTY-26-407In personClosedWynne Castellanos-Dyer
Extra pillows and a bed fanREQ-26-523HousekeepingSTY-26-408In personIn progressWynne Castellanos-Dyer
Shower drain is slowREQ-26-525MaintenanceSTY-26-409TextIn progressThorvald Aguilar-Peck
Late check-out to one o'clockREQ-26-526Late check-outSTY-26-409In personNew—
Door lock sticks in the coldREQ-26-528MaintenanceSTY-26-410TextWaiting on supplierThorvald Aguilar-Peck
Dairy-free breakfast for oneREQ-26-529Breakfast and dietarySTY-26-410In personIn progressMarguerite Danforth-Finch
Dog-friendly room questionREQ-26-534Local bookingsSTY-26-414PhoneNew—
Nut allergy note for breakfastREQ-26-535Breakfast and dietarySTY-26-415EmailNew—
Dinner reservation the first nightREQ-26-536Local bookingsSTY-26-416TextWaiting on supplierInes Northcote
Dinner table for twoREQ-26-521Local bookingsSTY-26-407PhoneClosedInes Northcote

24 more rows

Tables

Guest requests

36 sample rows · 14 columns

Everything a guest asks for, who is on it, and whether it was closed the same week.

RequestRequest numberKind of requestStayHow it came inWhere it standsHandled by
Bring a crib to the roomREQ-26-527HousekeepingSTY-26-409PhoneNew—
Whale watch tour for fourREQ-26-530Local bookingsSTY-26-410PhoneNew—
Fresh towels mid-stayREQ-26-520HousekeepingSTY-26-407In personClosedWynne Castellanos-Dyer
Extra pillows and a bed fanREQ-26-523HousekeepingSTY-26-408In personIn progressWynne Castellanos-Dyer
Shower drain is slowREQ-26-525MaintenanceSTY-26-409TextIn progressThorvald Aguilar-Peck
Late check-out to one o'clockREQ-26-526Late check-outSTY-26-409In personNew—
Door lock sticks in the coldREQ-26-528MaintenanceSTY-26-410TextWaiting on supplierThorvald Aguilar-Peck
Dairy-free breakfast for oneREQ-26-529Breakfast and dietarySTY-26-410In personIn progressMarguerite Danforth-Finch
Dog-friendly room questionREQ-26-534Local bookingsSTY-26-414PhoneNew—
Nut allergy note for breakfastREQ-26-535Breakfast and dietarySTY-26-415EmailNew—
Dinner reservation the first nightREQ-26-536Local bookingsSTY-26-416TextWaiting on supplierInes Northcote
Dinner table for twoREQ-26-521Local bookingsSTY-26-407PhoneClosedInes Northcote

24 more rows

Stays

16 sample rows · 12 columns

Each booking from reservation to check-out, with the room and the requests made during it.

Stay numberGuestGuest phoneRoomBookedCheck-inCheck-out
STY-26-416Barnaby Strand-Ross(207) 555-0165The Plover RoomOct 2, 2026Oct 21, 2026Oct 23, 2026
STY-26-415Noor Hargreaves-Yoon(207) 555-0164Cormorant CottageSep 30, 2026Oct 18, 2026Oct 20, 2026
STY-26-414Emeric Delacourt-Mbeki(207) 555-0163The Tern RoomSep 24, 2026Oct 15, 2026Oct 17, 2026
STY-26-413Philippa Hartigan-Stone(207) 555-0162The Gannet LoftSep 27, 2026Oct 13, 2026Oct 15, 2026
STY-26-412Dmitri Calloway-Nair(207) 555-0161The Kestrel RoomSep 18, 2026Oct 10, 2026Oct 12, 2026
STY-26-411Rosalind Pembridge-Adu(207) 555-0160The Wren RoomSep 22, 2026Oct 8, 2026Oct 10, 2026
STY-26-409Tamsin Fairweather-Kaur(207) 555-0158The Heron RoomSep 3, 2026Oct 5, 2026Oct 9, 2026
STY-26-410Casimir Eldridge(207) 555-0159The Osprey SuiteSep 15, 2026Oct 5, 2026Oct 10, 2026
STY-26-408Lucius Marchetti-Owusu(207) 555-0157The Tern RoomSep 16, 2026Oct 4, 2026Oct 8, 2026
STY-26-407Henrietta Vandenbrink-Bose(207) 555-0156Cormorant CottageSep 9, 2026Oct 3, 2026Oct 7, 2026
STY-26-406Gideon Ashcombe(207) 555-0155The Plover RoomSep 12, 2026Oct 2, 2026Oct 4, 2026
STY-26-405Priya Thornbury-Okafor(207) 555-0154The Gannet LoftSep 6, 2026Sep 28, 2026Oct 1, 2026

4 more rows

Rooms

8 sample rows · 6 columns

The eight rooms, their beds and nightly rates.

RoomFloorBedNightly rateStays
Cormorant Cottage1King$340STY-26-407, STY-26-415
The Gannet Loft3Queen with daybed$215STY-26-405, STY-26-413
The Heron Room1King$195STY-26-401, STY-26-409
The Kestrel Room2Queen$185STY-26-404, STY-26-412
The Osprey Suite2King$285STY-26-402, STY-26-410
The Plover Room2Two twins$155STY-26-406, STY-26-416
The Tern Room3Queen$175STY-26-408, STY-26-414
The Wren Room1Queen$165STY-26-403, STY-26-411

Also included

  • Requests by kind and standingDrill-down
  • Requests in progressDigest
  • New guest requestNotificationTells the innkeeper the moment a guest's request is logged so none sits unseen.