Home

Callings Tracker

Callings Tracker helps LDS stake leaders plan calling changes using Google Sheets.

Getting started

1. Open the stake or ward (in progress) version of callings-tracker
2. Click the Make a copy button, and then your copy opens in Google Spreadsheets
3. Rename it if desired
4. Click Callings->Setup->Create triggers, which should cause an Authorization Required box to appear
5. Click the Continue button to proceed to the Request for Permission box
6. Read what you're agreeing to, then click Allow
7. Click Yes when prompted to create and run triggers as yourself
8. After you've been notified the triggers have been created, click the Ok button to start using the spreadsheet

Using

First, a warning: Don't rename any of the worksheets, column headers, or change which rows are frozen. This will cause things to break. Maybe in the future version of callings-tracker it will be more resilient, but not so in this version.

Configuration

Worksheets

Callings sheets

• Callings - Pending: Callings and releases that are in progress
• Callings - Current: Members and the callings they're currently serving in. After a member's calling is complete in the Callings - Pending sheet, it will be moved to this until a release is considered.
• Callings - Archive: Members who have been released from callings are on this worksheet Configuration sheets
• Members: A list of stake/ward members that is used to populate the drop-down lists in the Member Name column on the Callings - Pending worksheet.
• Units: A list of wards/branches in a stake, available only in the stake version of callings-tracker.
• Leaders: A list of leaders who have set members apart. This list might have a future use at some point for calling assignments (e.g. the leader assigned to extend a calling).
• Positions: A list of positions in which a member may serve, along with the lifecycle of each position.
• Lifecycles: A list of lifecycles and the columns in the Callings worksheets that are used to track progress through each lifecycle.
• Actions: A list of actions and an assignment of each action to one of the Callings worksheets.

Callings menu items

• Sort callings: Sorts each callings sheet (Pending, Current, Archive)
• Organize callings: Sorts each callings sheet, then moves each row to the right sheet depending on its status
• Update calling status: Forces the statuses of callings on the Pending and Current sheets to be updated. Use this if status didn't update automatically on one or more callings.
• Format member list: Updates the Lookup name column in the Members sheet. Use this after updating the member information in the same sheet.
• Sheet->Reload configuration: Updates drop-down lists in configuration sheets and then stores the information for use in drop-down lists in the callings sheets
• Sheet->Show/hide configuration sheets: Toggles display of configuration sheets
• Sheet->Create triggers: Creates triggers that automatically update the calling sheets as they're being edited
• Sheet->Remove triggers: Remove triggers so that they can be re-created by another person
• About: Shows information about Callings Tracker

Updating an existing spreadsheet

1. Go here and copy all of the text to your clipboard
2. Open the spreadsheet from Google Drive
3. Click Tools -> Script editor... from the menu bar
4. Click in the area underneath the Code.gs tab
5. Press Ctrl-A to select all of the code
6. Press Ctrl-V to replace the code with what you copied to the clipboard in step #1
7. Press Ctrl-S to save Cods.gs
8. Click Resources -> Current project's triggers
9. Make sure the rows in the table match the following (use the Add a new trigger link to add a new row):

• onChange | From spreadsheet | On change
• onEdit | From spreadsheet | On edit

10. Click the Save button