I’m having an issue with the Airtable update node where it successfully updates certain fields but completely ignores one field, despite showing successful execution.
Setup:
n8n version: 1.110.1 (Self Hosted)
Airtable node version: 2.1
Operation: Update record
Data flows from Switch node → Email node → Airtable update node
Problem:
The update node successfully updates “Due Date” and “Task Name” fields but the “Attempt” field (Number type) remains unchanged at 0, even though the expression should increment it to 1.
What I’ve Tried:
Multiple expression formats: {{ $json.Attempt + 1 }}, {{ $json[“Attempt”] + 1 }}, {{ parseInt($json.Attempt) + 1 }}, {{ $json.fields.Attempt + 1 }}
Verified the Attempt field exists in Airtable and has type “Number”
Confirmed the input data contains “Attempt”: 0 in the correct data structure
Tested different ID matching expressions for the record lookup
All other fields update correctly using similar expression syntax
Current Configuration:
Columns to match on: id
ID (using to match): {{ $(‘Search Task Records’).item.json.id }}
Attempt field: {{ parseInt($json.Attempt) + 1 }}
Input Data Structure:
json{
“id”: “recRA7QDaEjSwoFkD”,
“fields”: {
“Attempt”: 0,
“Task Name”: “No Feedback-Day 3”,
“Due Date”: “2025-09-23”
}
}
The node reports successful execution with correct Record ID, but only some fields actually update in Airtable. Has anyone encountered selective field updating behavior like this?
Here is the json;
{
“name”: “3. Nudges for filling feedback form”,
“nodes”: [
{
“parameters”: {
“rule”: {
“interval”: [
{
“triggerAtHour”: 8
}
]
}
},
“type”: “n8n-nodes-base.scheduleTrigger”,
“typeVersion”: 1.2,
“position”: [0, 224],
“id”: “0c9381a3-6e92-4e09-95d5-11e60157b610”,
“name”: “Schedule Trigger”
},
{
“parameters”: {
“operation”: “search”,
“base”: {
“__rl”: true,
“value”: “YOUR_AIRTABLE_BASE_ID”,
“mode”: “list”,
“cachedResultName”: “CRM Database for Scotia AI”
},
“table”: {
“__rl”: true,
“value”: “YOUR_TABLE_ID”,
“mode”: “list”,
“cachedResultName”: “Tasks”
},
“filterByFormula”: “{Status}=‘Waiting’”,
“options”: {}
},
“type”: “n8n-nodes-base.airtable”,
“typeVersion”: 2.1,
“position”: [224, 224],
“id”: “9123a05a-8d69-46f9-8c86-2cd17e6e9eea”,
“name”: “Search Task Records”,
“credentials”: {
“airtableTokenApi”: {
“id”: “YOUR_CREDENTIAL_ID”,
“name”: “Airtable Personal Access Token account”
}
}
},
{
“parameters”: {
“rules”: {
“values”: [
{
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “loose”,
“version”: 2
},
“conditions”: [
{
“leftValue”: “={{ $json.Attempt }}”,
“rightValue”: “0”,
“operator”: {
“type”: “string”,
“operation”: “equals”
},
“id”: “a79ff1ad-b7ce-43aa-9a8c-9dead017acec”
}
],
“combinator”: “and”
},
“renameOutput”: true,
“outputKey”: “Day 3”
},
{
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “loose”,
“version”: 2
},
“conditions”: [
{
“id”: “118e5efe-b71a-4bb6-8787-7fafaa0fe463”,
“leftValue”: “={{ $json.Attempt }}”,
“rightValue”: “1”,
“operator”: {
“type”: “string”,
“operation”: “equals”,
“name”: “filter.operator.equals”
}
}
],
“combinator”: “and”
},
“renameOutput”: true,
“outputKey”: “Day 5”
},
{
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “loose”,
“version”: 2
},
“conditions”: [
{
“id”: “169b6bd4-28a0-4751-8385-809895d631b4”,
“leftValue”: “={{ $json.Attempt }}”,
“rightValue”: “2”,
“operator”: {
“type”: “string”,
“operation”: “equals”,
“name”: “filter.operator.equals”
}
}
],
“combinator”: “and”
},
“renameOutput”: true,
“outputKey”: “Day 7”
},
{
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “loose”,
“version”: 2
},
“conditions”: [
{
“id”: “8529e117-d98e-479d-8d78-9e569a827aea”,
“leftValue”: “={{ $json.Attempt }}”,
“rightValue”: “3”,
“operator”: {
“type”: “string”,
“operation”: “equals”,
“name”: “filter.operator.equals”
}
}
],
“combinator”: “and”
},
“renameOutput”: true,
“outputKey”: “Day 9-Final email”
}
]
},
“looseTypeValidation”: true,
“options”: {}
},
“type”: “n8n-nodes-base.switch”,
“typeVersion”: 3.2,
“position”: [880, 192],
“id”: “a187b257-cf54-403b-be1a-19012bd5d207”,
“name”: “Switch”
},
{
“parameters”: {
“sendTo”: “EMAIL_PLACEHOLDER”,
“subject”: “We Haven’t Received Your Chatbot Feedback Form Yet”,
“message”: “Email content here…”,
“options”: {}
},
“type”: “n8n-nodes-base.gmail”,
“typeVersion”: 2.1,
“position”: [1104, -64],
“id”: “206b30ae-2ddd-4d49-8fe5-962de6e9e158”,
“name”: “Send 1st nudge (3 days)”,
“webhookId”: “WEBHOOK_ID_REMOVED”,
“credentials”: {
“gmailOAuth2”: {
“id”: “YOUR_GMAIL_CREDENTIAL_ID”,
“name”: “Gmail account”
}
}
},
{
“parameters”: {
“operation”: “update”,
“base”: {
“__rl”: true,
“value”: “YOUR_AIRTABLE_BASE_ID”,
“mode”: “list”,
“cachedResultName”: “CRM Database for Scotia AI”
},
“table”: {
“__rl”: true,
“value”: “YOUR_TABLE_ID”,
“mode”: “list”,
“cachedResultName”: “Tasks”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {
“id”: “={{ $json.id }}”,
“Status”: “Waiting”,
“Task Name”: “No Feedback-Day 3”,
“Attempt”: “={{ parseInt($json.Attempt) + 1 }}”,
“Due Date”: “={{ $now.plus({ days: 3 }).format(‘M/d/yyyy’) }}”
},
“matchingColumns”: [“id”],
“schema”: [
{
“id”: “id”,
“displayName”: “id”,
“required”: false,
“defaultMatch”: true,
“display”: true,
“type”: “string”,
“readOnly”: true,
“removed”: false
},
{
“id”: “Attempt”,
“displayName”: “Attempt”,
“required”: false,
“defaultMatch”: false,
“canBeUsedToMatch”: true,
“display”: true,
“type”: “number”,
“readOnly”: false,
“removed”: false
}
],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.airtable”,
“typeVersion”: 2.1,
“position”: [1328, -64],
“id”: “7fe20e68-c39b-4ac5-a75d-131f0e93d377”,
“name”: “Day 3”,
“credentials”: {
“airtableTokenApi”: {
“id”: “YOUR_CREDENTIAL_ID”,
“name”: “Airtable Personal Access Token account”
}
}
},
{
“parameters”: {
“base”: {
“__rl”: true,
“value”: “YOUR_AIRTABLE_BASE_ID”,
“mode”: “list”,
“cachedResultName”: “CRM Database”
},
“table”: {
“__rl”: true,
“value”: “YOUR_LEADS_TABLE_ID”,
“mode”: “list”,
“cachedResultName”: “Leads”
},
“id”: “={{ $json[“Related Lead/Client”][0] }}”,
“options”: {}
},
“type”: “n8n-nodes-base.airtable”,
“typeVersion”: 2.1,
“position”: [448, 224],
“id”: “09b0fe87-c00d-47dc-b44c-f84962a0cabb”,
“name”: “Lead Lookup”,
“credentials”: {
“airtableTokenApi”: {
“id”: “YOUR_CREDENTIAL_ID”,
“name”: “Airtable Personal Access Token account”
}
}
},
{
“parameters”: {
“base”: {
“__rl”: true,
“value”: “YOUR_AIRTABLE_BASE_ID”,
“mode”: “list”,
“cachedResultName”: “CRM Database”
},
“table”: {
“__rl”: true,
“value”: “YOUR_TABLE_ID”,
“mode”: “list”,
“cachedResultName”: “Tasks”
},
“id”: “={{ $json[“Related Tasks”][0] }}”,
“options”: {}
},
“type”: “n8n-nodes-base.airtable”,
“typeVersion”: 2.1,
“position”: [656, 224],
“id”: “fa8eccc3-8017-48e3-8223-b27d08d40012”,
“name”: “Get a Task”,
“credentials”: {
“airtableTokenApi”: {
“id”: “YOUR_CREDENTIAL_ID”,
“name”: “Airtable Personal Access Token account”
}
}
}
],
“pinData”: {},
“connections”: {
“Schedule Trigger”: {
“main”: [
[
{
“node”: “Search Task Records”,
“type”: “main”,
“index”: 0
}
]
]
},
“Search Task Records”: {
“main”: [
[
{
“node”: “Lead Lookup”,
“type”: “main”,
“index”: 0
}
]
]
},
“Switch”: {
“main”: [
[
{
“node”: “Send 1st nudge (3 days)”,
“type”: “main”,
“index”: 0
}
]
]
},
“Send 1st nudge (3 days)”: {
“main”: [
[
{
“node”: “Day 3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Lead Lookup”: {
“main”: [
[
{
“node”: “Get a Task”,
“type”: “main”,
“index”: 0
}
]
]
},
“Get a Task”: {
“main”: [
[
{
“node”: “Switch”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“active”: false,
“settings”: {
“executionOrder”: “v1”
}
}
