Help

Count number of children in a family

Topic Labels: Base design
Solved
Jump to Solution
988 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kate_Jacobs
5 - Automation Enthusiast
5 - Automation Enthusiast

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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!