Databases | Summary
In total there are 4 databases in this template
Database (1) | Trips
This database holds all the trips created.
Properties
Property | Property Type | Notes | Update property? |
Name | Title | Name of the trip | On trip creation. |
Trip Stage | Multi-select | Tag the state of the trip:
- Dreaming
- Potential
- Confirmed | Update on trip creation and when/if the status changes. |
Trip Dates | Date | The proposed dates of the trip. | Update on trip creation and when/if the dates change.
Be sure to enter the start and end date. |
Region | Multi-select | The region the countries to be visited on trip are from. | Update on trip creation and when/if the region changes. |
Country | Multi-select | The country or countries to be visited on the trip. | Update on trip creation and when/if the countries change. |
Cities | Rollup | This is a rollup property that will appear automatically based on the cities entered in the itinerary database. | Update via the itinerary database. |
Trip Status | Formula | A formula based on the entered trip dates with three status updates:
- #days until the trip starts
- Trip is underway
- #days since the trip ended | Updates automatically as long as the trip start and end date property has been entered. |
Documents | Relation | A relation to the associated documents for this trip. | This will automatically populate once you tag it in the documents database. |
Itinerary | Relation | A relation to the associated itinerary for this trip. | This will automatically populate once you tag it in the itinerary database. |
Journal | Relation | A relation to the associated journal entry for this trip. | This will automatically populate once you tag it in the itinerary database. |
Formulas
Property:
Trip Status
Database (2) | Itinerary
This database holds all the itinerary items created across all trips.
Properties
Property | Property Type | Notes | Update property? |
Itinerary item | Title | Name of the item being entered into the itinerary. e.g. hotel, cafe, sight. | On creation. |
City | Multi-Select | The city that this itinerary item is in. | On creation. |
Date to visit | Date | Proposed or planned date to visit the itinerary item. | On creation and update if changes. |
Photos & links | Files & Media | Any attached photos or links relating to the itinerary item. | Update during research and after visiting. |
Notes | Text | Any quick notes about the itinerary item for reference. | Update during research and after visiting. |
Price | Number | The price to visit, see, stay, ride or dine at the itinerary item.
Adjust the currency by hovering the left-hand side of the property box. | Update during research and after visiting. |
Who paid? | Multi-Select | A drop-down list to select the person or people who paid. | Update during research and after purchase. |
Trip | Relation | A relation to the associated trip for this itinerary.
| This will automatically populate. |
Database (3) | Travel Journal
This database holds all the journal entries created across all trips.
Properties
Property Name | Property Type | Notes | Update property? |
Name | Title | The name of the journal entry. e.g. "Day 1", "01/01/01", "First day in Paris". | On creation. |
Journal Date | Date | The date of the journal entry. | On creation. |
Trip | Relation | A relation to the associated trip for this journal.
| This will automatically populate unless you create the document via the small blue drop down arrow / template button. If so you will have to manually enter it. |
Database (4) | Travel Documents
This database holds all the documents created across all trips.
Properties
Property Name | Property Type | Notes | Update property? |
Name | Title | The name of the document | On creation. |
Document Type | Multi-Select | A drop-down list to tag the type of document being entered. | On creation. |
Link | File | Photo | Files & Media | Attached URL link, file or photo of the mentioned document. | On creation. |
Trip | Relation | A relation to the associated trip for this travel document.
| This will automatically populate unless you create the document via the small blue drop down arrow / template button. If so you will have to manually enter it. |
Trip Status | Rollup | A rollup property that shows the trip status update.
This is used to filter the database on the homepage to quickly access required documents. | Automatically updates based on Trips database. |
Database (4) | Quick travel to do list
A sync block that appears in all trip pages and on the main dashboard page. Any changes will appear consistent across all pages.
Quick travel to-do list:
Renew passport
Book Airbnb