If you’re not sure what each row is supposed to mean, you can look at the example bases I published for more information. From there you can start adding your own rows. In order to use one of the templates, you will need to duplicate the blank copy your own account. You can watch my video about using the FAN Club Research Log here: How to Use Airtable to create a Genealogy FAN Club Research Log at YouTube How to Use the Templates You can choose any of the fields to group by. The grouping tool is helpful too, allowing you to group all the FANS that you listed by which record they were found on. After adding all these people, I sorted by last name, then sorted by first name, so I would be able to see people who appeared in records with my research subject more than once. There is a column for first name and last name. I also included witnesses on deeds and other associates. I added many names of neighbors on tax lists and census records. One of the best things you can do with this base is sort and group the people you track. Link to the record in the research log where the neighbor or associate was found. The FAN club table is for keeping track of the friends, associates, and neighbors found on each entry in the research log. One table is for your typical research log entries. This Airtable base allows you to keep track of friends, associates, and neighbors that you find as you keep your research log. As Diana and I were talking and doing a little research about various ways to track these extra individuals that don’t fit into the family tree, I realized Airtable would allow me to do so much more with the FAN club than tracking them in Google Sheets could. I created a FAN Club research log in Airtable after a podcast listener asked Diana and me to do an episode of Research Like a Pro about how to track and organize the FAN Club. You can then duplicate the base, delete the example rows of data, and begin tracking your own matches. To see my most recent Airtable base templates for keeping track of DNA matches, go to my Airtable Universe page and scroll to the bottom for the newest base. You can watch my video about using the DNA Research Log here: How to Use Airtable for a DNA Research Log at YouTube. If you’re ready to try it on your own, make a copy of the blank template linked below. To see how it works, you can view my filled out tables in the example. This allows you to track multiple messages and responses from the same match and see all the correspondence you’ve had with a match. Thanks to a suggestion from a reader, I updated the base to include a separate table just for correspondence. Originally, the base I made included two tables – one for DNA Matches, and one research log. DNA Research LogĪs I shared in my post “ DNA Research Logs: How to Keep Track of Genetic Genealogy Searches,” Airtable has become my new favorite tool for managing the DNA matches, correspondence, and traditional records used in DNA research projects. The videos are linked in the sections below. It saves me so much work, having all this information in one place.īecause Airtable is new to most people, I created two videos showing you how I use both bases. The entries in the research log are linked to the people that they go with in the other table. Both bases include my basic table/sheet for tracking genealogy research, and then another table for tracking DNA matches or friends, associates, and neighbors. ![]() I have published two bases, a DNA Research Log and a FAN Club Research Log. Airtable UniverseĪirtable Universe is a place where creators can publish their bases as templates for others to use. I’ve recently started using Airtable to keep track of friends, associates, and neighbors of my research subject also. I use it for large research projects that I’m working on over an extended period of time – like a DNA research project on a brick wall ancestor. This makes it different than a typical spreadsheet. My favorite part is that you can link records from one table into a field in a separate table. You can group records and sort records in various ways. Each sheet within the base is a “table.” Rows in a table are called “records.” Columns in a table are called “fields.” Each field is customizable. Each database is called “base.” Think of it as a spreadsheet with multiple sheets/tabs. If you are familiar with spreadsheets, you’ll pick it up right away. Luckily for us, Airtable is a database tool that doesn’t require that you know how to code. Most database tools are beyond the technological level of typical users, so most people don’t use database tools. Airtable is a hybrid spreadsheet and database.
0 Comments
Leave a Reply. |