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

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.