Updated: Jul 5
Hello volunteers! This blogpost explains how to navigate the spreadsheet from a phone.
Watch the video below to visually and verbally follow the spreadsheet instructions:
Read the instructions below for a written explanation of the spreadsheet:
If you are using a tablet or phone, your home page will look like this. Unfortunately, internal links on Google Sheets don’t work as well on your device. The links to our volunteer coordinators, social media and help using the spreadsheet should work just fine though.
Step 1: Choose which country you would like to write to from the Write To... header
(If you already know which home you would like to write to skip to step 5).
Step 2: Once you have chosen, click the small stack of lines at the lower left of your screen.
Step 3: This menu will open:
Scroll down until you see the name of the country you want to write to, followed by the word “Page”.
For example, if you choose to write a card or letter to a facility in the United States, scroll to “US Page”.
Step 4: You will see a list of homes to write to that are organized either by state/province or by language (depending on how you choose to write cards and letters). The homes and facilities are color coded depending on what kind of facility they are. The key is at the top right of the spreadsheet. You can learn more about what each color means HERE. The homes in grey have been filled and do not require any additional cards and letters. You will see how many additional cards and letters each home needs in the Letters Still Needed column. After scrolling through this list of homes and facilities, find the one you want to write to, remember its name and the state it was located in. You will need this information for the next step.
Step 5: Click the small stack of lines at the lower left of your screen. Scroll down until you see the name of the country you want to write to, followed by the words “Sign Up”.
For example, if you choose to write a card or letter to a facility in the United Kingdom, scroll to “UK Sign Up”.
Step 6: Now you will locate the home or facility you are looking to write to. First look for the state where the facility is located. The names of the states can be found inside the lavender colored rows. Now that you have found the state, scroll down to the home or facility that you chose in step 4.
Step 7: Find a blank pink box to the right of the Claimed by (id) grey box. Click on that pink box and type your ID number into it. Hit the Check Mark at the right side of the screen to save your change. The box with your ID number should automatically turn green. If you’d like to write more than one card or letter, click on another blank pink box and type in your ID number again. Each box is your commitment to write one card or letter.
To see how to navigate the spreadsheet from a computer, click HERE.