Tracking Petz With Airtable

I have used AirTable to track petz stuff for awhile. My personal one is on the crew page. As it's gotten extremely complex, I thought I'd make a simpler version for people to use with some basic instructions.

Petz Tracker Template

See the Airtable documentation on how to Duplicating an existing base for info on how to copy it. You'll need to make an Airtable account and full disclosure I may receive some AirTable credits which will feed my data addiction (I use AirTable for tracking my clothing too).

I added some demo data and comments but here are some instructions.


CleanShot 2021-09-04 at 20 36 16@2x

  1. There are three tables: Petz, Show Pictures, and Show Tracker. "Pets: tracks your pets basic info. "Show Pictures" is a place to upload individual pictures for entering shows. And "Show Tracker" is for tracking show entries and results. Each table is connected. "Show Pictures" connects to a Pet to get data on show name and call name. Each Show Tracker entry is associated with a Show Picture, so then that data can be used to calculate a pet's total show points. Airtable is pretty powerful so there are all kinds of other tables and calculations you could add if you wanted. For example, I have a "family tree" table that connects pet entries together to show a pet's children and parents.
  2. Views are used to display a table. The basic one used here is the "Grid" which is like a spreadsheet. I used the "Gallery" one for my Crew page.
  3. You can add a new pet to the table here. Feel free to add more fields like date of birth, breed, or anything else you want to track.

Show Pictures

CleanShot 2021-09-04 at 20 44 53@2x

  1. The show table is a bit more complicated. If you use it correctly it can generate code to paste on a forum so it's easier to enter shows. It will only work if you only have 1 picture per show picture record though.
  2. This field connects the show picture to the pet. Without that connection the forum code won't have the right show or call name.
  3. Forum code. If this works you can just copy and paste it on most show forums.

Show Tracker

This is meant for tracking each individual entry. So one picture you entered in one show. Then you can also track how many points (if any) the entry won. This is used for calculation a pet's total points. You can get fancy with this, for example I have another table in my main AirTable that tracks different types of shows, different awards, and more. But I wanted to keep this one relatively simple.