GetWaitlist

Promptfree, for everyone, and the only version there is

Open the prompt in Claude CodeOpen the prompt in CodexOpen the prompt in Cursor

Copy

Build me a referral waitlist.

STACK
- One serverless function, SQLite, a small embeddable form

SIGNING UP
- Email, an optional referrer code from the URL
- Double opt-in: the row is pending until a signed link is clicked, and pending rows hold no position
- Each confirmed row gets a short random code of its own

POSITION
- Base order is confirmation time
- Each confirmed referral moves someone up by a fixed number of places, capped
- Computed at query time from the referral rows; never stored, or it will drift

STOPPING THE OBVIOUS CHEATS
- One signup per email; plus-addressing normalised away
- Referrals only count once the referred person confirms
- Rate limit signups per IP hash per hour

TELLING PEOPLE
- On confirmation: your position and your link
- When you move up by ten or more places, one email, at most weekly

Include the schema, the position query and the anti-gaming rules.