These tools are archived and no longer maintained. Their successor is ShulBase.

Manage My Shul

There is a better way

Member Database

One master list of members that every other list is generated from — the cornerstone of the other tools here.

Introduction

As explained on the home page, the function of the Member Database is to create a central location to manage all lists. The basic concept is that all the information related to each Shul member, family member and guest is located in one Google Sheet. That information is used multiple times in other tabs within that sheet (or workbook, in Excel vernacular) and in other sheets. When updating or adding a member to the master list, their information gets populated on any other list they belong to, based on the information chosen on the master list. Each sublist has specific fields and specific formatting for its intended use, and contains only the type of member that belongs on that list. Keep on reading the sections below and this will become clear.

Set up

Members Info

This tab contains all information for all Shul members and family members.

  1. Contact information — name, address, phone number
  2. Member type — regular, occasional, family
  3. Notification preferences — email or SMS, for billing, membership and simchas
  4. Information for Aliyas — Hebrew name and father’s name, כהן\לוי\ישראל
  5. Yartzeit info, wife’s Hebrew name, and father’s and mother’s name for Mi Shebeirach

Gabbai List

A list for the Gabbai automatically gets populated from the member database.

  • This is a tab in the worksheet that will automatically add each member that has a name for Aliya listed
  • This list is automatically sorted by כהן-לוי-ישראל
  • All you need to do is print this sheet out; it updates itself based on the information added to the member database

Aliya Cards

Similar to the Gabbai list above, a list of names and information for Aliya cards is generated based on the member database.

  • On the member database there is a column where you can choose yes/no to control which people cards are printed for, as you don’t necessarily want to print cards for all family members and guests
  • This list updates itself