Tracking DNA Matches with Airtable - A Step-By-Step Tutorial

[@staggargirl]

Hi Nicole, you mentioned that you use Airtable to help specific research questions, but you don't use it to track all of your matches from all of the companies. For that, you said that you would use a spreadsheet. Could you explain a little about your reasoning with that? Also would love to see an example of what your workbook structure looks like (worksheets, column headers, etc). Thank you. I enjoy your podcast and your RLP with DNA book has been very helpful. 🙂

[@madisonrogers3148]

I'd also like to know the answer to your question!

[@kategordon44]

Hi Nicole, this is a fabulous tool that I am FINALLY using! I am having difficulty in trying to track both the GD and the cMs of multiple male testers. The problem arises when I enter 0 for the cM amount with a shared match. Let me explain... WG, CP, and DA have all tested both with Ydna on FTDNA and separately on Ancestry for the autosomal. WG and CP match on both the Y and the autosomal. DA matches WG and CP ONLY only on the Y. I need to capture that there is no cM match between DA and WG and DA and CP. Capturing this helps the algorithims in both DNA Painter and Banyan. Soooo, when I enter 0 for the amount of shared between DA and either CP or WG, the formula spits out 0 GD. Which if I were not careful, would lead me to think they had a much closer GD than they do (4 between them all). How can I separate the cm calculation field from the GD field?

[@nedyer]

Great question. I would add a column for type of test - Y-DNA vs. autosomal. Then change the formula for the cM/GD column to depend on the type of test column. You can use AI to help you write a formula now, even with the free plan, so it probably won't be difficult!

[@CyndiDavis-ep1jp]

What about a video on using the timeline and research log for documentary research

[@CyndiDavis-ep1jp]

Wondering why you don't use look up fields or formulas or something to eliminate retyping or copy/pasting sources or citations

[@FamilyLocket]

We only put our citations in one place in the log. If it's something we knew at the start of the project, it goes in the timeline with the applicable citation. If it's a source we found after making our research plan and following it, we cite that in our research log. The formula field could make citations for you, if you type in all the other required info for it, and that's an interesting idea. I will have to look into that!

[@cherylmedlin530]

Hey Nicole. This session was fantastic. Quick question - What is the difference in your table between labeling someone a "test taker" and labeling them a "DNA match"?

[@nedyer]

Hi there. I differentiate the two by thinking of test-takers as people whose DNA test results I have access to. DNA matches are those who match the test-takers.

[@cherylmedlin530]

@@nedyer Thanks so much!

[@jodieriedmann6175]

Hi Nicole. Thanks for some great information. Airtable won't let me open either of your links in this description and they aren't showing up when I search you in the Universe. Any thoughts? Cheers

[@FamilyLocket]

There's an error with Airtable right now, but Airtable let me know they are fixing it and it should work soon.

[@jodieriedmann6175]

Thanks and for all this too!😊

[@Disblair]

Wow!!! I’ll definitely be giving this a miss.