Airtable and GDAT

 Genimate Sharon left this comment on a recent post of mine.

Jill

Do you prefer Airtable to the Genealogical DNA Analysis Tool for managing your DNA kits? Or do they have different purposes? What are your other uses for Airtable?

I realised that it would probably be better to respond here in a post where I can share images than to write a lengthy comment on my earlier post

Firstly I need to point out that although I have been using DNA as a genealogy research tool for around 9 years I still class myself as a basic user. I am not particularly interested in the science behind my DNA matches, my focus is on making connections.

My uses of Airtable and GDAT are for different purposes.

I use Airtable to maintain records of the DNA matches for all the kits I manage and GDAT for chromosome analysis of matches. It's taking me a while to get my head around GDAT, I am currently using it just for my matches and (if I ever get competent) will use it for the other kits I manage.

I had previously used spreadsheets to keep track of all my matches but, after seeing two demonstrations of Airtable at Rootstech 2021: https://www.familysearch.org/rootstech/rtc2021/session/how-to-use-airtable-for-a-dna-research-log and https://www.familysearch.org/rootstech/rtc2021/session/airtable-organizing-your-research-with-a-relational-database, I went exploring. 

I realised that I could link various sheets together and this would mean that I could remove some data from my Excel spreadsheets (tables on Airtable) to secondary sheets (tables) linked back to primary sheet (table). On Airtable one can have Workspaces that store Bases which can contain multiple Tables.

The following image shows what my homepage looks like on Airtable. One can have multiple Workspaces - I just have one.

The Bases in my Airtable Workspace

In my DNA Management - JPC Base I track matches for the seven kits I manage that share my ancestors. Within this base I have four tables that are related to the primary table.

The Fields I have on JPC Matches are: Kit Name, Surname, Forename, Kit Manager, Line (4 grandparents), DNA Painted, GDAT, Test Site, Columns for each match, % of Aboriginalty, Relationship to me, Match line. this next image shows part of the setup.

Further fields to the right of this image are match location, notes, and a link to the Match Details table.

You will note plenty of empty spaces as each cell is not pertinent to each tester. This is a work in progress where I add every match I find for those seven people. Each test one person does has a separate record.

I love that I can set up Multiple Select Fields for easy data entry which I use for Line, Testing Company, DNA Painted and GDAT.

Multiple select fields save typing

The possibilities for use of this program are endless. setup is easy, data entry uncomplicated and there are so many means of sorting, sifting and analysing data. There are many templates available in the Airtable community that one can use and modify to a situation.

Another way I use Airtable is to keep track of my genimates. Over the years I have met so many folk in person and online. It's good to be able to quickly find their details when my poor old memory fails. 

My Genimates base has these tables.

Genimates has details of the people I have met, Terms manages my Geneadictionary entries (which links back to Genimates), Blogs has details of various blogs (links to Genimates and Societies), Websites has details of various websites (links to Genimates and Societies), Societies/Hosts (links to Blogs, Websites and Presentations) and Presentations manages my gigs and links back to Societies/Hosts.

After playing around with Airtable for a couple of months I took out a subscription because some of my bases grew to be too large (more than 1200 records) to be covered by a free account. I also wanted the flexibility to create more bases than allowed in a free account. I have read of other genies (watch the two videos from Rootstech) who use a free Airtable account successfully for their projects.

I plan on using GDAT for chromosome analysis. The GDAT website says "Genealogical DNA Analysis Tool (GDAT) is an app that utilizes autosomal DNA to aid in the research of family trees. The app houses a database of the autosomal data downloaded from various testing companies and provides analysis tools for family history research." 

While it's a challenge for this old girl I understand that GDAT is the gold standard for chromosome analysis. I have managed to download my matches from several other sites to GDAT and am slowly getting to know the product. I would love to have someone to hold my hand on this journey. 

Caroline Chisholm

I turned green with envy when, earlier this week, I saw a photo on Facebook of my GeniMate, Sharon Brennan, posing beside Caroline Chisholm's grave in Billing Road Cemetery outside London.

http://image1.findagrave.com/photos250/photos/2008/247/27034110_122057179528.jpg

Sharon's subsequent blog post told of why Caroline Chisholm was important to her and why she made the journey to Billing Road. I made a comment that  Caroline Chisholm  was important to me because her interview with my convict ancestor, Patrick Curry, was published in the Sydney Morning Herald in 1848. Having access to this interview gives me an insight into Paddy's life on Camden Park Estate that I would not otherwise have had.

As my blog has a few more readers than it had when I posted the following to a Carnival of Genealogy in August 2010; I will repost it here for new readers to see.

The Gift of the Gab

My ancestor Patrick "Paddy" Curry as an Irishman from Limerick probably had the gift of the gab but, as he died 130 years ago, I never had the chance to meet him.

Fortunately some of Patrick's words were preserved in a Sydney Morning Herald article from Thursday 8 June 1848. This and many other great stories can be found at The National Library Of Australia's Trove website.

For this 21st edition of the Carnival of Genealogy I am posting a copy of that article in which Paddy demonstrates that he had The Gift of the Gab.

Sydney Morning Herald 8 June 1848

 This post has been prepared for  the 21st edition of the Carnival of Irish Heritage and Culture

Abundant Genealogy - Week 2 - Paid Online Genealogy Tools

Week 2 – Paid Genealogy Tools: Which paid genealogy tool do you appreciate the most? What special features put it at the top of your list? How can it help others with their genealogy research?


Horses for courses!


Having just read my mate Sharon Brennan's response to this question I could just copy and paste her response here because, on first thoughts the content in my post was going to echo hers. So I have thought for a few minutes and have decided on a different tack.


My paid subscriptions are: 
Ancestry.co.uk - I've had an annual subscription for years and cannot kick the habit as each time I think about letting it go they add new record sets that are pertinent to some part of my research.  It is the top level sub that gives me access to all Ancestry Records and has been useful for Australia, UK, Canada, New Zealand and the US.


FindMyPast.co.uk - I am also a longtime subscriber. As most of my ancestors came from the British Isles it is relevant to my research. I find it helpful that it duplicates some of the records on Ancestry and have found information on FMP transcriptions that Ancestry have missed.


I let my Genes Reunited sub lapse last year as I found that I was not making any new valuable connections through it. Around seven years ago when I joined up I made many useful connections but it has outlived its usefulness for me.


I regularly take out short-term subs to Scotland's People and The Sydney Morning Herald Archives when I have a good list of questions, some time on my hands and the ready cash.


My genealogy societies and local libraries give me access to other paid resources that I use on an as needs basis.


So Which paid genealogy tool do I appreciate the most?


It may be one of the resources listed above or it may be some other. The tool I appreciate the most is the one that gives me the answer I am presently seeking. 


Just like I wouldn't choose a sprinter for a two-mile race, a Shetland Pony to drag a heavy load, or a Shire horse for dressage I wouldn't choose the Sydney Morning Herald to find a Scottish birth Certificate or FindMyPast.co.uk to find my Canadian soldier.


The horse I appreciate the most is the one that will get the best job done for me.