Air table node filter formula

Questions
1

Hello,

I would like to get data only for today by using filter. i managed to get today date using “function node” ,
however, i do not know how to enter in the filter using formula to filter “Date(Night)” value.

Any kind assistant is greatly appreciated. :grinning:

image
image1782×889 106 KB

2

@Benjamin123 below is an example workflow to achieve this. The expression inside the “Filter By Formula” parameter would look like:
{Date(Night)} = "{{$json["date"]}}"

Where {{$json["date"]}} is a reference to the data created in Date & Time node (in this case, I’m just referencing the node payload coming into the Airtable node).

Here is Airtable’s official reference for their Formulae: https://support.airtable.com/hc/en-us/articles/203255215

{
  "nodes": [
    {
      "parameters": {
        "value": "={{new Date().toISOString()}}",
        "dataPropertyName": "date",
        "toFormat": "YYYY-MM-DD",
        "options": {}
      },
      "name": "Date & Time",
      "type": "n8n-nodes-base.dateTime",
      "typeVersion": 1,
      "position": [
        450,
        300
      ]
    },
    {
      "parameters": {
        "operation": "list",
        "application": "appxhaX88hWXJT1GW",
        "table": "Table 8",
        "additionalOptions": {
          "filterByFormula": "={Date(Night)} = \"{{$json[\"date\"]}}\""
        }
      },
      "name": "Airtable",
      "type": "n8n-nodes-base.airtable",
      "typeVersion": 1,
      "position": [
        650,
        300
      ],
      "credentials": {
        "airtableApi": "cloud demo 2"
      }
    }
  ],
  "connections": {
    "Date & Time": {
      "main": [
        [
          {
            "node": "Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}```
3

Hello MaxTm

Thank you for your help… however, when i try to use the filter formula, it is not finding anything.

image
image1233×559 15.1 KB

image
image1667×826 78.4 KB

image
image1595×827 74.1 KB

4

Hey @Benjamin123,

The Date fields in Airtable work a bit differently. I am assuming the Date(Night) field in your Airtable has the type date and not text. If that’s the case, the above formula will not work. You will need a different formula that uses date with it.

5

I ran a quick test, and if you’re using the Date field, you will have to use the iS_SAME() method. In your example, it should look like IS_SAME({Date(Night)},"{{$json["yesterday"]}}")

I hope this resolves your issue :slight_smile:

6

Thank you harshil1712,

i wasn’t still able to find the value. is it because my “date(night)” value is inside the “fields” array and i would require it to include “field” in the filter ?

image
image1495×782 72.5 KB

7

Hey @Benjamin123,

With the expression that I shared, are you still getting 0 items? I tested the formula with static date and it worked well.

8

hello harshil1712,

yes, i am still getting 0 item.

image
image1534×538 16.2 KB

image
image1531×673 25.8 KB

9

Hey @Benjamin123,

I created a small workflow to try it out, and I am getting the expected result. Here’s the workflow

You can copy and paste the workflow in your n8n instance. You will have to configure your credentials, Base ID, and the Table name.

10

Hello harshil1712,

it works…thank you very much… :grinning:
but the strange thing is when i copy the same formula back to my existing work flow, it is not working…

i will study all the node in my work flow again to see what went wrong…

11

maybe there is a bug…i delete my existing airtable node and recreate a new node, it is working well…