7. Lookup tables

Video Courses

All Courses

Steward: giving

About this course1. The Steward dashboard2. Sessions, and the life of a session3. Starting a session4. The entry grid and the keyboard5. Who gave it: envelopes, names and anonymous gifts6. A new donor in the middle of counting7. Payment methods, cheques and split gifts8. The counted total and the live difference9. Possible duplicates10. Saving, refreshing and two laptops11. Counters, the review and Submit12. Posting a session13. Correcting a posted gift14. Gifts in kind15. Interac e-Transfers16. Deposits and bank reconciliation17. Donors and the donor profile18. Merging duplicate donors19. Pledge campaigns20. Recurring gifts21. Online giving22. Refunds and card disputes23. Year-end CRA receipts24. Fixing and sending receipts25. Reports, imports and event revenue26. Who sees giving

Gather: services and attendance

About this course1. Gather at a glance2. Service Schedules and the calendar3. Children's rooms and who counts as a child4. Building an Order of Service5. Starting, completing and cancelling a Service6. Opening check-in7. Lookup mode: finding people fast8. New visitors and first-time visitors9. People with no date of birth10. Person Categories: who counts as a child, and the attendance breakdown11. Printing labels12. Checking in children13. Allergy and medical alerts14. Children's Pickup15. Member QR codes and Scan mode16. The family check-in code17. Express Check-in18. Clicker headcounts and Roster mode19. Many devices, and finishing check-in20. Self check-in kiosks21. Attendance records and corrections22. Absence alerts23. Attendance reports24. Events and the public calendar25. Registrations and paid events
Video Courses

Lookup tables

Setting up your church · Lesson 7 of 16

The choices in your dropdowns: add, rename, switch off and delete, and what each table decides.

Read it in the guide

Transcript

In this lesson, you'll set up your lookup tables: the choices in your church's dropdowns, in your own words.

Lookup tables are the choices in your church's dropdowns: transaction sources, fund categories, membership statuses, payment methods, onboarding stages, household relationships, prayer categories, group types and person categories. Rename them to your words.

Add Entry asks for a code, which never changes, and the label people see, then a colour and where it sorts. Code and label are required, and a code can't be used twice.

Edit renames it, and Save keeps it. Everything already filed under it follows, because they point at the code.

Switch an entry off, and it leaves every dropdown but keeps its history. Switched-off entries hide here too: Show switched off brings them back into the list.

Delete removes an entry for good, once you confirm. An entry in use can't be deleted: a status people hold, a group type groups use. The built-in system entries can't be deleted either. Switch those off instead.

Membership Statuses have two more columns. New people: the one status a person starts on. And Counts as a member: which statuses your member figures count. The Flock course sets them.

Payment Methods each have a Type: physical, electronic or unclassified. It decides which side of a service's giving a method counts on. Switching a method off never drops its gifts from a total.

Person Category is your church's own way of grouping people, under the name you choose. Until you add an entry, it appears nowhere in SanctuaryOS.

Super Admins, Lead Pastors and Finance Admins add and edit entries; only a Super Admin deletes. Grace, the treasurer, has no Delete.

That's lookup tables. Next, funds and the fiscal year.