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.