Chair Edit Portal — Newport Elks Lodge #104

How this works

All edits happen in a shared Google Sheet — that way each chair can keep their own committee up to date without anyone holding a master password. The lodge admin controls who can edit which rows through Google's normal sharing settings.

Find your committee below and click Edit my committee to jump straight into the sheet. The changes you save there will show up on the public Volunteer Opportunities page on its next refresh.

Your Committee

Pick yours from the list below. Each button opens the Google Sheet to the right tab.

Lodge Admin: One-Time Setup

Do this once to wire up the Google Sheet that powers the site. After that, chairs just edit the sheet directly.

Upload the starter workbook to Google Drive. Drag Newport_Elks_104_Lodge_Data.xlsx (in your outputs folder) onto drive.google.com. After upload, right-click the file → Open with → Google Sheets. Drive creates a Sheets version with all five data tabs and a README already populated. You can delete the original .xlsx after.
Share with chairs. Click the Share button (top-right) in the Sheets file. Add each chair's Gmail address as Editor. Keep general access set to Restricted — only invited chairs can see or edit.
Copy the Sheet ID from the URL — the long string between /d/ and /edit.
Paste the Sheet ID into both volunteer.html and admin.html. Find the SHEETS block near the top of the <script> section in each file:
const SHEETS = { enabled: true, sheetId: "PASTE_HERE", ... };
Change enabled: false to enabled: true and paste your Sheet ID. Save both files and re-upload to your host.

What lives where

The Google Sheet has five data tabs (plus a README). Here's what each one controls:

Committees — one row per committee, with chair info, description, and up to six task slots (each slot has a title, status, duties, and time). Chairs only edit this tab.
Featured_Activities — the big-event cards on the Activities tab.
Ongoing_Activities — Mahjong, Yoga, Pickleball, etc.
Lounge_Schedule — day-of-week hours and themes on the Lounge tab.
Bar_Games — Jackpot Drawings, Queen of Hearts, Keno cards on the Lounge tab.

Editing tips for chairs

Each committee has 6 pre-built task slots on its row. Fill in the slots you want, leave the rest blank. No need to add or delete rows.
Task status is a dropdown — each value changes what the public site shows under that task:
- needs-volunteers → an "I'd like to help" button
- in-progress → an "I'd like to join in" button
- planning → shows your meeting_schedule so members know when to come hear about it
- pending-budget → shows "Waiting on budget approval"
meeting_schedule — set once per committee (e.g. "First Tuesday of the month, 5:30pm in the BR"). It appears on every PLANNING task you list.
To remove a task: just clear the title — the website will skip any slot with a blank title.
The first three columns (id, type, name) are frozen so you always see which committee you're editing as you scroll right.
Changes take effect on next page refresh — no save button needed.