This city tour scheduling template is designed to offer a convenient and organized way for users to explore urban highlights. With an easy-to-configure database, you can create customized city tours that pass through multiple landmarks, points of interest, or historical sites. Whether you’re managing tours for tourists or locals, this template simplifies the process by letting users select tours from a pre-defined list and view all the highlights on an interactive map.
The application’s intuitive interface ensures that users can easily browse through available tours, see detailed information about each stop, and follow the route in real-time using map visuals. The backend is equally user-friendly, allowing you to manage tour details, times, and locations with minimal effort. This template is perfect for tour operators, city guides, or anyone looking to provide a smooth, memorable sightseeing experience. From planning to navigating, this solution covers every aspect, ensuring both efficiency and an enjoyable journey for your customers.
The database of this template is pretty straight forward. Cities can have one multiple Tours, where Tours can have one - but mostly - multiple Highlights. Each highlight can be reused in multiple Tours.
Each highlight has a position which is the combination of their latitude and longitude. Those Latitude and Longitude fields are the only ones that need to be set manually by the user. All the other fields like Position, Waypoint and Marker are automatically calculated by a formula. The purpose of those field is to be able to create a map that automatically calculates the most optimal route between all the highlights of this tour.
The application is designed so that it is easy to use on mobile devices. The first screen offers an overview of all the cities. Selecting a city shows an overview of all the available tours in that city. Selecting a tour shows all the highlights of that tour, both on a map and in a list. A highlight can be selected by either clicking the pinpoint on the map or the details button in the list.
The top bar provides buttons that allow to return to any screen in the application.
Database: City Tours
Cities
Fields
-
Name (Text)
-
Tours (Link to table)
-
Cover (File)
-
Count tours (Count)
Views
-
All cities (grid)
-
Cities with multiple tours (grid)
-
Gallery: all cities (gallery)
Tours
Fields
-
Name (Text)
-
Description (Long text)
-
Transportation (Single select)
-
Highlights (Link to table)
-
Duration in hours (Number)
-
City (Link to table)
-
Cover (Formula)
-
Count highlights (Count)
-
Transport icon (Formula)
-
Transport text (Formula)
-
Waypoints (Formula)
-
Center point (Formula)
-
Markers (Formula)
-
City name (Rollup)
Views
-
All tours (grid)
-
All tours grouped by city (grid)
-
All tours grouped by transportation type (grid)
-
Tours >= 3 hours (grid)
-
Tours < 3 hours (grid)
-
Tours >= 6 highlights (grid)
-
Tours < 6 highlights (grid)
-
By transportation type (kanban)
Highlights
Fields
-
Name (Text)
-
Description (Long text)
-
Cover image (File)
-
Longitude (Number)
-
Latitude (Number)
-
Part of tours (Link to table)
-
Type (Single select)
-
Fun fact (Text)
-
Type icon (Formula)
-
Type text (Formula)
-
Position (Formula)
-
Waypoint (Formula)
-
Marker (Formula)
-
ID (Formula)
-
City (Rollup)
Views
-
All highlights (grid)
-
All highlights grouped by city (grid)
-
All highlights grouped by city and type (grid)
-
Gallery: All highlights (gallery)
-
By type (kanban)
-
Add new highlight (form)
Application: City Tours
Homepage
Data sources
- Cities
Tours
Data sources
-
City
-
Tours
Tour details
Data sources
-
Tour
-
Highlights
Highlights details
Data sources
-
Tour
-
Highlight
-
Tours