# Filtering Airtable Database
**URL:** https://community.thunkable.com/t/filtering-airtable-database/1224320
**Category:** Questions about Thunkable X
**Tags:** help, airtable
**Created:** [April 14, 2021, 7:14pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320 "2021-04-14T19:14:12Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@aanshi6](https://community.thunkable.com/u/aanshi6)
#### Post date: [April 14, 2021, 7:14pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/1 "2021-04-14T19:14:12Z")
Hello,
I am trying to filter though the gender on an Airtable database. I have a list of 10 values and I want to be able to display how many are female, male, or other (I am starting with just finding how many females). I have looked through the forum for help, but I wasn’t able to find anything that worked. Does anyone have an idea how I can make this work?
Pic of my database:
My code so far (Note: Button 1 is the one that says female):
The result (After pressing button 1):
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [April 14, 2021, 7:17pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/2 "2021-04-14T19:17:18Z")
This should give you a good start
[https://x.thunkable.com/projectPage/5fb9fb1dbfeb240011084d78](https://x.thunkable.com/projectPage/5fb9fb1dbfeb240011084d78)
---
### Author:  [@aanshi6](https://community.thunkable.com/u/aanshi6)
#### Post date: [April 14, 2021, 7:19pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/3 "2021-04-14T19:19:08Z")
I have seen many similar projects, but I don’t really understand how they work. I don’t want to have a list viewer component visible on my screen, so is there a way to work around that?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [April 14, 2021, 9:23pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/4 "2021-04-14T21:23:57Z")
The list viewer is just a tool/component to show the result. You can choose to show it in many different ways.
---
### Author:  [@aanshi6](https://community.thunkable.com/u/aanshi6)
#### Post date: [April 15, 2021, 12:45pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/5 "2021-04-15T12:45:24Z")
I don’t really understand how I can get the row id without using a dataviewer
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [April 15, 2021, 1:57pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/6 "2021-04-15T13:57:53Z")
If you connect to the table using the Data Sources option then you can use the block [List of values] and choose the column to be “ID”. This will give you a list of row IDs of all rows in the table.
---
### Author:  [@aanshi6](https://community.thunkable.com/u/aanshi6)
#### Post date: [April 15, 2021, 2:24pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/7 "2021-04-15T14:24:23Z")
Thank you! This really helped me!
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [April 15, 2021, 6:49pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/8 "2021-04-15T18:49:46Z")
@aanshi6 I realize the data itself might not be generated by you but I would encourage you to consider inclusive language when requesting a person’s gender and also consider that sex (“Male”, “Female”) is often equated with gender when it shouldn’t be.
A couple links:
- [Sex and Gender Identity](https://www.plannedparenthood.org/learn/gender-identity/sex-gender-identity)
- [Inclusive Language Guidelines: Gender Identity | Institutional Planning & Analysis | CSUSM](https://www.csusm.edu/ipa/surveys/inclusive-language-guidelines.html)
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 1:25pm UTC](https://community.thunkable.com/t/filtering-airtable-database/1224320/9 "2024-11-08T13:25:15Z")