Describe the problem/error/question
I cannot update row to NocoDB. The errors as photo below.
I cannot create Id Column in NocoDB Table. Errors is “Duplicate field name”, but there is no field called “Id” in my table
What is the error message (if any)?
Please share your workflow
{
“nodes”: [
{
“parameters”: {
“path”: “571dfe2b-c0d0-48f0-8c25-01b80172db3a”,
“options”: {}
},
“type”: “n8n-nodes-base.webhook”,
“typeVersion”: 2,
“position”: [
-420,
-20
],
“id”: “883f8140-df4d-47f8-83e2-eb3bbfaab40f”,
“name”: “Y/C Chỉnh HSKT - n8N”,
“webhookId”: “571dfe2b-c0d0-48f0-8c25-01b80172db3a”
},
{
“parameters”: {
“authentication”: “nocoDbApiToken”,
“operation”: “update”,
“projectId”: “pfsyb9hg3pitv1v”,
“table”: “m2nd7ec9etwzy89”,
“fieldsUi”: {
“fieldValues”: [
{
“fieldName”: “Kết Luận”,
“fieldValue”: “={{ $json.data.approved }}”
}
]
}
},
“type”: “n8n-nodes-base.nocoDb”,
“typeVersion”: 3,
“position”: [
20,
-20
],
“id”: “1c50988f-0d0d-4335-bd98-fe51a5903137”,
“name”: “NocoDB”,
“credentials”: {
“nocoDbApiToken”: {
“id”: “SA8CvjmTLctpXvsn”,
“name”: “NocoDB Token account 2”
}
}
},
{
“parameters”: {
“operation”: “sendAndWait”,
“sendTo”: “[email protected]”,
“subject”: “Approval Required”,
“message”: “You have a new request”,
“approvalOptions”: {
“values”: {
“approvalType”: “double”
}
},
“options”: {}
},
“type”: “n8n-nodes-base.gmail”,
“typeVersion”: 2.1,
“position”: [
-200,
-20
],
“id”: “c1d865b0-d138-4f0e-82d6-924887d599ac”,
“name”: “Gmail”,
“webhookId”: “73b037a4-66ed-48c3-9b9e-708985db3a90”,
“credentials”: {
“gmailOAuth2”: {
“id”: “M0x4GoMDyrgUicNU”,
“name”: “n8n-connect”
}
}
}
],
“connections”: {
“Y/C Chỉnh HSKT - n8N”: {
“main”: [
[
{
“node”: “Gmail”,
“type”: “main”,
“index”: 0
}
]
]
},
“Gmail”: {
“main”: [
[
{
“node”: “NocoDB”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “65060e67f10b7941004a6be86d2b27dec96065c9cda96d52cf840bec529243cb”
}
}
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Share the output returned by the last node
Information on your n8n setup
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
