Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Count number of children in a family

Topic Labels: Base design
Solved
Jump to Solution
580 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, I am still an Airtable newbie. We are trying to set up a database of families receiving food from our NGO. I have one table set up for the families (with information like their address, intake records, etc), and one for the records of each individual (with information like birthdate, school reports, gender, etc). I have managed to get column showing the number of individuals in each family (on the family table) and one showing which individuals are children (on the individuals table).

Is there a way to get a column on the family table that gives the number of children (under 18s) in each family? (something like a combination of a count and formula field).

1 Solution

Accepted Solutions

You want a Conditional Count field. For your count field, set the condition to only count records where the age of the child is under 18. You may need to create a formula field for the age of the child.

See Solution in Thread

2 Replies 2

You want a Conditional Count field. For your count field, set the condition to only count records where the age of the child is under 18. You may need to create a formula field for the age of the child.

It worked! Thanks so much!