Help

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

Quickly see a list of all values in a field for filtering

Solved
Jump to Solution
252 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to quickly see all of the different values in a field, similar to how you can click to filter on a column in Excel and see all of the possible options (similar to screenshot from Excel below)?
2022-07-28_14-54-27

As an example, I have a field that is mostly blank but has a few records with varied single line text data. I want to quickly see what those different single line text lines are to see if I want to filter on any of them, but they’re not consistent enough to make it a single select field.

For another example, I have a field of various dates and would like to filter by certain dates, but don’t know all of the choices off the top of my head. Is there a way to quickly see the list of choices without creating a separate view or using a pivot table? Again, I could choose a type of ‘single select field’ but it doesn’t organize the dates nicely to see by year/month/day like you can see when clicking to filter values in Excel.
Thanks!

1 Solution

Accepted Solutions

Hey @Michael_W!
Welcome to the forums!

Short and simple answer: It is not possible to see all the possible values you can filter by for a single-line text field.


Presuming that you might be looking for a solution, I have a couple of suggestions for your use case.
Since it appears that you might be making the transition to Airtable from Excel/Spreadsheets/etc., something super important about working with Airtable is that treating it or comparing it to a spreadsheet will leave you frustrated, disappointed, and no longer willing to explore the platform.

Here is an example of a really flexible (and powerful) way to work with, view, and manage your data.


I created a table with 1,000 records with random date values.

image

Okay, so what if I want to sort them by their year?
My first thought is to leverage a formula. The date functions are amazing.
If you’re not really playing with formulas a ton, then I highly recommend
the formula field reference (and the playground). It’s incredibly helpful when learning to build formulas.

If I use the DATETIME_FORMAT function, I can quickly have Airtable tell me the year of each of the date values:

image

Okay, but that’s too simple. What if I want to look at more specific date values and sort/group/filter them that way?

You can tweak your formula to provide easily manageable values that you can quickly work with.

image

Using a bit of grouping, I can quickly organize my data into a format that I can easily filter and sort by.

image


There are tons of ways that you can achieve what you’re looking to do, this is just one of many ways you can do it.

See Solution in Thread

1 Reply 1

Hey @Michael_W!
Welcome to the forums!

Short and simple answer: It is not possible to see all the possible values you can filter by for a single-line text field.


Presuming that you might be looking for a solution, I have a couple of suggestions for your use case.
Since it appears that you might be making the transition to Airtable from Excel/Spreadsheets/etc., something super important about working with Airtable is that treating it or comparing it to a spreadsheet will leave you frustrated, disappointed, and no longer willing to explore the platform.

Here is an example of a really flexible (and powerful) way to work with, view, and manage your data.


I created a table with 1,000 records with random date values.

image

Okay, so what if I want to sort them by their year?
My first thought is to leverage a formula. The date functions are amazing.
If you’re not really playing with formulas a ton, then I highly recommend
the formula field reference (and the playground). It’s incredibly helpful when learning to build formulas.

If I use the DATETIME_FORMAT function, I can quickly have Airtable tell me the year of each of the date values:

image

Okay, but that’s too simple. What if I want to look at more specific date values and sort/group/filter them that way?

You can tweak your formula to provide easily manageable values that you can quickly work with.

image

Using a bit of grouping, I can quickly organize my data into a format that I can easily filter and sort by.

image


There are tons of ways that you can achieve what you’re looking to do, this is just one of many ways you can do it.