How to create a line with a linked field

[Julien_J]

Describe the problem/error/question

I want to create a record in Nocodb. My record contains a field that is linked to another table. So I have the value label, but I want it to create the link when I create the record, to avoid saving the label in a text field.

I have a Groups table :

And an Application table :

When I create an record from N8N to Application table in Nocodb, I have for example these datas :
Name : “Foo”
Group : “Group 2”.

How can I create this record from N8N ?

[n8n]

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:

[Ruslan_Yanyshyn]

Hey @Julien_J, welcome to community.
Suppose you create a new Application record.
You have to pass data about you group to the record.
Do get record and you will see it structure, look at the picture.

[Julien_J]

Thank you Ruslan,

I think I understand the principle but I’m not sure I understand how to do it from N8N.

Can it be done in one action?
If so, how can I find out the id of the Application record before it is created?

[Yo_its_prakash]

@Julien_J i think this will help you create what you are looking for in n8n,

1. First, get the ID of “Group 2” using a NocoDB node:

• Operation: “Get All Records”
• Table: “Groups”
• Additional Options: Add filter where Title equals “Group 2”

2. Then create your Application record with another NocoDB node:

• Operation: “Create Record”
• Table: “Application”
• Fields:

Name: "Foo"
Group: {{$node["Get Group ID"].json["list"][0]["Id"]}}

For linked fields in NocoDB, you must use the ID value of the linked record, not the display value. This can’t be done in a single operation - you need two steps (get ID then create record).

If you’re creating multiple records, use a Function node to create a mapping of group names to IDs first to improve efficiency.

[Julien_J]

Thanks @Yo_its_prakash, but it doesn’t work for me.
This is what I have :

And in Nocodb :

“Test” has no group link.

[Ruslan_Yanyshyn]

Hey @Julien_J to change a links in a table you should you custom API call since NocoDB node doesn’t support it yet unfortunately.
Here is example of that node.

[Julien_J]

Thanks @Ruslan_Yanyshyn .
In your example of node, I just see “HTTP Request” node but with no parameter or other things.
Is it normal ?

[Ruslan_Yanyshyn]

Oh something may have gone wrong when I posed, I just fixed it.

[AlexHunt]

Same problem here. It would be great to be able to do it though the node directly.

[filcuk]

This is slightly different using v2 API:

[Krashnicov]

Do you know how we would request they publish the nocodb node source code so we can possibly add this in? Using the additional http request is tedious in large tables.