Empower4Life Signups

This repository provides a framework for hosting signups for Empower4Life events. It uses AirTable as a backend for easy configuration and viewing, then provides a server for the frontend for volunteers/donors to sign up for the events.

Backend

Events Table

The Events Table is the place to setup a new event. Each event has the following properties:

ID: auto-assigned identifier for this signup
Title
Description (optional)
Image (optional)
Active: checkbox specifying whether or not this signup is currently active
Items: entries from the Items table for this event

Users Table

The Users Table is where all users that signup for any events/donations will be stored. Each user has the following properties:

ID: auto-assigned identifier for this user
Name
Email
Phone (optional)
Magic Code: generated secret key which can be sent to users to login to their account to modify their signups
Signups: entries from the Signups table for which this user has signed up

Items Table

The Items Table is where all of the signup items are stored. For example, for a volunteer event, the individual jobs that need volunteers would be added to this table. For a donation signup, each item would be added to this table for donors to select from. The items are grouped by event for clarity. Each item has the following properties:

ID: auto-assigned identifier for this item
Title: title of this item
Notes: details about the item which should be shown on the signup page
Start time (optional): for volunteer events, this is the start time of the slot
End time (optional): for volunteer events, this is the end time of the slot
Needed: the number of signups needed for this item
Have (computed): the total number of signups for this item so far
Active: whether this item is currently active (this is taken from the Signups table)
Signed Up: names of alll users signed up for this item

Note that the items are grouped by Signup. The default view ("Active Items") shows only active items, and the "All Items" view shows all of them.

Signups Table

The Signups Table is where the signups get stored. This is basically matching a user to an item for which they signed up.

ID: auto-assigned identifier for this signup
Item Title: title of the item
User Name: name of user who signed up
Number: how many did they sign up for
Comments (optional): any comments left by the user

Frontend

There are two main user interfaces to the signups system.

First, is the event-specific signup page: https://signups.empower4lifemd.org/event/``. The event-id is a unique number identifying an event, corresponding to the ID column in the Signups table. This page shows the signup items for the specified event, with UI elements for a user to signup.

The second main user interface page is a page for an individual volunteer/donor, available at https://signups.empower4lifemd.org/user/. When logged in, this page shows all signups for the logged-in user and provides UI elements to cancel a signup. If not logged in, this will show to a login page.

The front page, https://signups.empower4lifemd.org, shows links to all active signups. This link will not typically be shared, but instead the direct links to individual signups will be shared.