How to update an Airtable record to return empty instead of current data

Questions
1

Describe the problem/error/question

n8n is returning an error when I attempt to fill up a field with {{null}}, or {{“”}}, how can I erase the data from an airtable field?

What is the error message (if any)?

‘Category’ expects one of the following values: [enrolled, trial, extra lesson, pending reg, rejoin, agent, relief, test, overdue] but we got ‘’

Please share your workflow

Share the output returned by the last node

ExpressionError: Invalid input for 'Category' [item 0]
    at validateValueAgainstSchema (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1277:15)
    at getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1314:18)
    at Object.getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1590:24)
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/actions/record/update.operation.js:77:52)
    at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/actions/router.js:48:79)
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/AirtableV2.node.js:20:32)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:658:42)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:631:68
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
5

Hi @Dennis_Yu, I am very sorry you are having trouble. Sending null should work in theory, even for a single input field. I’ve just tested this on the current version of n8n 1.7.1:

image
image1910×835 63.9 KB

Your error ExpressionError: Invalid input for 'Category' would suggest a problem with the expression you have in use though. Can you confirm the exact version of n8n you have in use and the input data you are referencing in your Airtable node?

6

I am currently running on 1.4.1, self hosted server. I’ll get some help updating it if necessary.

The interesting thing to note is that for the linking field “Trial”, it was able to erase the array completely with the {{ “” }} input

Side note, the field on your example,
“my_option”, originally had the data “bar”
after the module, it still returns “bar”
is it possible for it to return empty?