Airtable update a mulitple select field

Hi, i’ve been trying to update a multiple select field on airtable and it doesnt look like it’s working

The node data that i am sending to airtable looks like this

The multiselect fields are Product and Stakeholder. The airtable node responds with a success, but the fields are not updated on the airtable. I’ve also tried to send these fields as an array with no luck. It responds similarly

Hi @Nikhil_Bhaskar, thanks for reaching out!

You might need the Airtable node’s typecase option for this (you can find it after clicking Add Option in the left panel of the node):

Once enabled, my array got inserted into Airtable as expected:

image

Here’s the whole workflow:

{
    "nodes": [
      {
        "parameters": {
          "values": {
            "string": [
              {
                "name": "Name",
                "value": "Demo"
              },
              {
                "name": "Multiple select",
                "value": "={{[\"foo\", \"bar\" ]}}"
              }
            ]
          },
          "options": {}
        },
        "name": "Set1",
        "type": "n8n-nodes-base.set",
        "typeVersion": 1,
        "position": [
          592,
          208
        ]
      },
      {
        "parameters": {
          "operation": "append",
          "application": "appkKbkTXAWBLK8eB",
          "table": "Table 1",
          "options": {
            "typecast": true
          }
        },
        "name": "Airtable1",
        "type": "n8n-nodes-base.airtable",
        "typeVersion": 1,
        "position": [
          792,
          208
        ],
        "credentials": {
          "airtableApi": "mutedjam"
        }
      }
    ],
    "connections": {
      "Set1": {
        "main": [
          [
            {
              "node": "Airtable1",
              "type": "main",
              "index": 0
            }
          ]
        ]
      }
    }
  }

Could you give this a go and let me know if you’re still running into trouble afterwards?

1 Like

@MutedJam Hi it worked, thanks for the solution

1 Like