Jul 08, 2020 06:44 AM
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).
Solved! Go to Solution.
Jul 08, 2020 07:50 AM
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.
Jul 08, 2020 07:50 AM
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.
Jul 08, 2020 11:14 PM
It worked! Thanks so much!