Newsletter, LDS tools, and Sacrament Programs

Discussions about the Newsletter Tool at LDS.org.
ag_boy
New Member
Posts: 23
Joined: Sun Feb 23, 2014 9:12 pm

Re: Newsletter, LDS tools, and Sacrament Programs

Postby ag_boy » Sun Nov 27, 2016 10:59 pm

For anyone interested in a template for Sacrament Meeting Programs, using Google Docs, please follow the links included here.

There are two docs:
1) A word-style template for the actual program. It uses multiple tables for layout, like a web page. Easily modified.
2) A bulletin spreadsheet that records speakers, songs, and musical numbers. It dynamically finds hymn numbers based on an included song database, and pulls all this data into a sheet which can be directly copied and pasted into the program template. There are a lot of formulas to process the data, so some ranges are protected with a warning (you can edit them all)

This has been a fantastic tool to remote coordinate with the music director and bishopric as many of our people travel the world, and can still fulfill their duties. It eliminates a lot of emailing, as the people who need to affect the program information have direct access to it.

Program layout
https://drive.google.com/open?id=1sQwtH ... kkDE8bIghc

Spreadsheet
https://drive.google.com/open?id=1Vgy8h ... vjF10zxS7s


Please copy to your local Google account and share as needed.


And at all times, lobby the church website folk to include this kind of functionality locally for everyone without the use of Google ;)

ag_boy
New Member
Posts: 23
Joined: Sun Feb 23, 2014 9:12 pm

UPDATED LINKS - Newsletter, LDS tools, and Sacrament Programs

Postby ag_boy » Mon Nov 28, 2016 9:44 pm

Updating the links for the Sunday Program bulletin

Please use these links instead:

Program layout
https://docs.google.com/document/d/1sQw ... bIghc/copy

Spreadsheet
https://docs.google.com/spreadsheets/d/ ... zxS7s/copy

ag_boy
New Member
Posts: 23
Joined: Sun Feb 23, 2014 9:12 pm

Re: Newsletter, LDS tools, and Sacrament Programs

Postby ag_boy » Mon Nov 28, 2016 9:48 pm

The first links will allow you to see the documents. If you want to make a copy and edit the files for your own use, please log in to your google docs account first, and then click the new links.

This should make a copy to your local Google account, that you can edit at will.


Return to “Newsletter”

Who is online

Users browsing this forum: No registered users and 1 guest