This template provides the functionality to organize multiple events or multiple editions of a single event. This is because each event is a record in the Events table. You can limit this table to a single record if you only want to organize a single event.

The template has two goals:

1. Scheduling speakers or activities. This information is stored in the Schedules table. Each item in this table has a Start and End time and links to a Venue room. Depending on the type of activity, the table also links to one or more Speakers.
2. Registration for attendees. Attendees can register for one or more events. Each registration is stored in the Registrations table.

Finally, there is a Vendors table. This holds the information about vendors that you might possibly need during the event. For example for catering, hospitality, visuals,…

Each table comes with multiple views allowing you to get the best insights in the data. Explore and customize these predefined table views to make event planning easier and more efficient.

The template also includes an application for the attendees. The Attendees table serves as the user source for this application. Attendees can sign in or can sign up for an account if needed. With this account they can register for one or more events.

Even without registration, they can click on a event to see the entire schedule.

Database: Event planning

Events

Fields

• Name (Text)

• Status (Single select)

• Start Date (Date)

• End Date (Date)

• Schedules (Link to table)

• Venue (Link to table)

• Count registrations (Count)

• Venue (name) (Rollup)

• Sold out % (Formula)

• Registrations (Link to table)

• Code (Text)

• Registration accounts (Formula)

Views

• All events (grid)

• All events grouped by status (grid)

• All events grouped by venue (grid)

• Events open for registration (grid)

• Events without registrations (grid)

• Events with registrations > 50% capacity (grid)

• Events with registrations > 90% capacity (grid)

• Events starting this month (grid)

• Events starting next month (grid)

• Calendar: all events with start date (calendar)

• All events stacked by their status (kanban)

Schedules

Fields

• Title (Text)

• Type (Single select)

• Start (Date)

• End (Date)

• Room (Link to table)

• Events (Link to table)

• Speakers (Link to table)

• Projector (Rollup)

• Internet (Rollup)

• Room (name) (Rollup)

• Event (name) (Rollup)

• Start (format) (Formula)

• End (format) (Formula)

Views

• All schedules (grid)

• All schedules grouped by type (grid)

• All schedules grouped by event and type (grid)

• All schedules grouped by event and room (grid)

• All schedules with speaker(s) (grid)

• All schedules without speaker(s) (grid)

• Calendar: all schedules with start time (calendar)

Venues

Fields

• Name (Text)

• City (Text)

• Website (Url)

• Events (Link to table)

• Count events (Count)

• Venue rooms (Link to table)

• Venue capacity (Rollup)

• Count rooms (Count)

Views

• All venues (grid)

• Venues with multiple events (grid)

• Venues with capacity >= 500 (grid)

• Venues with capacity < 500 (grid)

Speakers

Fields

• Name (Text)

• Company (Text)

• Role (Text)

• Schedules (Link to table)

• Biography (Long text)

• Email (Email)

• Phone (Phone number)

• Expertises (Multiple select)

• Picture (File)

• Count schedules (Count)

• Event name (Rollup)

Views

• All speakers (grid)

• All speakers grouped by event (grid)

• Speakers scheduled multiple times (grid)

• Speakers with C-level job role (grid)

• All speakers (gallery)

Attendees

Fields

• Name (Text)

• Company (Text)

• Job role (Text)

• Email (Email)

• Password (Password)

• Registrations (Link to table)

Views

• All attendees (grid)

Vendors

Fields

• Name (Text)

• Type (Single select)

• Preferred (Boolean)

• Website (Url)

• Contact Name (Text)

• Contact Email (Email)

• Contact Phone (Phone number)

Views

• All vendors (grid)

Venue rooms

Fields

• Name (Text)

• Venue (Link to table)

• Capacity (Number)

• Projection (Boolean)

• Internet (Boolean)

• Venue (name) (Rollup)

• Schedules (Link to table)

Views

• All rooms (grid)

• All rooms grouped by venue (grid)

• Rooms with wired internet (grid)

• Rooms with projection (grid)

• Rooms with projection & wired internet (grid)

• Rooms with capacity < 100 (grid)

• Rooms with capacity >= 100 (grid)

• Rooms with capacity >= 200 (grid)

• Rooms with capacity >= 300 (grid)

• Rooms with capacity >= 400 (grid)

• Rooms with capacity >= 500 (grid)

Registrations

Fields

• Name (Formula)

• Event (Link to table)

• Attendee (Link to table)

• Paid (Boolean)

• Created on (Created on)

• Event (name) (Rollup)

• Attendee e-mail (Rollup)

Views

• All registrations (grid)

• All registrations grouped by event (grid)

• Registrations with open payment (grid)

Application: Attendees App

Homepage

Data sources

• Open for registration

• My registrations

Actions (event)

• logout (click)

Sign in

Data sources

Actions (event)

• open_page (after_login)

Sign up

Data sources

Actions (event)

• create_row (submit)

• notification (submit)

• open_page (submit)

Profile

Data sources

• User

Actions (event)

• open_page (submit)

• update_row (submit)

• notification (submit)

Event details

Data sources

• Event

• Schedules

Actions (event)

• logout (click)

• create_row (click)

• notification (click)

• open_page (click)

Event details (no registration)

Data sources

• Event

• Schedules

Actions (event)

• logout (click)