Skip to main content

Hi everyone 👋

I’m building matchmaking system using Airtable + Make, and I’m stuck on the neighborhood matching

Here’s my setup:
 

Properties table

  • {Address} field (e.g. Monterrey Street, Roma Norte, CuauhtĂ©moc)
  • {Neighborhood} (single select → “Roma Norte”,

Clients table

  • {Preferred Neighborhoods} (multi-select or linked) – clients can choose multiple neighborhoods they are interested in.

    In Make.com, I also created a variable neighborhoods_string that looks like this (from {Preferred Neighborhoods} r] array) :
    Parres El Guarda|Isidro Fabela|San Pedro MĂĄrtir|Miguel Hidalgo 3ÂȘ SecciĂłn|San AndrĂ©s Totoltepec|Tlalpan Centro|Tlalcoligia|San NicolĂĄs Totolapan|HĂ©roes de Padierna|Jardines del Pedregal|Roma Norte

    What I want to achieve:

  • Check if the property’s {Neighborhood} (or extracted from {Address}) exists in the client’s {Preferred Neighborhoods} o] or neighborhoods_string  list.

    Can anyone help me? that would mean a lot to me..I thought this was just an easy “contains” formula.

Just considering this from an Airtable angle, your issue is that you need a 3rd “Neighborhoods” table in your base. In your property table instead of a single select it’s a linked field to the Neighborhood table, and in your client table preferred neighborhoods is also linked to the Neighborhoods table. Then you can add a lookup in your client table that shows all the associated properties records for each neighborhood they prefer. 

Hey ​@mr_Stress,

I think this might useful? Sharing just in case.. Unless I’m missing smth, I don’t think you really need to use Make for this. But again I might be missing smth!
 


Mike, Consultant @ Automatic Nation 
YouTube Channel

Hi
I can’t see a simple way to make it in the format you want.
But I can see 2 possible workarounds:
Make ‘Interested Neighborhood’ a Single-Select, add more in order to let user select several.

This method has it’s flaw - you need to provide sync between these Single-Selects, when you add new option, you should add it into all fields 
 

Use new feature. Interesting, I tried it first time and it works. I just added Neighborhood Multi-select field from Clients and Single-select form Properties. Maybe it depends how many AI creds you have,  and how they will be used. At least you can make a try.

 



If these two methods not OK for you, then you definitely need a controlled way to establish a match between Neighborhood and Address - the 3rd table, as ​@DisraeliGears01 proposed.

Reply


Terms & Conditions