Skip to content
To keep the main table fast. The fewer the rows, the faster (in miliseconds) the code in the button can be executed.we keep the data in for Today() - 7, which enables any user to look back in case of questions related to the recent past.To keep the time line up to do date, although you can filter on values like > Today() We have a time driven automation that addRows() and DeleteRows() every night. This automation handles all the work.The name of the automation is: 03 Archive reservationsMay this feel complicated, you can replicate the logic in a button in a table and use the automation only to push the buttons.When you have reservations covering more than a year and it is unlikely that you need this info, you can export the data and store it as a csv file.
i
DB Past Reservations
Keep track of your past in a seperate table.
Why we need this table?
How is this table filled?
Extra
DB Past Reservations
startDate
checks
room
contact
cardLine01
endDate
Name
status
Mon, Mar 4, 2024, 07:30
short slot
Room 1 | 8 places to sit
Jerôme Lejeune
Check-in for:
3 hrs
Mon, Mar 4, 2024, 07:30 →
Mon, Mar 4, 2024
3/4/2024, 10:30 AM
Mon, Mar 4, 2024, 07:30 Room 1 | 8 places to sit → Jerôme Lejeune
normal reservation
Tue, Mar 5, 2024, 09:00
short slot
Room 4 | 6 places to sit
Louise Meise
Check-in for:
4 hrs 30 mins
Tue, Mar 5, 2024, 09:00 →
Tue, Mar 5, 2024
3/5/2024, 1:30 PM
Tue, Mar 5, 2024, 09:00 Room 4 | 6 places to sit → Louise Meise
normal reservation
Thu, Mar 7, 2024, 07:00
short slot
Room 4 | 6 places to sit
Lea Nielsen
Check-in for:
3 hrs
Thu, Mar 7, 2024, 07:00 →
Thu, Mar 7, 2024
3/7/2024, 10:00 AM
Thu, Mar 7, 2024, 07:00 Room 4 | 6 places to sit → Lea Nielsen
normal reservation
Fri, Mar 8, 2024, 05:30
start
Room 5 | 10 places to sit
Jenny Lagarde
Check-in for:
2 days 8 hrs 30 mins
Fri, Mar 8, 2024, 05:30 →
Sun, Mar 10, 2024
3/10/2024, 2:00 PM
Fri, Mar 8, 2024, 05:30 Room 5 | 10 places to sit → Jenny Lagarde
normal reservation
Sat, Mar 9, 2024, 00:00
occupied
Room 5 | 10 places to sit
Jenny Lagarde
Check-in for:
2 days 8 hrs 30 mins
Fri, Mar 8, 2024, 05:30 →
Sun, Mar 10, 2024
3/10/2024, 2:00 PM
Sat, Mar 9, 2024, 00:00 Room 5 | 10 places to sit → Jenny Lagarde
normal reservation
Sun, Mar 10, 2024, 00:00
end
Room 5 | 10 places to sit
Jenny Lagarde
Check-in for:
2 days 8 hrs 30 mins
Fri, Mar 8, 2024, 05:30 →
Sun, Mar 10, 2024
3/10/2024, 2:00 PM
Sun, Mar 10, 2024, 00:00 Room 5 | 10 places to sit → Jenny Lagarde
normal reservation
Tue, Mar 12, 2024, 07:30
short slot
Room 6 | 10 places to sit
Pauline
Check-in for:
30 mins
Tue, Mar 12, 2024, 07:30 →
Tue, Mar 12, 2024
3/12/2024, 8:00 AM
Tue, Mar 12, 2024, 07:30 Room 6 | 10 places to sit → Pauline
normal reservation
Wed, Mar 13, 2024, 11:00
short slot
Room 6 | 10 places to sit
Gerry
Check-in for:
2 hrs
Wed, Mar 13, 2024, 11:00 →
Wed, Mar 13, 2024
3/13/2024, 1:00 PM
Wed, Mar 13, 2024, 11:00 Room 6 | 10 places to sit → Gerry
normal reservation
Sat, Mar 9, 2024, 07:00
start
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Sat, Mar 9, 2024, 07:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Sun, Mar 10, 2024, 00:00
occupied
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Sun, Mar 10, 2024, 00:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Mon, Mar 11, 2024, 00:00
occupied
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Mon, Mar 11, 2024, 00:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Tue, Mar 12, 2024, 00:00
occupied
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Tue, Mar 12, 2024, 00:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Wed, Mar 13, 2024, 00:00
occupied
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Wed, Mar 13, 2024, 00:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Thu, Mar 14, 2024, 00:00
occupied
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Thu, Mar 14, 2024, 00:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Fri, Mar 15, 2024, 00:00
occupied
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Fri, Mar 15, 2024, 00:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Sat, Mar 16, 2024, 00:00
end
Room 5 | 10 places to sit
Hélène Dubois
Check-in for:
1 week 10 hrs
Sat, Mar 9, 2024, 07:00 →
Sat, Mar 16, 2024
3/16/2024, 5:00 PM
Sat, Mar 16, 2024, 00:00 Room 5 | 10 places to sit → Hélène Dubois
normal reservation
Sat, Mar 16, 2024, 12:30
short slot
Room 4 | 6 places to sit
Maria
Check-in for:
4 hrs
Sat, Mar 16, 2024, 12:30 →
Sat, Mar 16, 2024
3/16/2024, 4:30 PM
Sat, Mar 16, 2024, 12:30 Room 4 | 6 places to sit → Maria
normal reservation
Mon, Mar 18, 2024, 09:30
short slot
Room 6 | 10 places to sit
Gerdine
Check-in for:
2 hrs 30 mins
Mon, Mar 18, 2024, 09:30 →
Mon, Mar 18, 2024
3/18/2024, 12:00 PM
Mon, Mar 18, 2024, 09:30 Room 6 | 10 places to sit → Gerdine
normal reservation
Fri, Oct 25, 2024, 11:00
short slot
Room 4 | 6 places to sit
Christiaan
Check-in for:
1 hr
Fri, Oct 25, 2024, 11:00 →
Fri, Oct 25, 2024
10/25/2024, 12:00 PM
Fri, Oct 25, 2024, 11:00 Room 4 | 6 places to sit → Christiaan
normal reservation
Mon, Oct 6, 2025, 10:00
short slot
Room 4 | 6 places to sit
Jozefien Laflare
Check-in for:
4 hrs
Mon, Oct 6, 2025, 10:00 →
Mon, Oct 6, 2025
10/6/2025, 2:00 PM
Mon, Oct 6, 2025, 10:00 Room 4 | 6 places to sit → Jozefien Laflare
normal reservation
Fri, Mar 20, 2026, 08:00
short slot
Room 1 | 8 places to sit
test
Check-in for:
9 hrs
Fri, Mar 20, 2026, 08:00 →
Fri, Mar 20, 2026
3/20/2026, 5:00 PM
Fri, Mar 20, 2026, 08:00 Room 1 | 8 places to sit → test
normal reservation
Sat, Apr 25, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Sat, Apr 25, 2026, 09:00 →
Sat, Apr 25, 2026
4/25/2026, 10:30 AM
Sat, Apr 25, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Sat, Apr 25, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Sat, Apr 25, 2026, 11:00 →
Sat, Apr 25, 2026
4/25/2026, 12:30 PM
Sat, Apr 25, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Sat, Apr 25, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Sat, Apr 25, 2026, 13:00 →
Sat, Apr 25, 2026
4/25/2026, 2:30 PM
Sat, Apr 25, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Sat, Apr 25, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Sat, Apr 25, 2026, 15:00 →
Sat, Apr 25, 2026
4/25/2026, 4:30 PM
Sat, Apr 25, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Sun, Apr 26, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Sun, Apr 26, 2026, 09:00 →
Sun, Apr 26, 2026
4/26/2026, 10:30 AM
Sun, Apr 26, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Sun, Apr 26, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Sun, Apr 26, 2026, 11:00 →
Sun, Apr 26, 2026
4/26/2026, 12:30 PM
Sun, Apr 26, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Sun, Apr 26, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Sun, Apr 26, 2026, 13:00 →
Sun, Apr 26, 2026
4/26/2026, 2:30 PM
Sun, Apr 26, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Sun, Apr 26, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Sun, Apr 26, 2026, 15:00 →
Sun, Apr 26, 2026
4/26/2026, 4:30 PM
Sun, Apr 26, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Mon, Apr 27, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Mon, Apr 27, 2026, 09:00 →
Mon, Apr 27, 2026
4/27/2026, 10:30 AM
Mon, Apr 27, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Mon, Apr 27, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Mon, Apr 27, 2026, 11:00 →
Mon, Apr 27, 2026
4/27/2026, 12:30 PM
Mon, Apr 27, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Mon, Apr 27, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Mon, Apr 27, 2026, 13:00 →
Mon, Apr 27, 2026
4/27/2026, 2:30 PM
Mon, Apr 27, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Mon, Apr 27, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Mon, Apr 27, 2026, 15:00 →
Mon, Apr 27, 2026
4/27/2026, 4:30 PM
Mon, Apr 27, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Tue, Apr 28, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Tue, Apr 28, 2026, 09:00 →
Tue, Apr 28, 2026
4/28/2026, 10:30 AM
Tue, Apr 28, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Tue, Apr 28, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Tue, Apr 28, 2026, 11:00 →
Tue, Apr 28, 2026
4/28/2026, 12:30 PM
Tue, Apr 28, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Tue, Apr 28, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Tue, Apr 28, 2026, 13:00 →
Tue, Apr 28, 2026
4/28/2026, 2:30 PM
Tue, Apr 28, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Tue, Apr 28, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Tue, Apr 28, 2026, 15:00 →
Tue, Apr 28, 2026
4/28/2026, 4:30 PM
Tue, Apr 28, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Wed, Apr 29, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Wed, Apr 29, 2026, 09:00 →
Wed, Apr 29, 2026
4/29/2026, 10:30 AM
Wed, Apr 29, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Wed, Apr 29, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Wed, Apr 29, 2026, 11:00 →
Wed, Apr 29, 2026
4/29/2026, 12:30 PM
Wed, Apr 29, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Wed, Apr 29, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Wed, Apr 29, 2026, 13:00 →
Wed, Apr 29, 2026
4/29/2026, 2:30 PM
Wed, Apr 29, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Wed, Apr 29, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Wed, Apr 29, 2026, 15:00 →
Wed, Apr 29, 2026
4/29/2026, 4:30 PM
Wed, Apr 29, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Thu, Apr 30, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Thu, Apr 30, 2026, 09:00 →
Thu, Apr 30, 2026
4/30/2026, 10:30 AM
Thu, Apr 30, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Thu, Apr 30, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Thu, Apr 30, 2026, 11:00 →
Thu, Apr 30, 2026
4/30/2026, 12:30 PM
Thu, Apr 30, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Thu, Apr 30, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Thu, Apr 30, 2026, 13:00 →
Thu, Apr 30, 2026
4/30/2026, 2:30 PM
Thu, Apr 30, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Thu, Apr 30, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Thu, Apr 30, 2026, 15:00 →
Thu, Apr 30, 2026
4/30/2026, 4:30 PM
Thu, Apr 30, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Fri, May 1, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Fri, May 1, 2026, 09:00 →
Fri, May 1, 2026
5/1/2026, 10:30 AM
Fri, May 1, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Fri, May 1, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Fri, May 1, 2026, 11:00 →
Fri, May 1, 2026
5/1/2026, 12:30 PM
Fri, May 1, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Fri, May 1, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Fri, May 1, 2026, 13:00 →
Fri, May 1, 2026
5/1/2026, 2:30 PM
Fri, May 1, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Fri, May 1, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Fri, May 1, 2026, 15:00 →
Fri, May 1, 2026
5/1/2026, 4:30 PM
Fri, May 1, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Sat, May 2, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Sat, May 2, 2026, 09:00 →
Sat, May 2, 2026
5/2/2026, 10:30 AM
Sat, May 2, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Sat, May 2, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Sat, May 2, 2026, 11:00 →
Sat, May 2, 2026
5/2/2026, 12:30 PM
Sat, May 2, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Sat, May 2, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Sat, May 2, 2026, 13:00 →
Sat, May 2, 2026
5/2/2026, 2:30 PM
Sat, May 2, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Sat, May 2, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Sat, May 2, 2026, 15:00 →
Sat, May 2, 2026
5/2/2026, 4:30 PM
Sat, May 2, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Sun, May 3, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Sun, May 3, 2026, 09:00 →
Sun, May 3, 2026
5/3/2026, 10:30 AM
Sun, May 3, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Sun, May 3, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Sun, May 3, 2026, 11:00 →
Sun, May 3, 2026
5/3/2026, 12:30 PM
Sun, May 3, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Sun, May 3, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Sun, May 3, 2026, 13:00 →
Sun, May 3, 2026
5/3/2026, 2:30 PM
Sun, May 3, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Sun, May 3, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Sun, May 3, 2026, 15:00 →
Sun, May 3, 2026
5/3/2026, 4:30 PM
Sun, May 3, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
Mon, May 4, 2026, 09:00
short slot
Room 1 | 8 places to sit
Alice Smith
Check-in for:
1 hr 30 mins
Mon, May 4, 2026, 09:00 →
Mon, May 4, 2026
5/4/2026, 10:30 AM
Mon, May 4, 2026, 09:00 Room 1 | 8 places to sit → Alice Smith
normal reservation
Mon, May 4, 2026, 11:00
short slot
Room 2 | 16 places to sit
Bob Smith
Check-in for:
1 hr 30 mins
Mon, May 4, 2026, 11:00 →
Mon, May 4, 2026
5/4/2026, 12:30 PM
Mon, May 4, 2026, 11:00 Room 2 | 16 places to sit → Bob Smith
normal reservation
Mon, May 4, 2026, 13:00
short slot
Room 3 | 12 places to sit
Charlie Smith
Check-in for:
1 hr 30 mins
Mon, May 4, 2026, 13:00 →
Mon, May 4, 2026
5/4/2026, 2:30 PM
Mon, May 4, 2026, 13:00 Room 3 | 12 places to sit → Charlie Smith
normal reservation
Mon, May 4, 2026, 15:00
short slot
Room 4 | 6 places to sit
Diana Smith
Check-in for:
1 hr 30 mins
Mon, May 4, 2026, 15:00 →
Mon, May 4, 2026
5/4/2026, 4:30 PM
Mon, May 4, 2026, 15:00 Room 4 | 6 places to sit → Diana Smith
normal reservation
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.