FamilySearch Wiki:WikiProject Creating the Czech Archive Finder, Part 1

Project Leader
Heather Mecham

Task List
Task List

Purpose
Adding FamilySearch Collections to the Czech Gazetteer Google sheet.

Project Instructions
This project only needs to be completed in Google sheets.

Part 1
1. Go to the Task List. 2. Select a letter in the tab column to work on in the Czech Gazetteer Google sheet by putting your name in the name column. 3. Go to the Czech Gazetteer Google sheet and find the letter you selected, which will be across the bottom of the Google sheet. 4. Sort the sheet by the archive column (column E) by following the steps below.
 * a. Select the entire sheet by clicking the empty rectangle to the upper left of the sheet.
 * b. Go to the data menu and click "sort range".
 * c. Check "data has header row" box.
 * d. Select the column header "archive" which is column E.
 * e. Click sort.

5. You will use the table below to fill in columns F and G according to the name of the archive in column E. See part 2 for detailed instructions.

Part 2
1. Look at the name of the archive column in the Google sheet. In the screenshot below it says "Brno". 2. Find the archive in the table below. See screenshot below. 3. Look to the right of the archive to the columns with the headings "add to column F" and "add to column G" to see what needs to be added to the Google sheet for your archive. If it says "blank" leave the column blank on the Google sheet. If there is code to the right of the archive name, you will add it to the Google sheet.

6. Copy and paste the code from the table below into one line of the Google sheet. Then highlight the code you just pasted and copy it from the Google sheet.

7. Highlight all of the cells where you want to place the code and paste the code. If it says blank, leave that cell blank.