Building an Event Registration app

Hey there! Welcome to Tadabase. In this video, we'll guide you through building an event registration app using our platform. The goal is to create an app that allows users to register for various events while keeping track of the number of registrations and available spots.

To start off, we'll create a new application using our quick start wizard and install an event management application. Once that's done, we'll explore the pre-existing data tables. Our main focus will be on the events table, which stores information about each event.

To enable registration, we'll need to make some modifications. First, we'll create a new data table called "registrations" to store individual registration details for each event. We can also choose to connect registrations to specific users if we want to require account creation.

To set up the registration form, we'll add fields like name and email to gather user information. You can customize this based on your needs. Additionally, we'll add fields in the events table to track registration limits and the number of registrations.

Now, let's move on to the page builder. We'll create a page called "Events" and choose a layout that suits your preference. In this page, we'll use a list component to display the events from the data table. We'll customize the list to show relevant information such as event name, date, time, and registrations remaining.

To allow users to view event details and register, we'll add a record detail page. This page will include a form component to capture registration details. We'll set the form fields as required, such as name and email.

Once we've completed the basic page structure, we can preview it. Users will be able to see a list of events and click on the registration button to access the event details page. There, they can fill out the registration form to register for the event.

To ensure a seamless registration experience, we need to add some validation rules. Firstly, we want to prevent users from registering once all spots are filled. We'll create a page rule that displays a message when the registrations remaining value equals zero.

Additionally, we'll implement a validation rule to prevent users from registering multiple times for the same event. This rule will check for uniqueness based on the provided email address.

Lastly, if you prefer to hide events with no available spots, you can apply a data source filter to the parent level page. By setting the filter to show only records with registrations remaining greater than zero, you can choose whether to display or hide events accordingly.

And there you have it! You've successfully built an event registration app using Tadabase. With this app, users can register for events while ensuring that registration limits are respected and duplicate registrations are prevented.

We hope this video tutorial has been helpful to you. Thank you for watching, and we'll catch you next time. Take care!

Features Discussed:

1. Complex Formulas (Time: 04:00)
   Learn how to calculate and manage event registration limits using a count function to track total registrations per event. For example, you’ll learn to subtract the total registrations from the registration limit to determine how many slots remain available.
2. Validation Rule (Time: 08:24)
   Learn how to prevent users from registering multiple times for the same event and how to block access to a registration page when the event is full. This includes setting up page rules to display a message when registrations are closed and creating validation rules to ensure that a user cannot register for the same event more than once.
3. Page Rule (Time: 09:00)
   Learn how to create a page rule that displays a custom message when event registrations reach zero. For example, learn how to add conditions that check if the remaining registrations are zero and how to implement a validation rule to prevent duplicate registrations by checking for unique emails.
4. Filters (Time: 10:40)
   Learn how to filter events on a parent page to display only those with available registrations. This allows you to hide events that are fully booked, improving the user experience by showing only relevant options.

Transcript Summary

Introduction

Hey everybody, welcome back to Build It with Tadabase. On today's episode, we're going to be building an event registration app that allows users to register for any given event. We'll keep track of the total registration limit and how many registrations are remaining after users register. The goal here is to build a system where users can register when there are spots available, but they will not be able to register once the event is full.

Getting Started with the Build

To get started, we're going to create a brand new application using the quick start wizard. We'll install an event management application. Once the app is created, we'll take a look at the existing data tables. We're going to focus on the events table, which contains fields designed to store information about each event, like event name, date and time, cost, status, and notes.

Modifying the Data Structure

We'll be using the events table to manage our events and make a public page for users to register. To do this, we need to make a few modifications to our data structure:

1. Create a Registrations Table:
2. We'll create a new data table called "registrations" to store individual and unique registrations per event. The registrations will be connected to the event through a connection field.
3. Public vs. User Account Registration:
4. Since we’re making the form public, we need to add fields to gather user information like name and email. If you wanted users to create an account before registering, you could connect the registrations to the users' table as well.
5. Adding Fields to the Events Table:
6. We'll add three fields to the events table:

• Registration Limit: A number field to set the maximum number of registrations per event.
• Total Registrations: A complex formula field that counts the number of registrations per event.
• Registrations Remaining: A number formula field that subtracts the total registrations from the registration limit to show how many spots are left.

Building the Page Structure

Next, we'll move to the page builder to create a simple page structure that allows users to view events, view event details, and register.

1. Create an Events Page:
2. We'll add a new page called "events" and use a list component to display the events data. The fields we'll display are the event name, event date and time, and registrations remaining.
3. Add a Record Detail Page:
4. We'll link the list component to a child page that displays more information about the event. On this detail page, we'll add a form component to allow users to register for the event.
5. Configure the Form:
6. The form will be set up to add new connected registration records to the event. The required fields will be the user's name and email.

Preview and Testing

We'll preview the events page to see how it looks. Users can click on the registration button to go to the event detail page, where they can fill out the registration form.

Once a user registers, the system will update the registrations remaining. However, we need to set up validation and checks to prevent users from registering once the event is full and to stop users from registering more than once.

Adding Validation and Page Rules

1. Block the Page When Registrations are Full:
2. We'll add a page rule to block access to the event detail page when registrations are full. This will display a message when the registrations remaining is zero.
3. Prevent Duplicate Registrations:
4. We'll add a validation rule to the registration form to check for uniqueness by event and email, preventing users from registering twice for the same event.

Final Adjustments

We can also choose to hide events that are full from the events list by adding a data source filter. This filter will only show events where registrations remaining is greater than zero.

Conclusion

That's it for this week's episode of Build It with Tadabase. We now have a fast and easy way to handle event registration, ensuring that we hit our registration limit without allowing any more registrations or duplicate registrations. Thanks so much for watching, and we'll see you next time! Take care.