This is a dashboard (custom website view) of the 'Event Marketing' sample Airtable base. The purpose is to illustrate how Airtable database content can be displayed on a website. Here I designed an event calendar for people to learn about upcoming events and sign up for them. Of course this is only one way of many to interpret the Airtable spreadsheet data for a such a website.
This implementation uses two web page layouts. The index page simply lists each event with a date and type. A screenshot:
Clicking on an event title leads to a detail page for the event. This layout is similar to most blog presentations.
The Event Marketing base is from the collection 'Templates for Web Professionals'. These templates are available courtesy of Amy Keys in the Facebook group, 'Airtable for Web Professionals'. Search Facebook for the group and request to join.
The base has four tables: Events, Venues, VIPs, and Attendence. The individual event data is pulled from the Events table. The locations of each event links to the Venues table. This is where the event address and photos come from. I didn't use the other tables that list attendees. That info would not be appropriate for an announcement website.
Here is a screenshot of one of the event details pages:
For fun, I added venue directions using google maps for the venues. These are iframes which only need a full venue address as a parameter, and that is available from the Venues table.
From the Attendence table, I used the Share Form feature to have a way to collect RSVPs. The iframe is embedded to simulate what RSVP functionality could look like to collect emails. This will insert the user's email into the database, as well as forward the email to the Airtable account owner.
This was designed as a static website, so it is fast and simple to host. The pages are generated offline by a python3 program that pulls the content through the Airtable API. The index and event page data is then integrated with custom page templates and downloaded images. Lastly the complete set is uploaded to a CDN deployment.
Building offline takes a little time, because the Airtable API takes several seconds, photos are downloaded, and the page is assembled. However the web page visitor doesn't have to wait for the delays because only static pages and resources are delivered to the browser. Static websites are fast and secure. There is no code or passwords or programs on the website to be hacked.
You can demo the hosted static dashboard here.