Hey guys, I am new to AirTable. Here is the problem I am facing
I have 2 tables, Apartments and Locations
1. An apartment can only have 1 Location.
2. A location can have multiple apartments.
I want to do an API call to filter apartments with some contraints which will return me a max of 100 apartments.It is possible that all those 100 apartments belong to 1 location so my end result is 1 location. Is there any way I can add a filter that returns me unique values?
Eg. If apartment 2 has the same Location as Apartment 1, return it just once and continue. I want my end result to be 100 locations in 1 API call.