Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Help tracking a specific type of data

157 1
Showing results for 
Search instead for 
Did you mean: 

So I’m in the legal field and I’m trying to track from different judges a percentage of damage that is associated to a specific body part. The goal is to be able to predict what % a judge gives on average for any given body part. The trouble I’m running into is figuring out the best way to connect a % to each body part. I currently have one Multiple Select Column for body parts, but I really need those body parts to have some way to be attached to a %. (I was currently just putting it down in a long text field, but that doesn’t allow me to track what I want to track).
Airtable Problem

Any advice is greatly appreciated.

1 Reply 1

You need to have a separate table for Body Parts and then create a junction table to connect it to judges: