Skip to content
Gallery
Coda template room reservations
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 buttonin 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
nights
room
contact
cardLine01
endDate
key
Name
status
Wed, Feb 14, 2024, 16:00
1 night
Check-in for 1 night
⁠
Wed, Feb 14, 2024, 16:00⁠
→
⁠
Thu, Feb 15, 2024, 10:00⁠
⁠
2/15/2024, 10:00 AM
i-HA1u6-6EEP
⁠
Wed, Feb 14, 2024, 16:00⁠
Room 4 |
2⁠
places to sleep → Lea Nielsen
Thu, Feb 15, 2024, 10:00
1 night
Check-in for 1 night
⁠
Wed, Feb 14, 2024, 16:00⁠
→
⁠
Thu, Feb 15, 2024, 10:00⁠
⁠
2/15/2024, 10:00 AM
i-HA1u6-6EEP
⁠
Thu, Feb 15, 2024, 10:00⁠
Room 4 |
2⁠
places to sleep → Lea Nielsen
Thu, Feb 15, 2024, 15:30
1 night
Check-in for 1 night
⁠
Thu, Feb 15, 2024, 15:30⁠
→
⁠
Fri, Feb 16, 2024, 09:30⁠
⁠
2/16/2024, 9:30 AM
i-Kzdprx5f_l
⁠
Thu, Feb 15, 2024, 15:30⁠
Room 3 |
4⁠
places to sleep → David
Fri, Feb 16, 2024, 09:30
1 night
Check-in for 1 night
⁠
Thu, Feb 15, 2024, 15:30⁠
→
⁠
Fri, Feb 16, 2024, 09:30⁠
⁠
2/16/2024, 9:30 AM
i-Kzdprx5f_l
⁠
Fri, Feb 16, 2024, 09:30⁠
Room 3 |
4⁠
places to sleep → David
Thu, Feb 15, 2024, 16:00
1 night
Check-in for 1 night
⁠
Thu, Feb 15, 2024, 16:00⁠
→
⁠
Fri, Feb 16, 2024, 10:00⁠
⁠
2/16/2024, 10:00 AM
i-qD3-daxcNV
⁠
Thu, Feb 15, 2024, 16:00⁠
Room 4 |
2⁠
places to sleep → Jan Novák
Fri, Feb 16, 2024, 10:00
1 night
Check-in for 1 night
⁠
Thu, Feb 15, 2024, 16:00⁠
→
⁠
Fri, Feb 16, 2024, 10:00⁠
⁠
2/16/2024, 10:00 AM
i-qD3-daxcNV
⁠
Fri, Feb 16, 2024, 10:00⁠
Room 4 |
2⁠
places to sleep → Jan Novák
Fri, Feb 16, 2024, 15:30
1 night
Check-in for 1 night
⁠
Fri, Feb 16, 2024, 15:30⁠
→
⁠
Sat, Feb 17, 2024, 09:30⁠
⁠
2/17/2024, 9:30 AM
i-fs2Ii7F3Hq
⁠
Fri, Feb 16, 2024, 15:30⁠
Room 3 |
4⁠
places to sleep → Laura
Sat, Feb 17, 2024, 09:30
1 night
Check-in for 1 night
⁠
Fri, Feb 16, 2024, 15:30⁠
→
⁠
Sat, Feb 17, 2024, 09:30⁠
⁠
2/17/2024, 9:30 AM
i-fs2Ii7F3Hq
⁠
Sat, Feb 17, 2024, 09:30⁠
Room 3 |
4⁠
places to sleep → Laura
Wed, Feb 14, 2024, 16:00
4 nights
Check-in for 4 nights
⁠
Wed, Feb 14, 2024, 16:00⁠
→
⁠
Sun, Feb 18, 2024, 11:00⁠
⁠
2/18/2024, 11:00 AM
i--HwP4HCm-O
⁠
Wed, Feb 14, 2024, 16:00⁠
Room 1 |
5⁠
places to sleep → Martina
Thu, Feb 15, 2024, 00:00
4 nights
Check-in for 4 nights
⁠
Wed, Feb 14, 2024, 16:00⁠
→
⁠
Sun, Feb 18, 2024, 11:00⁠
⁠
2/18/2024, 11:00 AM
i--HwP4HCm-O
⁠
Thu, Feb 15, 2024, 00:00⁠
Room 1 |
5⁠
places to sleep → Martina
Fri, Feb 16, 2024, 00:00
4 nights
Check-in for 4 nights
⁠
Wed, Feb 14, 2024, 16:00⁠
→
⁠
Sun, Feb 18, 2024, 11:00⁠
⁠
2/18/2024, 11:00 AM
i--HwP4HCm-O
⁠
Fri, Feb 16, 2024, 00:00⁠
Room 1 |
5⁠
places to sleep → Martina
Sat, Feb 17, 2024, 00:00
4 nights
Check-in for 4 nights
⁠
Wed, Feb 14, 2024, 16:00⁠
→
⁠
Sun, Feb 18, 2024, 11:00⁠
⁠
2/18/2024, 11:00 AM
i--HwP4HCm-O
⁠
Sat, Feb 17, 2024, 00:00⁠
Room 1 |
5⁠
places to sleep → Martina
Sun, Feb 18, 2024, 11:00
4 nights
Check-in for 4 nights
⁠
Wed, Feb 14, 2024, 16:00⁠
→
⁠
Sun, Feb 18, 2024, 11:00⁠
⁠
2/18/2024, 11:00 AM
i--HwP4HCm-O
⁠
Sun, Feb 18, 2024, 11:00⁠
Room 1 |
5⁠
places to sleep → Martina
Sat, Feb 17, 2024, 15:30
2 nights
Check-in for 2 nights
⁠
Sat, Feb 17, 2024, 15:30⁠
→
⁠
Mon, Feb 19, 2024, 09:30⁠
⁠
2/19/2024, 9:30 AM
i-g0T4oswjw1
⁠
Sat, Feb 17, 2024, 15:30⁠
Room 3 |
4⁠
places to sleep → Lucia
Sun, Feb 18, 2024, 00:00
2 nights
Check-in for 2 nights
⁠
Sat, Feb 17, 2024, 15:30⁠
→
⁠
Mon, Feb 19, 2024, 09:30⁠
⁠
2/19/2024, 9:30 AM
i-g0T4oswjw1
⁠
Sun, Feb 18, 2024, 00:00⁠
Room 3 |
4⁠
places to sleep → Lucia
Mon, Feb 19, 2024, 09:30
2 nights
Check-in for 2 nights
⁠
Sat, Feb 17, 2024, 15:30⁠
→
⁠
Mon, Feb 19, 2024, 09:30⁠
⁠
2/19/2024, 9:30 AM
i-g0T4oswjw1
⁠
Mon, Feb 19, 2024, 09:30⁠
Room 3 |
4⁠
places to sleep → Lucia
Sun, Feb 18, 2024, 16:00
1 night
Check-in for 1 night
⁠
Sun, Feb 18, 2024, 16:00⁠
→
⁠
Mon, Feb 19, 2024, 11:00⁠
⁠
2/19/2024, 11:00 AM
i-OW7YjGBIPA
⁠
Sun, Feb 18, 2024, 16:00⁠
Room 1 |
5⁠
places to sleep → Jana
Mon, Feb 19, 2024, 11:00
1 night
Check-in for 1 night
⁠
Sun, Feb 18, 2024, 16:00⁠
→
⁠
Mon, Feb 19, 2024, 11:00⁠
⁠
2/19/2024, 11:00 AM
i-OW7YjGBIPA
⁠
Mon, Feb 19, 2024, 11:00⁠
Room 1 |
5⁠
places to sleep → Jana
Thu, Feb 29, 2024, 16:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 10:00
3/3/2024, 10:00 AM
i-0QStO3b_z9
Thu, Feb 29, 2024, 16:00 Room 4 | 2 places to sleep → Jana Varga
Fri, Mar 1, 2024, 00:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 10:00
3/3/2024, 10:00 AM
i-0QStO3b_z9
Fri, Mar 1, 2024, 00:00 Room 4 | 2 places to sleep → Jana Varga
Sat, Mar 2, 2024, 00:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 10:00
3/3/2024, 10:00 AM
i-0QStO3b_z9
Sat, Mar 2, 2024, 00:00 Room 4 | 2 places to sleep → Jana Varga
Sun, Mar 3, 2024, 10:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 10:00
3/3/2024, 10:00 AM
i-0QStO3b_z9
Sun, Mar 3, 2024, 10:00 Room 4 | 2 places to sleep → Jana Varga
Thu, Feb 29, 2024, 16:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 11:00
3/3/2024, 11:00 AM
i-GkR5C0blo4
Thu, Feb 29, 2024, 16:00 Room 1 | 5 places to sleep → Maria García
Fri, Mar 1, 2024, 00:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 11:00
3/3/2024, 11:00 AM
i-GkR5C0blo4
Fri, Mar 1, 2024, 00:00 Room 1 | 5 places to sleep → Maria García
Sat, Mar 2, 2024, 00:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 11:00
3/3/2024, 11:00 AM
i-GkR5C0blo4
Sat, Mar 2, 2024, 00:00 Room 1 | 5 places to sleep → Maria García
Sun, Mar 3, 2024, 11:00
3 nights
Check-in for 3 nights
Thu, Feb 29, 2024, 16:00 →
Sun, Mar 3, 2024, 11:00
3/3/2024, 11:00 AM
i-GkR5C0blo4
Sun, Mar 3, 2024, 11:00 Room 1 | 5 places to sleep → Maria García
Thu, Feb 29, 2024, 15:00
4 nights
Check-in for 4 nights
Thu, Feb 29, 2024, 15:00 →
Mon, Mar 4, 2024, 10:30
3/4/2024, 10:30 AM
i-g9jb4QWwAF
Thu, Feb 29, 2024, 15:00 Room 2 | 3 places to sleep → Manuel Fernández
Fri, Mar 1, 2024, 00:00
4 nights
Check-in for 4 nights
Thu, Feb 29, 2024, 15:00 →
Mon, Mar 4, 2024, 10:30
3/4/2024, 10:30 AM
i-g9jb4QWwAF
Fri, Mar 1, 2024, 00:00 Room 2 | 3 places to sleep → Manuel Fernández
Sat, Mar 2, 2024, 00:00
4 nights
Check-in for 4 nights
Thu, Feb 29, 2024, 15:00 →
Mon, Mar 4, 2024, 10:30
3/4/2024, 10:30 AM
i-g9jb4QWwAF
Sat, Mar 2, 2024, 00:00 Room 2 | 3 places to sleep → Manuel Fernández
Sun, Mar 3, 2024, 00:00
4 nights
Check-in for 4 nights
Thu, Feb 29, 2024, 15:00 →
Mon, Mar 4, 2024, 10:30
3/4/2024, 10:30 AM
i-g9jb4QWwAF
Sun, Mar 3, 2024, 00:00 Room 2 | 3 places to sleep → Manuel Fernández
Mon, Mar 4, 2024, 10:30
4 nights
Check-in for 4 nights
Thu, Feb 29, 2024, 15:00 →
Mon, Mar 4, 2024, 10:30
3/4/2024, 10:30 AM
i-g9jb4QWwAF
Mon, Mar 4, 2024, 10:30 Room 2 | 3 places to sleep → Manuel Fernández
Sun, Mar 3, 2024, 16:00
2 nights
Check-in for 2 nights
Sun, Mar 3, 2024, 16:00 →
Tue, Mar 5, 2024, 11:00
3/5/2024, 11:00 AM
i-5eHUoJa1H0
Sun, Mar 3, 2024, 16:00 Room 1 | 5 places to sleep → Tereza Nováková
Mon, Mar 4, 2024, 00:00
2 nights
Check-in for 2 nights
Sun, Mar 3, 2024, 16:00 →
Tue, Mar 5, 2024, 11:00
3/5/2024, 11:00 AM
i-5eHUoJa1H0
Mon, Mar 4, 2024, 00:00 Room 1 | 5 places to sleep → Tereza Nováková
Tue, Mar 5, 2024, 11:00
2 nights
Check-in for 2 nights
Sun, Mar 3, 2024, 16:00 →
Tue, Mar 5, 2024, 11:00
3/5/2024, 11:00 AM
i-5eHUoJa1H0
Tue, Mar 5, 2024, 11:00 Room 1 | 5 places to sleep → Tereza Nováková
Sun, Mar 3, 2024, 16:00
3 nights
Check-in for 3 nights
Sun, Mar 3, 2024, 16:00 →
Wed, Mar 6, 2024, 10:00
3/6/2024, 10:00 AM
i-cE9s8nHZDR
Sun, Mar 3, 2024, 16:00 Room 4 | 2 places to sleep → Laura Müller
Mon, Mar 4, 2024, 00:00
3 nights
Check-in for 3 nights
Sun, Mar 3, 2024, 16:00 →
Wed, Mar 6, 2024, 10:00
3/6/2024, 10:00 AM
i-cE9s8nHZDR
Mon, Mar 4, 2024, 00:00 Room 4 | 2 places to sleep → Laura Müller
Tue, Mar 5, 2024, 00:00
3 nights
Check-in for 3 nights
Sun, Mar 3, 2024, 16:00 →
Wed, Mar 6, 2024, 10:00
3/6/2024, 10:00 AM
i-cE9s8nHZDR
Tue, Mar 5, 2024, 00:00 Room 4 | 2 places to sleep → Laura Müller
Wed, Mar 6, 2024, 10:00
3 nights
Check-in for 3 nights
Sun, Mar 3, 2024, 16:00 →
Wed, Mar 6, 2024, 10:00
3/6/2024, 10:00 AM
i-cE9s8nHZDR
Wed, Mar 6, 2024, 10:00 Room 4 | 2 places to sleep → Laura Müller
Wed, Mar 6, 2024, 15:30
1 night
Check-in for 1 night
Wed, Mar 6, 2024, 15:30 →
Thu, Mar 7, 2024, 09:30
3/7/2024, 9:30 AM
i-lHx2QqW6v0
Wed, Mar 6, 2024, 15:30 Room 3 | 4 places to sleep → André Lejeune
Thu, Mar 7, 2024, 09:30
1 night
Check-in for 1 night
Wed, Mar 6, 2024, 15:30 →
Thu, Mar 7, 2024, 09:30
3/7/2024, 9:30 AM
i-lHx2QqW6v0
Thu, Mar 7, 2024, 09:30 Room 3 | 4 places to sleep → André Lejeune
Wed, Mar 6, 2024, 16:00
4 nights
Check-in for 4 nights
Wed, Mar 6, 2024, 16:00 →
Sun, Mar 10, 2024, 11:00
3/10/2024, 11:00 AM
i-av3KbPAgeI
Wed, Mar 6, 2024, 16:00 Room 1 | 5 places to sleep → Marco Rossi
Thu, Mar 7, 2024, 00:00
4 nights
Check-in for 4 nights
Wed, Mar 6, 2024, 16:00 →
Sun, Mar 10, 2024, 11:00
3/10/2024, 11:00 AM
i-av3KbPAgeI
Thu, Mar 7, 2024, 00:00 Room 1 | 5 places to sleep → Marco Rossi
Fri, Mar 8, 2024, 00:00
4 nights
Check-in for 4 nights
Wed, Mar 6, 2024, 16:00 →
Sun, Mar 10, 2024, 11:00
3/10/2024, 11:00 AM
i-av3KbPAgeI
Fri, Mar 8, 2024, 00:00 Room 1 | 5 places to sleep → Marco Rossi
Sat, Mar 9, 2024, 00:00
4 nights
Check-in for 4 nights
Wed, Mar 6, 2024, 16:00 →
Sun, Mar 10, 2024, 11:00
3/10/2024, 11:00 AM
i-av3KbPAgeI
Sat, Mar 9, 2024, 00:00 Room 1 | 5 places to sleep → Marco Rossi
Sun, Mar 10, 2024, 11:00
4 nights
Check-in for 4 nights
Wed, Mar 6, 2024, 16:00 →
Sun, Mar 10, 2024, 11:00
3/10/2024, 11:00 AM
i-av3KbPAgeI
Sun, Mar 10, 2024, 11:00 Room 1 | 5 places to sleep → Marco Rossi
Sun, Mar 10, 2024, 16:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Sun, Mar 10, 2024, 16:00 Room 4 | 2 places to sleep → Marco Rossi
Mon, Mar 11, 2024, 00:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Mon, Mar 11, 2024, 00:00 Room 4 | 2 places to sleep → Marco Rossi
Tue, Mar 12, 2024, 00:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Tue, Mar 12, 2024, 00:00 Room 4 | 2 places to sleep → Marco Rossi
Wed, Mar 13, 2024, 00:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Wed, Mar 13, 2024, 00:00 Room 4 | 2 places to sleep → Marco Rossi
Thu, Mar 14, 2024, 00:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Thu, Mar 14, 2024, 00:00 Room 4 | 2 places to sleep → Marco Rossi
Fri, Mar 15, 2024, 00:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Fri, Mar 15, 2024, 00:00 Room 4 | 2 places to sleep → Marco Rossi
Sat, Mar 16, 2024, 00:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Sat, Mar 16, 2024, 00:00 Room 4 | 2 places to sleep → Marco Rossi
Sun, Mar 17, 2024, 00:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Sun, Mar 17, 2024, 00:00 Room 4 | 2 places to sleep → Marco Rossi
Mon, Mar 18, 2024, 10:00
8 nights
Check-in for 8 nights
Sun, Mar 10, 2024, 16:00 →
Mon, Mar 18, 2024, 10:00
3/18/2024, 10:00 AM
i-tZdZTJ_8pv
Mon, Mar 18, 2024, 10:00 Room 4 | 2 places to sleep → Marco Rossi
Mon, Mar 18, 2024, 16:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Mon, Mar 18, 2024, 16:00 Room 4 | 2 places to sleep → Katarina Kovač
Tue, Mar 19, 2024, 00:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Tue, Mar 19, 2024, 00:00 Room 4 | 2 places to sleep → Katarina Kovač
Wed, Mar 20, 2024, 00:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Wed, Mar 20, 2024, 00:00 Room 4 | 2 places to sleep → Katarina Kovač
Thu, Mar 21, 2024, 00:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Thu, Mar 21, 2024, 00:00 Room 4 | 2 places to sleep → Katarina Kovač
Fri, Mar 22, 2024, 00:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Fri, Mar 22, 2024, 00:00 Room 4 | 2 places to sleep → Katarina Kovač
Sat, Mar 23, 2024, 00:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Sat, Mar 23, 2024, 00:00 Room 4 | 2 places to sleep → Katarina Kovač
Sun, Mar 24, 2024, 00:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Sun, Mar 24, 2024, 00:00 Room 4 | 2 places to sleep → Katarina Kovač
Mon, Mar 25, 2024, 00:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Mon, Mar 25, 2024, 00:00 Room 4 | 2 places to sleep → Katarina Kovač
Tue, Mar 26, 2024, 10:00
8 nights
Check-in for 8 nights
Mon, Mar 18, 2024, 16:00 →
Tue, Mar 26, 2024, 10:00
3/26/2024, 10:00 AM
i-l2HnLQKe0i
Tue, Mar 26, 2024, 10:00 Room 4 | 2 places to sleep → Katarina Kovač
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.