Details

Title: Tracking DNA Matches with Airtable, 2nd Edition
Series: Research Like a Pro Quick Reference
Author: Nicole Elder Dyer
Publication: February 2026 by Family Locket Books, Highland, Utah (First edition from 2023)

Digital Download

Tracking DNA Matches with Airtable is available as a PDF download. You will receive two files – one for professional printing on two legal-sized (11×17″) paper, and the other for at-home printing on four letter-sized pages (8.5×11″).

Permission to Print

Purchasing the download authorizes you to print one copy of the Tracking DNA Matches with Airtable guide for yourself only. Please do not share the digital files with others.

What’s new in the 2nd Edition:

• Revised and simplified explanations throughout

• Updated formula guidance and wording (including notes on AI-assisted formula creation in Airtable)

• Revised to include updates in the RLP with DNA template 4.2 (2026) with significant changes in the DNA Match Details table and People table, including Person 1 (P1) and Person 2 (P2) instead of Test-Taker and DNA Match, and lookup fields for the roles and trees of P1 and P2 in the People table

• Details about the reorganized and expanded People Table fields (including usernames, tree URL 1, tree URL 2, admin fields, kit management fields, correspondence links, and more)

• Updated terminology and labeling for improved clarity

The guide includes the following sections:

• About Airtable
• Key Terms (for Airtable and DNA)
• DNA Base at Airtable Universe
• Using the RLP with DNA Base Template
• Sorting, Grouping, and Filtering
• Configure Views – DNA Match Table
• Sorting and Grouping DNA Matches
• Adding Details in Expanded View
• Formula Fields
  • Primary Field for the DNA Match Details Table
  • Average Segment Size
  • Formula for Checking if Shared DNA is within the Relationship Range
  • One Standard Deviation from the Mean
• Tracking DNA Matches
  • DNA Match Details Table Fields
  • People Table Fields
• Tables in the RLP with DNA Base
  • DNA Match Details
  • People Table
  • Kit Access Table
  • Correspondence Table
  • Timeline Table
  • Research Log Table
  • FANs Table
  • Segments Table
  • Surnames Table
  • Locations Table
  • Shared cM Table

The new Airtable Research Logs for Genealogy (3rd Edition for 2026) is available here: Airtable Research Logs for Genealogy – Quick Reference, 3rd Edition.