Favor Church Service Runsheet Application
Translation pending
ProductivityTypeScript · JavaScriptGitHub @favorchurchOnlineOwner unconfirmed
Have you tried it? One tap is enough. No sign-in needed.
No updates detected yet. GitHub releases will appear here.
GitHub star growth between the latest completed 8-hour observations
DeepSeek Harness Remote can securely connect a phone or another computer to the computer where you run DeepSeek Harness, so you can continue your work anytime and anywhere, check progress anytime, and continue working.
AI translation
Self-hosted, sharable kanban for humans and agents. One 4.5 MB binary, 4.5 MB of RAM, 10 to 60 tokens per agent reply, starts in 2 ms, zero setup.
Ayakaleaf Pro is a free, open-source, self-hosted Overleaf alternative: Overleaf Community Edition with almost all Server Pro features — track changes, project history, admin panel, SSO, Git-bridge, Z
Fold papers, web pages, files, and AI replies into five levels of detail. Zoom from an overview to the original text.
Owners of public repositories under a personal GitHub account can sign in to verify ownership and manage the introduction themselves. No administrator approval is needed.
Sign in, generate a verification file, and commit it to this repository’s default branch within 30 minutes. Files on other branches or forks do not count. Then check the file below to manage the project without administrator approval. Keep the file to retain your access.
If needed, you will go to sign-in. After signing in, return here and press your chosen verification button again.
Run /nomorevibe verify in your project folder to verify ownership and manage the introduction yourself.
Verify in one minuteAsk about other verification options
The maker's introduction consists of the line above. Read the repository README for more details. Repository README ↗
Loading the full README.
Read the full README ↗A spreadsheet-style editor for Favor Church service runsheets, backed by Rock RMS.
A runsheet is a Rock ContentChannel; each segment is a ContentChannelItem. The grid's columns are the channel's item attributes, so they are discovered at runtime rather than hardcoded — a new attribute in Rock shows up as a new column.
pnpm install
pnpm dev # http://localhost:3000
Required environment variables (.env.local):
| Variable | Purpose |
|---|---|
ROCK_API_URL / NEXT_PUBLIC_ROCK_API_URL | Rock REST API base, e.g. https://rock.favor.church/api |
ROCK_API_KEY | Rock API key. Never commit this. |
AUTH0_* | Auth0 config — see auth0.config.js |
REDIS_URL | Optional; the Rock object cache is skipped when unset |
pnpm build # production build (lint + typecheck included)
pnpm typecheck # tsc --noEmit on its own
pnpm test # run full test suite (jest)
pnpm test:full # run full test suite (jest)
pnpm test:unit # run unit tests
pnpm test:integration # run integration tests
pnpm test:changed # run tests for files changed since last commit
pnpm list:channels # print the Rock channel ids that hold runsheets
See docs/testing.md for test tiers, commands, and environment variables (JEST_MAX_WORKERS, JEST_VERBOSE).
src/
app/ Next.js App Router entry, root layout, global CSS
components/runsheet/ The editor UI
RunsheetManager Channel picker and load/create flow
RunsheetTableEditor The grid: rows, merged time cells, drag reorder, save
RichTextCell Tiptap editor mounted on the cell being edited
RichTextToolbar One formatting bar, acting on the open cell
RichTextContent Read-only renderer for every other cell
PeopleSearchDropdown Picker for Rock Person-backed columns
server-actions/ The only write boundary to Rock — see its README
auth0-hooks/ Auth0 session plus Rock-backed authorization helpers
lib/ richText, sanitizeRichText, runsheetTime, logging
constants/ client.ts (public), server.ts (secrets), runsheet config
types/ Shared shapes; Runsheet.ts covers the grid
util-date/ util-rock/ util-connect/ Pure helpers
scripts/ One-off operational scripts
tests/ Jest setup and module mocks
public/ Static assets served at /
Text cells are rich text. Click a cell to edit it and use the formatting bar
above the grid: bold, italic, underline, strikethrough, text and fill colour,
alignment, lists, and clear formatting. Cmd/Ctrl+B, I and U work as usual.
Enter saves the cell, Shift+Enter adds a line inside it, Escape closes it.
Values are stored as a small subset of HTML (src/lib/richText.ts defines the
allowlist). Cells written before this editor used **bold** / ~~italic~~
markers, and those are converted on read, so old runsheets keep their formatting
without a migration. Rock's own ContentChannelItem.Title column is written as
plain text so Rock's admin screens stay readable; the formatted title lives in
the ACTIVITYTITLE attribute.
Person-backed columns (Rock field type 18, plus keys containing PLATFORM,
ANCHOR or PREACHER) stay a people picker rather than a rich-text cell — the
stored value has to remain a resolvable person name.
Each runsheet supports attaching preacher notes (PDFs) uploaded to Rock RMS Asset Manager:
PreacherNotes/<CAMPUS>/, named YYYY-MM-DD <Service Time> <original name>.pdf from the runsheet title (Rock stores spaces as _, e.g. 2026-10-06_7PM_Sermon.pdf). A name Rock already holds gets _2, _3, … Each file is referenced in the channel's PreacherNotes attribute.RunsheetManager lists a fixed set of
channel ids and calls getRockContentChannelOptions() without using the
result. It should instead fetch the runsheet channels the signed-in user can
actually see in Rock. pnpm list:channels is the stopgap for finding ids.rockResolveAccess only resolves
campusIds, so the section helpers in auth0-hooks/server/ always see empty
lists. They are inherited from the Connect portal this app was split out of.rockBulkSaveRunsheetItems issues a handful of Rock
requests per row, so saving a long runsheet takes a few seconds.