Filter different fields on search records airtable module

Getting Started
,
1

Hello, I’m quite new with make.com. and I’m trying to get a filter from airtable database. Basic I have a table with that fields:
Property: House, flat, apartament
Value: 100, 200, 200
place: Germany, Italy, Spain, France

I’m using search records airtable module. But I don’t know what sintaxis of formula should be to get all house in Italy and spain, more than 150.

Can anywone help me? thanks in advance.

2

Hi @ivan5,

I think that Formula should look something like this:
“OR(
{Place} = “Italy”,
{Place} = “Spain”
)”

I recommend you check the formula documentation here: Airtable Formula Field Reference | Airtable Support

Let me know if you need anything else :smiley:

3

thanks for your answer, and sorry if i didn’t explain well, the filter should be: Property “house”, place: “Italy or Spain”, and Value more than 150.

4

@ivan5 try this:

AND(
    {Property} = "house",
    OR({Place} = "Italy", {Place} = "Spain"),
    {Value} > 150
)

Edit: Updated the Quotes. Thanks for spotting it @dilipborad

5

Hello @Juliusforster,
Your formula is correct but when the user copies from the response those double(”) or single quotes do not work well with Make’s syntax. It needs to be replaced with this ".
You can understand the difference between ” and "

I recommend you add a code block using three backtick
```
your code or formula
```

The output will look like this.

AND(
    {Property} = "house",
    OR({Place} = "Italy", {Place} = "Spain"),
    {Value} > 150
)

This response structure supports all markdown editor syntax.
Check this some of the basic examples from community posts.

:+1:

6

Well spotted! That was totally my mistake.