Raffle Controller
Pull scores
Loads each game's scores straight from its Supabase table. If a pull fails or a game has no source set, use the manual paste below: it drives everything the same way.
Manual format: one entrant per line as name,score (score optional). Blank lines ignored.
Weighting
Beat the Bad Hire earns entries by rank. Halftime earns them by the tickets players were promised (play, plus a win bonus). Team bonuses reward the strongest companies. Everything sums per person.
Examples: top-3 in Beat the Bad Hire = 1 + 2 + 3 = 6. Halftime with 3 plays and 2 wins = 3 + (2 x 2) = 7. On the 1st-place team = +3 more. Teams rank by their members' combined score across both games.
Connection
Prefilled from your live game source. Both games read Supabase tables directly (no RPC). The key is the public anon key already shipped in your embeds, so it is safe here.
A source is the REST path after /rest/v1/. Beat the Bad Hire is set. Leave a source blank to skip its pull and use manual paste for that game instead. Fields auto-detect (name / player / handle, score / points / value, team / company).
Entrants & entries
One row per handle. Merge duplicates (same person, two handles), rename for the reveal, or exclude anyone who left. Excluded rows never appear in a draw.
| Display name | Beat the Bad Hire | Halftime Showdown | Team | Entries | Status |
|---|
Backup
Export the whole pool to a file before the night starts. If anything crashes mid-event, import it and you are exactly where you left off. This is your offline safety net if venue wifi drops.
Prizes
Suggested arc: soccer balls early (flat, everyone in), jersey to a top scorer (skill), painting as the weighted-random finale once it is dry. Edit freely.
Winners
Running record of the night. Export it for the wrap-up post.
- No draws yet.