How to create one to many rows nocodb

Describe the problem/error/question

i tried creating a one to many relation in nocodb node , however , the child table/ row only stores the first index from the returned json array
the parent table works fine

What is the error message (if any)?

no error message the functionality expected wasnt working fine

Please share your workflow

(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

Expected functionality is that two rows of employee should be created , however its only one being created

Information on your n8n setup

  • n8n version:1.22.6
  • **Database : Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via :npm
  • Operating system:Windows 11

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Hi @bbamzi, welcome to the community!

This is an error coming from NocoDB and suggests the data coming from your Edit Fields node does include all fields required to add a new row to your NocoDB table referenced in the “NocodDb-Employees” node.

So instead of using “Auto-Map Input Data to Columns” you might need to switch your “Data to Send” dropdown to the “Define Below for Each Column” option on this node and then make sure all required fields are populated.