Skip to content
Gallery
Coda template meeting room reservations
Meeting room reservations
Dashboard
Share
Explore
DB Reservations

icon picker
DB Past Reservations

Keep track of your past in a seperate table.
filled-star

Why we need this table?

To keep the main table
DB Reservations
⁠
fast. The fewer the rows, the faster (in miliseconds) the code in the button can be executed.
we keep the data in
DB Reservations
⁠
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()

How is this table filled?

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 reservations
May this feel complicated, you can replicate the logic in a button in a table and use the automation only to push the buttons.

Extra

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.


DB Past Reservations
startDate
i
checks
room
contact
cardLine01
endDate
Name
status
1
Mon, Mar 4, 2024, 07:30
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
2
Tue, Mar 5, 2024, 09:00
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
3
Thu, Mar 7, 2024, 07:00
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
4
Fri, Mar 8, 2024, 05:30
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
5
Sat, Mar 9, 2024, 00:00
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
6
Sun, Mar 10, 2024, 00:00
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
7
Tue, Mar 12, 2024, 07:30
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
8
Wed, Mar 13, 2024, 11:00
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
9
Sat, Mar 9, 2024, 07:00
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
10
Sun, Mar 10, 2024, 00:00
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
11
Mon, Mar 11, 2024, 00:00
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
12
Tue, Mar 12, 2024, 00:00
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
13
Wed, Mar 13, 2024, 00:00
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
14
Thu, Mar 14, 2024, 00:00
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
15
Fri, Mar 15, 2024, 00:00
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
16
Sat, Mar 16, 2024, 00:00
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
17
Sat, Mar 16, 2024, 12:30
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
18
Mon, Mar 18, 2024, 09:30
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
19
Fri, Oct 25, 2024, 11:00
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
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.