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

Easily filter an autopopulateted field

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

Hi, I have a table with sub-categories where I want to be able to choose, from a multiple-select list, the lowest level and auto populate the higher level, e.g. if I choose “Banana” I want the higher level to automatically become “Fruit”.

I have managed to do this with an IF-statement, but my solution doesn’t give such a user-fiendly filtering option. The IF-statement I have created returns the statement as a string, so when I want to filter the category I manually have to write in “Fruit”. I would instead like to filter it by selecting “Fruit” from a list (as you can do with for instance a multiple-select list). Is it possible to do this when autopopulating a field?

Thank you in advance!

1 Solution

Accepted Solutions

Not ideal, but you can keep your formula field, create a single select field, and use Automations to copy the value of the formula into the single select whenever the formula value changes. That way you can filter based on the single select field which will have a more user-friendly filter experience.

See Solution in Thread

1 Reply 1

Not ideal, but you can keep your formula field, create a single select field, and use Automations to copy the value of the formula into the single select whenever the formula value changes. That way you can filter based on the single select field which will have a more user-friendly filter experience.