Template
Secret Santa
An app to facilitate Secret Santa
The purpose of this app is to facilitate a Secret Santa event. It contains everything needed to allow people to enter their info, and for those people to be matched up with one another
---| FACILITATORS |---
Facilitators have the ability to specify specific details for the Secret Santa event:
- guidelines for gifts
- entry deadline
- delivery details
- and more
---| PARTICIPANTS |---
Participants use the app to enter their details; these details will then be shared with whoever they are matched up with when the time is right. The details required include:
- Name
- Email
- Gift Suggestions (if allowed)
- Address (if remote workers are included)
---| REMOTE WORKERS |---
- If gifts won't be handed out all at once (like at an X-mas party or something), then people need a way to get things to each-other
- If remote workers are included, an Address field is required when entering your details
- This allows remote people to be involved as well
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
This app consists of 4 tables, only 3 of which are really important.
- The non-relavent table is the 'Getting_Started' table, which is there to help people familiarize themselves with the app when first opening it and... well... getting started. (^_^)
---| THE WELCOME TABLE |---
The first table that starts things off is the "Welcome" table - which not only serves the purpose of a landing page for the app, but also holds the image and header used in the email sent out to everyone when they're matched up. (more later)
---| THE GROUPS TABLE |---
The (real) first table that matters is the "Groups" table - which serves as the 'parent' to all the entries that everyone will enter when using the app. This table not only holds the 'name' of the 'event' that's happening, but also various details about that event:
- Entry Deadline (when people need to have their names/email/etc, in the system in order to participate)
- Delivery Option (can people deliver gifts whenever they want, or will things be done on a specific date (like at a party, last day of work before break, etc.)
- Delivery Date (when everything will be revealed, and when things need to be 'finished')
- Remote workers (are they allowed to patriciate too?)
- Allow Gift Suggestions (should people be allowed to add in gift ideas)
- Gift Guidelines (if you want to specify some guidelines people should follow for gifts, you may enter them here)
---| THE ENTRIES TABLE |---
The main data collection table is the "Entries" table - which is where everyone participating in the event will enter their data. This one's pretty basic on it's face, but behind the scenes there's more going on. In order to get a random matching system in place, we needed to include a few 'supporting' columns - to hold variables that can then be used to match everyone up.
- Your Number (this holds a number that's assigned to the user, which is subsequently used to sort everyone)
- Your Group Sort Number (after everyone has entered their details, all the entries are sorted based on their assigned number (from above) - that sort number is then stored in this column)
- Matched Entry (after all the sort numbers are figured out, each entry then simply grabs the email of the next person in line (with the last person grabbing the first person in line)
-------------------------------------------------------------------------------------------------------
There's obviously more going on (just take a look at the actions panel), but in an effort to be brief... the details above describe the core of how things work. Everything else involved simply makes it all work smoothly.
HAPPY HOLIDAYS!!
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...