Maintaining Directory Information
The directory information resides on the “Persons” tab in the FCCUCC Affiliated Names and Addresses Google sheet and personal images are located in the Directory Images Google folder.
Maintaining Directory Information
The directory information resides on the “Persons” tab in the FCCUCC Affiliated Names and Addresses Google sheet and personal images are located in the Directory Images Google folder.
The google sheet tab pictured in Figure 1 captures information for individuals, their life partners and up to 6 offspring. The data consists of names, addresses, phone numbers and birthdays. Birthdays are kept to make it possible to send folks birthday cards/notices. Not pictured are death date and joined year which are dates to be memorialized and celebrated, respectively.
Figure 1: Persons Tab
The primary objective of the information is to produce a pictorial directory (see image below).
In addition to handling links to person images, the Google sheet allows FCC to maintain a Google doc for variable information about each person. When an individual provides an image (PNG or JPG files are expected) for the directory it is stored in the Directory images Google drive folder using a naming convention based on the person's name. The individual specific google docs, similarly named, are stored in the Person Specific Docs Google drive folder. Each personal Google doc is intended to contain free form biographical information provided by the individual, but can also detail such things as talents, hobbies and interests and historical data such as church committee membership and leadership history.
The tables depicted in Figures 2 and 3 are updated by pulling down the "FCC SCript" menu and selecting "Update Google Drive File Lists". Note that in the example appearing in row 7 of "Name" column in Figure 2, text appears in red, highlighted yellow and struck through. This indicates that the image found in the folder does not correspond to an individual or it is named properly. In practice, the underscore (_) character is substituted for the quotes that surround a person's nickname, if specified, to make it a valid PC file name.
Figure 2: List of Google Docs on the Personal Gdocs tab
Figure 3: List of Images on the Personal Images tab