Search unique linked records

Topic Labels: Formulas
274 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

0 Replies 0