Notion database, relationship creation

Questions & Answers
1

Hi, I have uploaded a 2 tables Logins and Folders into Notion via CSV and I am trying to link them with Make.com (as Notion does not offer the possibility to link imported tables).

Here is the ‘Logins’ table, ‘column1.folderid’ column contains the id of the ‘Folders’ table

image
image1625×446 38.2 KB

I have created this Make scenario to copy the ‘column1.folderid’ value to ‘Folder’ column in order to link the 2 tables, but I cannot as the ‘Folder’ column field is missing:

image
image1158×1040 80.2 KB

How to then link the 2 tables using Make.com ? Thanks for any help

1 Like
2

## This should directly answer your question!
In Notion, it doesn't seem possible to create a new database item with a relation to a different database? - #4 by JugaadiTech

Correction Provided by @Mitch-PragmaFlow.com

Additional Information on Notion

Templating Workflow Make x Notion
Advanced Notion Automation - Templates in database - #4 by JugaadiTech
Notion Mentions to Slack messages - #2 by JugaadiTech
Notion Platform Roadmap
All Notion Threads

1 Like
3

Here is a summary of what I need and the solution :

image
image1192×587 61 KB

I have created this scenario now which almost works:

image
image1624×496 37.5 KB

I just need help on what to enter inside FolderIdLookup (highlighted in light blue below)?

image
image1589×1058 102 KB

4

can you show what was returned by module 3?

5

Here is what is returned by module 3:

image
image1575×1434 194 KB

6

had a look at the api docs for notion.

You should be able to update the property by adding in a parameter referencing the field by name.

If the current module doesn’t allow it, you could use the generic API or even HTTP to send that part.

image
image1236×1112 68.9 KB

2 Likes
7

I do not get what means: “The keys are the names or IDs of the property and the values are property values.”
In my 4th module, I want my FolderIdLookup which is the relation field to correspond to the FolderIdStr field which is just a string field coming from my CSV import:

image
image494×579 40.6 KB

I have specified ‘plaintext’.
I do not get why Make.com does not accept this. This is the only way to recreate the database between 2 tables.

8

I have specified ‘plaintext’.
I do not get why Make.com does not accept this. This is the only way to recreate the database between 2 tables.

I hear you, I often feel this way with new tech. I find am quite prone to assuming that there is a gap in the platform rather than in my knowledge.

Anyways, I believe I can see the error.

You would find this by going to edit module 4, then using the value for 3. parent > id

You should not need to convert anything to plaintext and the value currently in module 4 does not appear correct to me.

Can

9

Neat!
(Notion must have updated those since I last thoroughly went through them!)
Gonna update my notes, (I know I’m not the op) but thanks for looking into this! :smiley:

Very useful information

1 Like
10

Right, I have added Page ID and it works now :slight_smile:
image

1 Like