Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

FilterByFormula in multiple items column

3248 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Luc_Palomo
4 - Data Explorer
4 - Data Explorer

Hi,

I have a list of clients that can be in multiple markets (6k markets). The markets column is pulling form another table.
With the FilterByFormula, I need to create a filtered list of all clients in a specific market. The problem is that the API does not include in the results records where multiple markets are listed in the Markets column.

For example, client A is in Paris, client B is in Paris and Madrid. The final list will only show client A. How can I get client B on the list too?

If anybody knows how to fix it that would be help a lot.

2 Replies 2

Welcome to the community, @Luc_Palomo! :grinning_face_with_big_eyes: While I haven’t used the API yet, one possible workaround comes to mind. Instead of searching the clients based on their linked markets, search the markets for their linked clients. If you search the [Markets] table for all clients linked to the Paris record, it should give you the results you seek.

kuovonne
18 - Pluto
18 - Pluto

What does your filterByFormula value look like a runtime?

To use filterByFormula, I recommend building the filter as a formula field in the native Airtable user interface. Then base your filterByFormula on that formula.

In your case, it sounds like your filterByFormula might be testing for equality. Instead, try testing to see if you can FIND the target city in the field.