Signed in for 12 hours on this device. Ten wrong tries locks the page for 15 minutes.
Loading…
Add someone who didn't check in
The weekly email, from the posts
Everything live on the home page right now, in date order. In LCR (Send a Message): paste the subject, Copy formatted and paste into the message — headings, bold, links and lists come through; images don't, so tick the flyers below, Download selected (.zip), unzip, and drop the whole set into the Attachments box. Copy plain text is there if you ever need it.
Every event carries Add to calendar links (Google, and an .ics file for Apple / Outlook), and the header points at calendar.html, where people subscribe to the whole ward calendar once. The files behind those are published by the Google script whenever a post changes.
Flyers to attach
Tick the ones to send, then Download selected gives you one .zip — it unzips to a folder, so select all in the folder and drag them onto LCR's Attachments box (or use its Browse button and pick them all at once).
Preview
Plain-text version
Loading…
This week's announcements email — the text shown under the posts on the home page
This week's announcements
Edits go live on the home page within a minute. Every Sunday night the new email replaces this automatically.
What the tags mean
- Warning
- Attending a YSA ward is optional — we're telling them that if they don't start showing up, their records go back to their home ward. Send the warning message on their slide texts/emails them and records the date.
- Magnet
- Their records came in without a new-member meeting, so they're being sent back to their previous ward. Send the magnet message does the same for this case.
- Move Aged out
- From a note in parentheses after the name on the sheet, e.g. "Shane Woods (aged out)". Other Notes itself is just text — nothing is read out of it.
- Nothing yet Proposed Texted Answered / Declined Accepted / Sustained
- Where the calling stands, from the Proposed / Who texts / Texted / Answer / Sustained columns.
- new not on sheet
- new = moved in within the last 30 days (LCR's move-in date; it drops off by itself). not on sheet = on LCR's report but with no row on the sheet yet — Add to sheet on their slide (or Add all on this filter) makes the row, pre-filled from LCR and their move-in form.
- Has a calling?
- On the sheet and still on the ward roll, but no longer on LCR's Members without Callings report — so a calling was most likely recorded in LCR. Check their Callings/Classes tab in LCR; once it's done, Remove on their slide takes them off the sheet.
- Not in LCR
- On the sheet but not on the ward roll at all — their records moved out (or were never here). Remove deletes the row.
- Ready to move out
- The warning / magnet message went out long enough ago (21 days for Warning, 7 for Magnet — change it under Settings) that it's time to move their records. The date comes from the "Flag sent" column, which is filled in automatically when you send from here or can be typed in.
- ✎ pending
- Edited here on the site; it goes into the Google Sheet the next time the sync runs.
- Left off · reason
- Leave off… on a slide hides someone from the working lists (Everyone, the flag lists, New / not on sheet) with a reason tag — attends another ward, lives out of the area, and so on. Their sheet row and notes stay. They show under Removed / left off, where Back on the list takes the tag away.
- Removed Left off the sheet
- Remove on a slide takes someone off this list: their row is deleted from the Google Sheet and they stay hidden until LCR stops listing them (records moved, or a calling recorded). (Left off the sheet is the older version of Leave off, for people who never had a row.) Both are under the Removed / left off filter, where Back on the list undoes it.
Loading…
Open the callings sheet ↗ Open the new-member responses ↗ Click a row to open that person. In the meeting, use ← → (or swipe) to move through people; Esc closes.
Import / refresh members from JSON
Paste the JSON produced by the LCR sync script (array of members). Members missing from the list are marked inactive.
Loading…
Building cleaning
Each Saturday you add here goes on the home page, in the weekly email and the ward calendar as a post, and cleaning.html takes the names. Anyone can put a name down — their own or someone they called.
Defaults for new Saturdays
Loading…
Missionary meals
meals.html: the North Sisters and the South Sisters, one meal each per day. A brother taking the sisters out names the sister coming along; each set of sisters is fed in its own area (the area text below shows on the page). The phone number is only shown to someone who has just booked. The Elders row stays off unless elders are ever assigned to the ward.
Companionships, areas, numbers
Book a meal for someone (phone sign-ups)
Loading…
Check-in windows
Times are Eastern. Outside the window the button on the home page greys out and says when it opens; check-ins are refused by the database too.
Bishop meeting requests
Every request from bishop.html is texted to this number the moment it comes in (name, phone, email, temple-recommend, note) — the executive secretary, usually. Leave it blank to stop the texts; the requests still land in the Inbox either way. Needs supabase/bishop.sql.
Warning / Magnet messages
What Send the warning / magnet message on a person's slide sends. {first} = first name, {name} = full name. Texts go out through the ward's SimpleTexting number; emails go through the Google account running the script (set up in scripts/announcements.gs) and can show a different from address once that address is added under Gmail → Settings → Accounts and Import → “Send mail as” in that account. Please read these through as a bishopric before the first send.
Once that many days have passed since the "Flag sent" date, the person shows a red Ready to move out tag and appears in that filter.
Warning
Magnet
Check texting (SimpleTexting)
Sends one short text through the Google script so you can confirm the SimpleTexting token works, without messaging a member.
Text list sync (new member form → SimpleTexting)
Whoever ticks agree on the new member form’s “Automated Messages” question (and gives a phone number) is added to the SimpleTexting list, with the form date kept on their contact as the consent record. It runs after each sheet sync (every 6 hours), never re-adds anyone who replied STOP, and never removes anyone.