Auto-open coach opportunities on publish

What & Why

Right now, publishing an event does nothing for coach staffing. The "Open Coaching Opportunities" page () only shows postings that an admin created by hand, one role at a time. Because no one has hand-created any, the page reads "No open opportunities right now," even though events have been published.

Admins already tell the system how many of each role an event needs (the event's staffing requirements, with sensible defaults per event type). This task connects those two things: when an event is published, the system automatically opens a coaching opportunity for each staffing role that still needs people, so coaches immediately see it and can apply. This matches the expectation that "a published event is live and coaches can apply to work it."

Done looks like

When an admin publishes an event that has staffing requirements, matching open coaching opportunities appear on the "Open Coaching Opportunities" page without any extra manual steps.
Each opportunity shows the role, the event, and an accurate "N of M filled" count based on the event's staffing requirements.
Coaches can apply to those opportunities exactly as they do today (the existing apply / approve / withdraw flow is unchanged).
Coaches who are already eligible get the existing "New opportunity" email digest for the newly opened roles.
Re-publishing the same event (or moving it back to draft and forward again) does NOT create duplicate opportunities for roles that already have an open or filled posting.
Events with no staffing requirements behave as before (nothing is auto-created) — no errors, no empty postings.

Out of scope

Changing the apply, approve, reject, or withdraw flows (already built and working).
Changing the email digest mechanics (reuse the existing "New opportunity" coalescer as-is).
Redesigning the Open Coaching Opportunities page beyond what already renders postings.
Auto-closing or removing opportunities when an event is unpublished or cancelled (can be a follow-up).
Generating opportunities for any event status other than PUBLISHED.

Steps

1. Auto-open on publish — In the event lifecycle transition, when an event moves into the PUBLISHED state, read its staffing requirements and create one open-for-interest staff assignment per role that does not already have an open or filled assignment. Skip cleanly when the event has no staffing requirements. 2. Idempotency guard — Before creating each role's opportunity, check existing assignments for that event/role so re-publishing never duplicates postings. Only create for roles whose current open + filled count is below the needed count. 3. Reuse the new-opportunity email fan-out — For each opportunity actually created, enqueue the existing "New opportunity" email notifications (best-effort; never fail the publish if email enqueue fails), mirroring how the manual create route already does it. 4. Verify the board — Confirm the newly created opportunities surface on the Open Coaching Opportunities page with correct "N of M filled" counts, that a coach can apply, and that re-publishing does not duplicate rows. 5. Document — Add a short note to under the Coach Event Application Flow describing that publishing an event now auto-opens opportunities from staffing requirements (idempotent, PUBLISHED-only), so the manual-create path becomes a supplement rather than the only way.

Relevant files

- - - - - - - - - -

Volleyball Elite Academy

Reply to this email — we read every reply.

You received this because you have an account with Volleyball Elite Academy.

elitevolleyball.training

Elite Academy

Friday, May 29, 2026