Needs attention
Inquiries Follow-up
Loading...
Loading...
Add a Gig
Pick an existing gig to fill in missing details like deposits, or leave on "New gig" to add one.
Gig tools
Gigs
green everything done orange waiting on someone pink needs action
Gigs where the lineup is not the usual band members plus Chris on sound: who is missing, who is extra (fill-ins), and whether someone other than Chris is on sound. Gigs with the usual lineup are not listed. Cancelled gigs are left out.
Inquiries
Everyone who fills in the Contact Us form on the website lands here. Turn on watching and each new one also gets an automatic thank-you email with our video, socials and set list.
Auto-reply: turn on, edit the message
Watching and sending come from the band inbox, so only the band Google account can turn them on or use "Check now". You can still edit the message here.
Words you can use: {name} (their first name), {eventLine} (a line about their date and place, left out if they gave no date), {eventType}, {date}, {location}. Web addresses become clickable links. Replies come back to the band inbox.
Loading...
Venues & Clients
Contacts here are who invoices and W-9s are emailed to. Changing a venue here doesn't change gigs already saved; they pick it up the next time they are saved.
Loading...
Musicians
Band members are ticked by default on new gigs; fill-ins are not.
Loading...
Are you free? texts
Ask the band about a date before a gig is booked. They reply 1 for yes, 5 for maybe or 9 for no. With one ask open that is all they type. When a second (or later) ask is open at the same time it gets a letter (A, then B...) and its text says to reply A1, A5 or A9; the first stays plain, and the next ask goes back to plain 1 / 5 / 9 as soon as no plain ask is open. A plain 1, 5 or 9 counts for the plain ask (or the only ask they have open), a lettered reply for that letter's ask, and they get a text back confirming their answer.
New ask
Type just 7, 730 or 7:30 and PM is assumed (add am for mornings). Or tap the box to pick.
Ask
Loading...
The text that will go out:
Asks
Loading...
Copy every reply to
Each reply (and any message that isn't a 1, 5 or 9) is also texted to these people. Someone is never sent a copy of their own reply.
Texting Mac
Availability
Days a musician can't play. Musicians will be able to enter these themselves; you can also enter them here. Gigs that already have that musician in the lineup are flagged.
Mark days unavailable
name = unavailable gig = booked gig a red outline means a musician on that gig is unavailable
Upcoming time off
Loading...
Money
Loading...
Every gig for the year, in date order: the fee, then where the money went (band account, then each person paid, fill-ins and the sound people included). Italic grey amounts are not marked paid yet. Cancelled gigs are left out.
What went into the band account and the tips received, by the gig's date. Cancelled gigs are left out. Both are set on the gig (Money section).
Set each venue or client once as 1099 (the band issues 1099s to the musicians for gigs there) or not taxed. Every gig for that client follows it, in every year. Totals are the gig fees (what clients paid), by the gig's date. Cancelled gigs are left out. You can also set it in Venues & Clients.
Settings
Background sending
Sends the 3-day calendar reminders from classof84band@gmail.com. Only that account can turn it on or off. Invoices and W-9s are never sent on a schedule; they go only when you press Approve & email.
Test the reminder email
Sends one reminder email for the gig you pick to you only (the Google account you are signed in with). It changes nothing and no musician is emailed. The link in it opens the event only if your account is on that gig's invite.
Test the gig day text
Sends one gig day text, marked TEST, to the one phone number you type. Nobody on the gig is texted. The Mac sends it within about 30 seconds (it must be on with the texts window open).
Google Drive
Invoices and signed contracts are filed in a folder for the gig's year (2026, 2027...) inside the shared invoices folder. New ones go there automatically. Press this once to move the ones saved earlier into their year folders.
Inbox assistant (Claude)
Claude reads the band inbox every 6 hours (and whenever you ask), puts a Gmail label on each recent thread (CO84 AI/Inquiry, Booking, Payment, Venue, Band, Vendor, Admin, Other) and lists the ones that need a follow-up in Inquiries Follow-up at the top of Needs attention. It only adds labels: it never archives, deletes, drafts or sends anything. Each thread's text is sent to Anthropic for analysis. You need your own API key from console.anthropic.com (with billing on); it is kept private in the admin's settings and never shown again.
How hard Claude thinks before it answers. Higher is a little slower and costs a bit more, and can give better setlists. The setlist builder level is kept in the setlist sheet.
Reply drafts
Used when you press Write a reply on a follow-up. Claude only writes a draft for you to read and send yourself.
Import gigs from the band calendar
Finds events on the band calendar that aren't linked to a gig yet, so you can add them here (and to the website) and link them. Nothing is created until you tick events and press Import.
Availability calendar
Keep days off in step with a Google Calendar the whole band already uses. Days entered here or on the band page become all-day events on that calendar, and anything added or changed in Google Calendar shows up here and on the band page within about 10 minutes.
Mileage rate
The standard mileage rate (dollars per mile) musicians see and start from on the band page Expenses tab. Update it each year. They can still change the rate on any entry.
Band member page
A private page for the band at classof84band.com/band: musicians sign in with Google, see their own gigs and pay, and enter days they can't play. It is not linked from the website menu.
Band members stay signed in on their phone for up to 60 days after signing in with Google once. If a phone is lost or you want everyone to sign in fresh:
Who can sign in: full-time band members automatically, plus any fill-in you allow on the Musicians page. They sign in with their Google sign-in email (or their regular Email if no separate one is set).
- Loading...
Copy this list into Google Cloud → Google Auth Platform → Audience → Test users. A new person who gets access must be added there too.
Who has access
The admin's short address is admin.classof84band.com (bookmark it; the older admin-next address still works too, but sign in separately there). You sign in with Sign in with Google, the same as the band page, using one of the accounts below. After that you stay signed in for 60 days, and the 60 days restart each time you use the admin, so if you use it regularly you will not be asked again. "Sign out" is the small link at the bottom right. These accounts can open this admin. To add or remove someone, change the Worker's ALLOWED_EMAILS (and keep ALLOWED_EMAILS in the Apps Script Script Properties the same, because the background features still use it); a removed person is signed out on their next click. To sign everyone out at once, change the Worker secret SESSION_SECRET. Ask Claude to do either.
- Loading...
Instructions
How to use this site
This is the private band admin. Everything you save goes into the band Google Sheet. Only the public parts of a gig (date, time, name, venue, address, public note, link) ever show on the website. A private gig (a private client or private venue) is always listed on the website as Private Event, whatever name you give it here, with no venue or address. Signed-in band members see the real name on the band page's Setlists tab as well as on My gigs, and the BandHelper list is named after the real name (for example 2026-12-05 Chris Valis' Party). This needs the secret GIGNAMES_KEY set on both the Apps Script project and the setlist Worker; without it the Setlists tab and BandHelper fall back to Private Event.
Finding your way around
Band page link: the orange Band button at the top right opens the musicians' page (classof84band.com/band) in a new tab. Settings now sits at the top right too, just left of the Band button (it used to be in the main menu row). The band page has the matching spot at its top right: Settings and Admin Portal (admins only) sit there, next to the green "Band" pill (green marks the page you are on).
On a phone: the main menu (Home, Gigs, Clients & People, Money) is a bar pinned to the bottom of the screen, so it is always in reach. The smaller row of choices for the section you are in stays at the top; if it runs off the edge, swipe it sideways.
Links: the address in your browser follows the page you are on, for example ?view=money&tab=report for Money → Gig report, or ?view=add&gig=... for a gig. Bookmark or share that address and it opens straight there (the person must still be an admin). The friendly address admin.classof84band.com must keep the part after the ? when it redirects.
The menu row has four sections, plus Settings at the top right. Gigs, Clients & People, Money and Settings open a second row of buttons underneath (Money: Who's owed, 1099 summary, Band account & tips, Gig report; Settings: Settings, Audit log); Home goes straight to its page.
- Inquiries Follow-up is always the first section on Needs attention. Claude reads the band inbox every 6 hours, or whenever you press Check the inbox now at the top of the Inquiries Follow-up section (signed in as classof84band@gmail.com), adds a Gmail label to each recent thread (CO84 AI/Inquiry, Booking, Payment, Venue, Band, Vendor, Admin, Other; it never archives, deletes or sends anything) and lists the threads that need you: why, and a suggested next step, with the newest worries and urgent ones first. It lists two kinds: people waiting on the band (they wrote and haven't had a human reply), and people the band is waiting on (marked Waiting on them: the band wrote last with a question or quote and there has been no answer for 5 days by default; change the number under Settings → Inbox assistant). For the second kind the button reads Write a check-in and Claude drafts a short, friendly nudge. For a website contact-form inquiry the title is the name the person typed in the form, with the event type, date and place under it (not the form's automatic subject line). Each has Write a reply (or Write a check-in), Open in Gmail, Snooze 3 days and Dismiss. Write a reply makes Claude draft an answer from the email, your tone and sign-off, your pricing notes (all under Settings → Inbox assistant) and whether the date is free on the Shows calendar. You can edit the text, press Redo with a tweak ("shorter", "ask for a budget"), Copy it, or Save as Gmail draft (signed in as classof84band@gmail.com) and or Send from band email. Sending always asks you to confirm first, shows exactly what will go out, and sends from classof84band@gmail.com to the address found in the email (you can't type another recipient). Signed in as the band account it goes out at once; any other admin queues it and it goes within 5 minutes. A sent reply leaves the follow-up list; if the person writes back, the thread returns. At most 10 sent replies a day, and the text is erased from the Sheet once sent. Where Claude doesn't know a price it writes [quote]; the admin won't send a reply that still has [quote] in it. A new message in the thread brings it back. Set it up under Settings → Inbox assistant: paste your Anthropic API key, pick a model, tick Watch the band inbox and Save. Each thread's text is sent to Anthropic for the analysis; the key is stored privately and never shown again. The first time after this was added, each admin may be asked to approve one extra Google permission (Gmail labels).
- Home lists only what needs you: gigs with no invite, replies you're waiting on, musicians who answered Maybe (tentative) or Declined the calendar invite, invoices not sent, balances still due, and musicians still to be paid. Only gigs dated 2026 or later are checked, so older history never shows up here. Each line has an Open gig button. If you refresh the page it comes back to the page you were on (and the Money view), not Home. Dates in the admin are shown as mm/dd/yyyy (for example 11/14/2026); invoices and emails to clients keep their own wording.
- Gigs → Lineup (the third button at the top right, next to List and Month) lists only the gigs whose lineup is not the usual one: the band members plus the band's sound person. For each it says who is missing, who is extra (fill-ins like Steve or Abby), and whether someone else is on sound (for example Kevin instead of Chris). It opens on Upcoming gigs (today onward, any year); use the Year box to pick a single year or All years instead. Tap Open gig to change one. Who counts as "usual" comes from the Musicians page: active people marked as band members (the sound person is the band member with a Sound role). Cancelled gigs, and old gigs with no lineup recorded, are left out.
- Gigs → All Gigs shows one line per gig with three small badges (Pay, Calendar, Invoice): ✓ done, … waiting on someone, ! needs you. Tap a gig to open its details. The Month button shows a calendar; tap a gig on it to open it.
- Gigs → Add / Modify Gig is the form. It has three sections (Gig basics, Musicians, Money and private details) that open and close, and each shows a one-line summary when closed.
- Clients & People → Inquiries lists website Contact Us submissions, sends the automatic thank-you reply, and turns an inquiry into a client and a gig. The number next to Clients & People is how many inquiries are new.
- Clients & People → Availability is where you mark days a musician can't play and see them on a calendar next to the gigs.
- Set lengths and breaks: on Venues & Clients you can enter up to 3 sets and 2 breaks in minutes (Set 1, Break 1, Set 2, Break 2, Set 3). A new gig starts with its venue's or client's numbers, and you can change them on any gig. Leave a box empty if it is not used. When you open an upcoming gig that has no numbers of its own, it starts with its venue's numbers (past gigs stay empty). The setlist tool on the band page will use these numbers (they are in the public feed as plain numbers but the website does not display them).
- Upcoming gigs: tick Only venues and clients with upcoming gigs above the list on Venues & Clients to hide the rest. Each client with a gig coming up shows how many and when the next one is. Cancelled gigs are not counted.
- Delete a venue or client: press Delete on its card in Venues & Clients. If any gig or inquiry still uses it, the page lists them and nothing is deleted: move those to another venue or client (or delete them) first. If nothing uses it you are asked to confirm, and it is removed for good. The deletion is recorded in the audit log.
- Clients & People → Venues & Clients and Musicians let you add or edit contacts, emails, roles and default pay without going into the Sheet.
- Money shows who is owed what. It only lists gigs that have already happened (a gig appears the day after it is played). Tap Mark paid for one musician on one gig; the date you tap is saved as the paid date.
- Settings has the background-sending switch, the calendar import, the list of people with access, and these instructions.
Add a new gig
- Open Add / Modify Gig and leave Gig to change on "New gig".
- Playing the same venue on more than one date? On a new gig press + Add additional date under Date, pick each extra date, and save once. Each date becomes its own gig with the same venue, time, musicians, price and notes, and each gets its own calendar invite. Deposit and money received are saved on the first date only.
- Venue or client not in the list? Choose + New venue or private client... at the bottom of the Venue list. A small form pops up for the name, address and contact (name, email, phone). Press Save and use it and you're back on your gig with it selected. Choose Private client for private parties: their details stay private and the gig asks you for a gig name like Smith Wedding.
- Pick the date and a Venue. The show name fills in from the venue (you can type over it) and the start time and duration fill in from the last gig there (if you haven't set them yourself). Duration starts at 3 hours.
- Start time and Duration are boxes you can just type in. For the time, type 7, 730 or 7:30 and it becomes 7:00 / 7:30 PM (PM is assumed; add am for a morning start, like 11am). For the length, type 3, 2.5, 2h30 or 90m. Tap the box to pick from the usual choices instead. Any time works, not only the half hours.
- Tap the musicians playing. Band members are already on. An orange dashed name is a fill-in. Ticking a fill-in never turns anyone else off, except that a gig can only have one sound person, so ticking one sound person turns off the other.
- Fill in the Public note if you want something shown on the website under the location.
- Press Save gig.
Where the website contact form goes
- The Contact page on the website uses Web3Forms (web3forms.com), a free form service. When someone fills it in, it emails the band at classof84band@gmail.com with the subject New booking inquiry from classof84band.com.
- The Web3Forms account was created by signing in with the band Gmail (classof84band@gmail.com). To see or change where the emails go, sign in at web3forms.com with that account.
- Inquiries from the band's older website came from Bandzoogle with the subject "Contact Us submission". Those are still in the same inbox.
- Nothing from the form is added to this admin automatically. Add a new client or venue yourself on Venues & Clients.
Website inquiries and the automatic reply
- The Inquiries tab lists everyone who filled in the Contact Us form on the website: name, email, event type, date, place and their message. The number on the tab is how many are still marked New.
- Each inquiry shows Already booked: ... if we have a gig that day, or Date open on our list. Set its status (New, Replied, In talks, Booked, Not booking, Spam / test) and add notes right on the card.
- Add as client / venue opens the New venue box already filled in from the inquiry (name, email, place, their message in the notes). Check it and save. The button then becomes Start a gig for ..., which opens Add Gig with the date, the client and their message filled in and marks the inquiry Booked.
- Thought level: under Settings → Inbox assistant (Claude) you can choose how hard Claude thinks (Off, Low, Medium, High), separately for the inbox assistant and for the setlist builder on the band page. Off is the fastest and cheapest. Higher levels are a little slower and cost a bit more. The setlist builder level is stored in the setlist sheet; if your Google account cannot edit that sheet, change it on the band page instead (Setlists → Admin tools).
- Automatic reply: open "Auto-reply" at the top. Signed in as classof84band@gmail.com, press Turn on inquiry watching + auto-reply. Every 5 minutes the band inbox is checked for new form emails and each new person gets a short thank-you email (about 60 words) that says we'll follow up in 1-2 days, links to our promo video and upcoming shows. Links in the message can be written as [words](https://address) so they show as clickable words. If you edited the message earlier, press Back to suggested text under Auto-reply, then Save message, and use Send me a test to see it. Replies from them come back to the band inbox. Only inquiries that arrive after you turn it on get a reply.
- Edit the subject and message there and press Save message. Send me a test emails a sample (with made-up details) to you only. Words in curly brackets, like {name} and {eventLine}, are filled in for each person. The links in the suggested message use classof84band.com; change them here if the website address ever changes.
- Safety limits: one reply per email address every 14 days, at most 25 a day, and anything that looks like spam (links in the message) is held with a Send reply button instead. Untick "Send the automatic reply" to keep the list without replying.
- Archive: when you are finished with an inquiry (added as a client, booked, or not pursuing), press Archive on its card. It leaves the main list and the new-inquiry count. Tick Show archived at the top to see archived ones, and press Restore to inquiries to bring one back. Nothing is deleted.
- Check now looks for new ones immediately. Load older ones brings in earlier form emails without sending anything. These need the band account because they read its inbox.
Band member page (classof84band.com/band)
- Musicians open classof84band.com/band on their phone and sign in with Google. It isn't in the website menu, and search engines are told to skip it. Tell the band the address once, and they can add it to their home screen.
- They see only their own upcoming and past gigs (date, time, venue, address, public note, who else is playing, and their own pay and whether it's been paid). They never see the gig fee, private notes, or anyone else's pay.
- Days off: they pick a day (or press + More than one day for a stretch) with an optional note, and it appears in Clients & People → Availability marked "entered by them". Each entry in their Your days off list has Edit (change the dates or the note, which also updates the Google Calendar entry) and Remove. The admin Upcoming time off list on the Availability page has the same Edit and Remove buttons for every musician's days. Days created by I can't make it only have Remove, because they belong to the gig answer. If they mark a day when they're already booked, the page warns them.
- Accept / I can't make it: each upcoming gig on a musician's My gigs page shows what they've answered on the Google Calendar invite, read live from the band calendar.
- Waiting (or "maybe"): they see Accept and I can't make it.
- Accept sets their answer to Yes on the gig's calendar event. Once they've accepted (here or in Google Calendar), the I can't make it button goes away.
- I can't make it sets their answer to No on the calendar event, marks that day unavailable (and on the availability calendar), sets aside their pay for that gig (see below), and emails the band address once. The gig then shows a lineup conflict on Home.
- If they declined and change their mind, they see Accept. Accepting clears the day off that "I can't make it" created and brings their pay for the gig back.
- If there's no calendar invite for them yet, they only see I can't make it (it still tells the band and marks the day).
- These buttons change the answer shown on the band's event (what Home and the reminders use). Their own Google Calendar copy of the invite may still show "needs reply" until they answer there.
- Deleting a musician: open their record on Clients & People → Musicians and press Delete musician. It only works for someone who has never been on a gig or had a payout, such as a person added by mistake or a duplicate. Their days off are removed too. For anyone with history, untick Active instead, which hides them from the lists but keeps your gig and money records intact.
- Expenses tab (private to each musician): musicians can track gear, travel, mileage and other costs for tax time on the band page. Each person has to connect their own Google Drive (with the same Google account they sign in with); the page creates a spreadsheet called "Class of 84 - My Expenses" there and keeps everything in it. It uses Google's narrow "only files this page creates" permission, so it can't see the rest of their Drive. Nothing is stored in the band's Sheet or on the band's server, and admins can't see anyone's expenses (the admin view-as mode doesn't show them either). The tab also totals what the band paid them that year, split into 1099 / not taxed / not marked, using the tax setting on each venue or client. It is not tax advice. Receipt photos are not part of it yet.
- Band calendar (band page): a Calendar tab shows a month view. Full-time band members see every booked gig (name, time, venue; never pay, address or notes) and everyone's days off, taken from the same Unavailable list as the Availability page. They can tap a day for details and mark themselves unavailable from it. Fill-ins with access see only their own gigs and days off. Cancelled gigs are left out.
- Mileage rate: Settings → Mileage rate holds the year and the dollars-per-mile rate (currently 2026 at $0.725). Musicians see it on their Expenses tab as the default rate and can still change it on any entry. Update it each year.
- Mileage to gigs: each musician record now has an optional Home address (edit it on Clients & People → Musicians; musicians can also add it themselves on the band page Expenses tab). With it, the Expenses tab offers Add mileage for past gigs: one round-trip mileage entry per past gig (last 12 months) in the musician's own Drive spreadsheet, worked out with Google Maps from their address to the gig's address. They can edit the miles on any entry or add their own entries for rehearsals, music-store trips and so on. Gigs with no address (private events) are skipped. Distances are remembered on a Distances tab so each trip is looked up once. The address is never required.
- Viewing the band page as someone else (admins only): an admin who signs in to classof84band.com/band with their own Google account (an address on the admin list) gets an orange Admin: view as someone bar. Pick a musician to see exactly their page, including people who don't have band-page access. Nobody else ever sees this bar, and the server ignores it for anyone who isn't an admin.
- View-only by default: the buttons that change things (Accept, I can't make it, days off) are blocked with a message, so testing can't change anyone's real data.
- Allow changes: ticking it (with a warning) makes those buttons act as that person for real: their calendar answer, their pay and an email to the band. That email says it was done by an admin while viewing their page. Untick it, or switch to "Myself", to go back to view-only.
- An admin who isn't a musician (for example the band account) sees only the bar until they choose someone. Removing an address from the admin list ends this ability immediately. While the sign-in app is in Testing mode, each admin address that will use this must also be added as a Google test user.
- Band page Admin tab: admins see an extra Admin tab on the band page (it stays there even while viewing as someone else). It holds View as someone (look at the page as a musician; tick Allow changes only if you mean to act for them) and What musicians can see: tick or untick Calendar, Days off, Expenses and Setlists to show or hide each tab for musicians, plus Setlists: Claude tools (the Ask Claude to build / adjust bar and the similarity sliders inside a setlist). The Claude tools are shown to musicians unless you untick them; this hides them on the page only. It saves as you tick. Admins always see every tab, but while viewing as someone you see exactly what they see. Calendar starts hidden. The Calendar data itself is also refused for musicians while it is hidden; the other tabs are hidden on the page only.
- Staying signed in: a musician signs in with Google once, and the page then remembers them on that phone or browser for up to 60 days, renewing every time they use it. They only see the Google sign-in again if they press Sign out, clear their browser data, or haven't used the page for 60 days. Removing someone's access (or changing their sign-in email) ends their session immediately. Settings → Band member page → Sign everyone out makes every musician sign in with Google again, for example if a phone is lost.
- Who gets in: full-time band members (ticked Band member on the Musicians page) automatically. Fill-ins don't, unless you open their record and set Access to Allow. Setting it to Block shuts out even a band member, and so does marking someone inactive.
- Which Google account: a musician signs in with the Google sign-in email on their Musicians record. Use it when their Google account isn't the email you invite them with. Calendar invites always keep going to the normal Email; the sign-in email never changes that. If it's left empty, the normal Email works for sign-in.
- Setup: Settings → Band member page holds the Google Client ID, shows who can sign in, and gives a ready-to-copy list of Google test users. Each person with access must also be added to the Test users list in Google Cloud while the sign-in app is in Testing mode.
"Are you free?" texts (People → Texts)
- Open asks also show at the top of the Home page (above Inquiries Follow-up) with the yes / maybe / no counts and who hasn't answered; the box disappears when no ask is open.
- Use it before a gig is booked: pick a date, a time (or leave TBD ticked) and type the location. The preview shows the exact text. Pressing Send text to the band (and confirming) is the approval; nothing else is ever sent.
- People reply 1 for yes, 5 for maybe or 9 for no. The reply counts for the plain ask they were sent, or for the ask whose letter they typed (A1, B5...) when several are open (a later reply replaces an earlier one); if several lettered asks are open and they send a plain digit, the Mac texts them to add the letter, and the Mac texts back a confirmation such as "Got it: YES for Fri Nov 20", so a wrong match is easy to spot. If an earlier ask is still open when you send a new one, you are asked whether to close it.
- The texts go out through Messages on the Mac that runs
tools/texts(it must be on and running). People with no phone number on the Musicians page are skipped and named. - Gig day texts: every musician on a confirmed gig gets a text with the gig name, day, start time, venue and address. By default it is one text at 9 AM on the day of the gig. On a person's page under People → Musicians you can turn that off, or also turn on a text at noon the day before. A text is not sent after the gig has started, and not to anyone who declined the invite or has no phone number. Settings → Test the gig day text sends one test to a number you type.
- Reminders: anyone who hasn't answered an open ask is texted again 24 hours after their last text ("Reminder: are you free ..."), only between 9 AM and 9 PM, up to 3 reminders each. They stop when the person answers, you close the ask, or the date passes. Your list shows "reminded 2x" next to a name. Reminders need the Mac agent running, and they are not copied to the copy list.
- Each ask lists who said yes, maybe, no, or hasn't answered. The 1 / 5 / 9 / Clear buttons let you enter an answer yourself (for example after a phone call). Close this ask stops it taking replies and hides it from the list; Show closed asks at the bottom brings them back, with a Reopen button.
- Messages that aren't a 1, 5 or 9 aren't recorded on this page; they only reach the people on the Copy every reply to list as a text.
- Copy every reply to: tick who also gets a text copy of each reply (for now Adam; add Doug later) and press Save copy list. The copy says who answered what, and also covers messages that aren't a 1, 5 or 9. Nobody gets a copy of their own reply.
- Texting Mac shows when the Mac last checked in. Make a new key creates the secret the Mac script needs (shown once).
Availability (days a musician can't play)
- Clients & People → Availability is where days off live. Pick a musician and the day, add an optional note, and press Mark unavailable. For a stretch like a vacation, press + More than one day and pick the last day too.
- The month calendar shows who is out on each day (orange) and the booked gigs (blue). A red outline means someone lined up for that gig is unavailable that day. Upcoming time off lists each stretch with a Remove button.
- On Add / Modify Gig, a musician who is unavailable on the date you pick gets a red unavailable tag, and a red warning appears if you tick them. It still lets you save, so you can talk to them first.
- A gig whose lineup includes someone who is unavailable shows an Unavailable tag on the Gigs page, and appears under Lineup conflicts on Home.
- Everything is saved in the Unavailable tab of the Sheet (one row per person per day). Musicians can also enter their own days on the band page (classof84band.com/band).
- Google Calendar sync: in Settings → Availability calendar, pick the band's calendar and press Use this calendar. From then on, days off entered here or on the band page become all-day events on that calendar (a vacation is one event, titled like "Doug Rivers - unavailable"). Anything added, changed or deleted directly in Google Calendar comes back here within about 10 minutes (or press Sync now).
- For an event made in Google Calendar to count as someone's day off, put their name in the title (for example "Kim vacation" or "Doug & Kim out"). If no name matches, it counts for whoever created the event, if their Google account is on file. Entries that can't be matched are listed in Settings so you can fix the title. Timed events count for the day they fall on, and repeating events are included.
- Deleting an event in Google Calendar removes those days here; deleting a day here removes it from (or shortens) the event. A day that comes from an entry shared by several people ("Doug & Kim out") must be changed in Google Calendar. Turn off stops the sync and leaves everything already saved alone.
- Everyone with access to that calendar can see these entries and any notes on them.
1099 tracking (set per venue / client)
- Every venue or client has a Tax reporting choice in its edit box (Clients & People → Venues & Clients): 1099 (the band issues 1099s to the musicians for gigs there), Not taxed (musicians are paid without a 1099), or Not set yet. You set it once, and every gig for that venue or client follows it, in every year. The gig card shows it on the private side.
- Money → Gig report is a table of every gig for a year, in date order: date, gig, fee, then what went to the band account and then each person paid (band members, fill-ins and the sound people each get their own column), with a total column and a totals row at the bottom. Amounts in grey italics are not marked paid yet. Pick the year at the top; Download CSV saves it for a spreadsheet. Cancelled gigs are left out.
- Money → Band account & tips shows, for a year you choose, the total put into the band account and the total tips received, with the gigs behind them (tap Open gig to change one). Gigs are counted by their date and cancelled gigs are left out.
- Money → 1099 summary shows, for a year you choose, how many gigs and how much in gig fees (what clients paid) fall in each group: 1099, Not taxed, Not marked yet, and a total. Gigs are counted by their date, and cancelled gigs are left out. A gig with no venue or client chosen counts under "Not marked yet" until you pick one.
- The same page lists the clients that had gigs that year, so you can set each one right there (it saves at once), filter with the All / 1099 / Not taxed / Not set buttons, or use Mark all of them as to set every unmarked client in one step (it asks first).
- The setting is stored in the taxReporting column of the Venues tab (added automatically). It is private: it never appears on the website or the band page.
Add details later (deposit, etc.)
Choose the gig in Gig to change at the top and its details load. For a saved gig, a Gig tools panel appears with four groups: Payment (Mark as Paid), Calendar (invite status, who has accepted, Update invite, Check replies), Client (invoice) and Contract (upload the signed contract). It stays hidden on a brand-new gig until you save it the first time. The same three groups appear on each gig in Gigs. Edit anything, then press Save gig. You can also press Update gig on any gig in Gigs and it opens here ready to edit.
Signed contract: open the gig with Update gig and, in Gig tools → Contract, press Upload signed contract and choose the file (PDF, photo or Word, up to 15 MB). It is saved to Google Drive in a folder for the gig's year (inside the shared invoices folder), renamed Signed contract - gig name - date, and the gig shows a link to it. Pressing Replace contract uploads a new one and keeps the old file in Drive, renamed "Replaced ...". Only a link is stored in the Sheet, and contracts never appear on the website or the band page.
Money and private details (yellow dashed box)
Nothing in the yellow box is ever shown on the website.
- Money in from the client (green): agreed price, deposit, and a Balance Received tick box. Tick it when the client has paid everything that was left; the balance still due then becomes $0. Otherwise Balance still due from client is the price minus the deposit.
- Money out (orange): sound cost and pay per musician, with the total going out.
- Tip: type a tip received for the gig in the Tip box (whole dollars). It is only tracked: it does not change the balance due or the payout math, so note who it went to in Private notes. It shows on the gig card and in Money → Band account & tips.
- Band account (blue): what goes to the band account, with a check line that shows the fee minus money out minus band account. It says "adds up" when the numbers match, or how much is not assigned yet. Overpaying is allowed: if you pay out more than the fee, the line turns red with the amount, the band account goes negative, and it saves anyway. Write why in Private notes.
- Private notes at the bottom.
- A private client's address is no longer typed on the gig. It comes from that client's entry on Venues & Clients and is used on the calendar invite and invoice.
Musician pay
- Sound cost fills in from the sound person's default pay. You can type over it.
- Pay per musician splits what is left evenly between the musicians who do not have their own fill-in pay. It rounds down to the nearest $5 and the leftover goes to the To band account.
- You can go the other way: type an amount in To band account and the per-musician pay adjusts.
- For a fill-in with no default pay, a pay box appears. Type their pay. Tick Save as their default pay only if you want it remembered for next time.
- The line beside Balance due shows the total pay: green with what is left, or red with how much it is overpaid.
- Saving a gig also updates the Payouts tab for those musicians (sound person included). Payouts already marked paid are never changed.
- Declines and pay: when a musician declines a gig, whether on the band page or in Google Calendar, their unpaid pay line for that gig is set aside. It disappears from the Money page, the gig's payout list, "Mark as Paid" and the musician's own page, and the gig card shows "Declined, pay set aside" with the amount. If they accept again, it comes back at the same amount. Lines already paid, and gigs that have already happened, are never touched. A decline made in Google Calendar is picked up within about 20 minutes (or when you press Check replies). Their name stays on the gig until you replace them; when you swap in a fill-in and save, the new person's pay is added as usual.
Audit log
Open Settings and press Audit log (in the second row) to see everything that has been changed from the admin page: when, who (their Google account), what, which gig, venue or person it was about, the details (for a gig: each field that changed, old → new, including payout amounts), and whether it worked. Failed or blocked attempts show in red. Reminders and emails sent in the background (invoices, W-9s, reminders, the inquiry auto-reply) show as system (background). Search the log, pick one person, or show only failures. It is kept on the Audit tab of the Sheet, which only people with access to the Sheet can see. Passwords, tokens, and band members' phone numbers and emails are never written to it. Changes made by typing directly in the Sheet, or by band members on the band page, are not in this log.
Mark as Paid
Press Mark as Paid on a gig (in Gigs or at the top of Add / Modify Gig) once the musicians have been paid. It ticks them paid on the Payouts tab and the gig shows a Paid tag everywhere. The paidDate column on the Payouts tab records the day it was ticked (use it to see which calendar year each payment fell in); undoing clears it. Payments marked before this was added have no date.
Gigs page
- Shows every gig with its private details. Past gigs are hidden until you tick Show past gigs.
- Search by name, venue or musician.
- Orange means a sub / fill-in.
- The Public note under the location is what visitors see on the website.
Calendar invites and reminders
- Calendar event titles always start with CO84 Show: followed by the show name. An invite contains only: the show name, date, start time and length, venue, address, the public note, a line for each fill-in ("Abby is filling in on Vox"), and the musicians invited. It never contains pay, fees, deposits, contracts or private notes.
- Open a gig (Update gig) or find it in Gigs and press Send invite. Press it a second time within a few seconds to confirm. Every musician on the gig who has an email on the Musicians tab gets a Google Calendar invite with the date, time and address.
- Each gig shows Invite not sent or Invite sent, and beside each musician: Accepted, Declined, Maybe or Waiting.
- Many calendar events not in the app yet? Go to Settings → Import gigs from the band calendar, pick the year and press Scan calendar. Tick the events that are gigs (none are ticked for you), check the venue guessed for each, and press Import selected events. Each becomes a gig linked to its event, with the invited people added as musicians (matched by email on the Musicians tab). Sound cost is filled in for you from the sound person's default pay (Musicians tab), the same as when you add a gig by hand. If the event has a location, the Venue box starts on + New venue from the calendar location with the name and address filled in from it (edit them if needed): pressing Import creates that venue on Venues & Clients and links the gig to it. Choose + New private client for a private party so the address is kept private. A gig with a public venue chosen shows on the public website; one with "Keep off the website for now" stays hidden until you set its venue. If a gig already exists on that date the event is left unticked: open that gig and use Link instead. The same page also lists already-linked gigs missing people who are invited on the calendar, with one button to add them.
- Gig made outside this tool already has a calendar invite? Open it with Update gig, then in Gig tools → Calendar press Link to existing calendar event. It lists the events on the band calendar for that date; press Link this one on the right one. The event is not changed. After that, Check replies, reminders and automatic updates work as normal. If a musician on the gig isn't on the event yet, press Update invite (this also sets the event's title and details from the gig). Use calendar location (shown once a gig is linked) reads the event's location and lets you pick a venue, or create a new venue or private client from it; it changes only that gig's venue and address and never the event. Unlink forgets the link without touching the event. Only events on the band calendar can be linked.
- Fixing a typo without emailing everyone: tick Don't email the musicians about this change just above Save gig. The calendar event still updates (it changes on their calendars), but Google sends no email. It clears itself after each save. Renaming events, linking and importing from the calendar are always silent.
- You don't need to press anything. Every time you save a gig (new or changed), the calendar is updated by itself, but only when something that appears on the invite changed (name, date, time, length, venue, address, public note, or the musicians). Saving only pay or money changes sends nothing. The calendar is updated by itself and checked again afterwards. The message under Save says “Calendar updated and double-checked”, or tells you what went wrong. New musicians are invited, Google tells existing guests about changes, and cancelling a gig removes the event. Past gigs and gigs with no start time or no musicians are skipped, and the message says so. Press Update invite only to re-send the email to people who haven't replied (also the way to resend an invite that didn't arrive).
- Press Check replies to refresh who has answered.
- Deleting a gig: open the gig with Update gig and press Delete this gig at the very bottom of the form. It only appears when you are changing an existing gig. A window lists exactly what will happen: the calendar event is deleted and the musicians are told it is cancelled, unpaid payout rows are removed, and it disappears from the website. A gig with payouts already marked paid can't be deleted (mark them unpaid first, or set it to Cancelled). Invoice PDFs already in Drive are kept.
- Reminders: turn on Background sending in Settings (once, signed in as classof84band@gmail.com). Every morning around 9am, anyone who hasn't replied to an invite gets an email reminder, every 3 days, up to 5 times per gig. It stops when they reply or the gig has passed.
- Test reminder: Settings → Test the reminder email sends one reminder for a gig you pick to you only, written exactly like the real one. Nothing is changed and no musician is emailed. The link opens the event only if your own Google account is on that gig's invite; the page tells you whether you are.
- All invites go on the shared band calendar, so any admin can update an invite or check replies.
- Reminder emails always come from classof84band@gmail.com, so reminders can only be turned on or off while signed in to this page as that account.
- The first time you use this, Google asks you to approve Calendar and email permissions.
Invoices
- On any gig, press Create Invoice and Send. It builds a PDF invoice from the saved gig (show, date, time, venue, agreed fee, deposit and balance due), saves it in the shared Google Drive invoices folder, and shows a preview. Nothing is emailed yet.
- Check the preview. Fill in or fix Email it to and Attention (they come from the venue's contact on the Venues tab; a change here is used for this invoice only). Press Update preview to see changes.
- Tick Also attach our W-9 to the email if you want it to go with the invoice (it is not ticked unless you tick it; the venue's W-9 status updates when it goes out). Press Approve & email. It is emailed right away, with the PDF attached, from classof84band@gmail.com (sign in as that account to send). The gig then shows Invoice sent with the date.
- The gig needs an agreed price saved first. The invoice shows only the fee, any deposit or payment received, and the balance due. It never shows pay, sound costs or private notes.
- Where invoices are filed: in Google Drive, in a folder named for the gig's year (2026, 2027...) inside the shared invoices folder; signed contracts go in the same year folder. Settings → Google Drive → Sort existing files into year folders moves older ones there (safe to press again).
- Invoice numbers count up each year (2026-001, 2026-002...). Re-creating an unsent invoice keeps its number; creating a new one after sending gives a new number.
- Invoices are only emailed when you press Approve & email, and only from classof84band@gmail.com. If an invoice shows FAILED, check the recipient email and approve it again.
- Clients that don't need paperwork: on Venues & Clients, edit the venue or client and tick Does not need invoices. For every gig at that venue, the invoice buttons, tags, badges and Home reminders disappear. It is ticked by default for every venue and client, new ones included; untick it for a client that does need an invoice. (There is no setting for the W-9: it is only offered for venues and clients marked 1099.)
- Contacts: add each venue's contact name, email and phone in the Venues tab. Use + New venue or private client... on the gig form to add one (private clients get kind = private on the Venues tab). Picking a private client ticks Private event and asks for a gig name (e.g. Smith Wedding).
Sending our W-9
- W-9s are sent from Venues & Clients, not from gigs. Venues and clients marked 1099 show a Send W-9 button and a W-9 status on their card. Press it. A window shows exactly what will be emailed (to, subject, message, and that W-9.pdf is attached). Fix the email or contact name if needed, then press Approve & email.
- It is emailed right away from classof84band@gmail.com with the W-9 attached (sign in as that account to send). The venue or client card then shows W-9 sent with the date (and Send W-9 again if you need to resend). The status is saved on the venue, so it applies to every gig there.
- The email goes to the contact email saved for the venue or private client (the same one invoices use).
- Security: the W-9 stays in Google Drive and is attached only by the band account when it sends. It is never displayed on this page or put on the website.
Hide a gig or change what the website shows
- Tick Do NOT list this gig on the website at all to keep a gig off the public site (it still shows here). Tick Private event to list the gig but hide its venue and map.
- Cancelled gigs never show on the website.
- The website updates by itself from this sheet. A change can take a minute or so to appear.
Good to know
- Don't sort or reorder the Shows tab in the Google Sheet by hand. It can scramble the hide-from-website boxes.
- Add new musicians on their own tab in the Sheet. New venues and clients can be added right from the gig form (or on the Venues tab). Mark a musician's notes with the word band to have them ticked by default.
- Every gig needs a venue or client. You can't save a new gig, or import one from the calendar, without choosing one (add a new venue or private client from the list if needed). Older gigs that have none still show, but you will be asked to pick one the next time you save them.
- To let another person in, ask Adam to add their Google email and share the Sheet with them.
Instructions last updated: 2026-11-22 (fixed: Availability asks now show on Needs attention when the page first opens).
Everything changed from the admin page: when, who (their Google account), what, which gig or person it was about, and whether it worked. Reminders and emails sent in the background show as system (background). Newest first. Passwords, tokens and band members' phone numbers and emails are never logged.
| When | Who | What | About | Details | Result |
|---|