The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Dec 28, 2024 02:08 AM
I am new to the free version of Airtable which I am using to keep track of my craft stamps. I have at the moment around 500 items which have sentiments listed. When I try to find a particular sentiment I search for eg has any of, but it gives me "enter comparison value" and all the sentiments I have created. What I want is just a search box so I can just type just one word eg happy, so all those sentiments are found. What have I done wrong please and how can I rectify it.
Solved! Go to Solution.
Dec 28, 2024 07:39 AM - edited Dec 28, 2024 07:39 AM
re: Sorry how do I filter by status? I don’t seem to have that option .
Ah, here are some step by step instructions, sorry for the confusion!
1. Create a 'Formula' type field: https://support.airtable.com/docs/formula-field-reference
2. In that field, reference the 'Sentiment' field. It should look like this:
3. In your filters, use that new formula field which should now let you filter by 'contains':
---
re: I’m using the free version would that matter?
Nope, wouldn't matter!
===
I'd also suggest checking out the Airtable academy to familiarize yourself with some of the functionality if possible! https://academy.airtable.com/
Dec 28, 2024 06:56 AM
Hmm, could you provide screenshots of your table set up and of how you're trying to filter? This is what it looks like for me when attempting to filter by a long text field, for example
Dec 28, 2024 07:06 AM
Dec 28, 2024 07:11 AM
Ah, you want to do a partial filter on a multiple select field! To do that, try creating a formula field that'll output the multiple select field's values; this effectively creates a text version of the multiple select field's values which you can then filter by:
Dec 28, 2024 07:20 AM
Sorry how do I filter by status? I don’t seem to have that option .
I’m using the free version would that matter?
Dec 28, 2024 07:39 AM - edited Dec 28, 2024 07:39 AM
re: Sorry how do I filter by status? I don’t seem to have that option .
Ah, here are some step by step instructions, sorry for the confusion!
1. Create a 'Formula' type field: https://support.airtable.com/docs/formula-field-reference
2. In that field, reference the 'Sentiment' field. It should look like this:
3. In your filters, use that new formula field which should now let you filter by 'contains':
---
re: I’m using the free version would that matter?
Nope, wouldn't matter!
===
I'd also suggest checking out the Airtable academy to familiarize yourself with some of the functionality if possible! https://academy.airtable.com/
Dec 28, 2024 08:27 AM
Thanks so much Adam that worked great. Looked at the academy and it blew my mind. I don't think I need to know that much depth for organizing my craft room. but thanks again, I really appreciate you taking the time to help