+10I have an interface with a list layout. I was under the impression that when you searched the list it would search every visible column?
However when I search for fx “1073” it says there is nothing despite it being in my list?
Is this a bug, or is it me who is getting it the wrong way?
+5The list search in an interface with a list layout does not necessarily search every visible column. Instead, it typically searches only specific indexed fields. If "1073" is in your list but does not appear in the search results, it could be because the search function only includes certain columns, not all visible ones. Additionally, some searches may exclude numeric fields or require an exact match. Filters applied to the list could also impact search results. If the data was recently added, there might be a delay in indexing. If none of these factors explain the issue, it could be a bug, and checking system documentation or reporting the issue might be necessary.
+10Hi
It’s pretty old data, so I don’t assume Airtable take months to index data..?
The two columns I’ve exposed is both a concatenation which I assume will be a string and the other is number field.
If I fx only search for 10 it will find other columns where 10 appear yet still exclude the 1073.
How can you make exact matches for a search in airtable?
+5Airtable’s search functionality does not always work with exact matches, especially in concatenated fields or number fields only. Can you please try the below method of steps?
1. Use Filters Instead of Search
2. Check Field Formatting
3. Use the Exact Match Operator in Search Extension
4. Create a Formula Field for Search Optimization
5. Test in Different Views
+101. Use Filters Instead of Search
When I use filters that works - however the idea with the search is it’s a quick way to find something in your list.
2. Check Field Formatting
One of the fields is calculated column concatenating text and the other straight up number input.
3. Use the Exact Match Operator in Search Extension
Do you mean using “1073” if so that does not give me anything.
4. Create a Formula Field for Search Optimization
I’ve created various formular fields concatenating a info together, however none of them pick up on 1073
5. Test in Different Views
If I add a grid view to it’s still the same. I’ve tried to take the tabs of but no luck either.
😬
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
