Hey folks,
I also need some help with mapping in relational database properties in notion.
So, I’m Watching db1 for updates. db1 has a relation property (“Weekly Review”) that can hold many relations.
I’m using an iterator to retrieve the related values in “Weekly Review” - for “Monthly Review”.
I’m trying to use an aggregator to collect the retrieved IDs for Monthly Review in an array, that I can write back to initial db1 relation “Monthly Review”.
Aggregator 1:
Aggregator 2:
I think I will not need the variable once it working, but for setting up I try to monitor what’s going on:
blueprint (3).json (139.6 KB)
Output Aggregator 1:
[
{
"array": [
{
"properties_value": {
"Objectives": [],
"Effectiveness": null,
"Focus": [],
"Disappointments": [
{
"id": "1b74fe6b-4bc9-808d-962a-d36561d87229"
},
{
"id": "f8c42e5a-65ef-4afa-bdb9-c778b7ccfcae"
},
{
"id": "cee6b6db-1674-46c1-ad9a-7079742f5779"
}
],
"Calendar": [],
"Date": {
"start": "2025-03-10",
"end": "2025-03-16",
"time_zone": null
},
"Monthly Review": [
{
"id": "1b54fe6b-4bc9-81eb-b8aa-f513eae36082"
}
],
"Rollups Daily Tracking": {
"type": "array",
"array": [
{
"type": "formula",
"formula": {
"type": "number",
"number": 0
}
}
],
"function": "show_original"
},
"Habit Tracking": [
{
"id": "1b54fe6b-4bc9-804c-95b9-c84ddb8bde9f"
}
],
"Gratitude": [],
"End Date": {
"start": "2025-03-16",
"end": null,
"time_zone": null
},
"Improvements": {
"type": "array",
"array": [
{
"type": "relation",
"relation": []
}
],
"function": "show_original"
},
"Accomplishments": [
{
"id": "1b74fe6b-4bc9-802e-8131-fd9b3ee46fda"
}
],
"Start Date": {
"start": "2025-03-10",
"end": null,
"time_zone": null
},
"🔁 Quarter": [
{
"id": "1794fe6b-4bc9-8133-aeba-fc309de5c0e5"
}
],
"Improvement Summary": [],
"Week (from - to)": [
{
"type": "text",
"text": {
"content": "Mar-10 - Mar-16",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Mar-10 - Mar-16",
"href": null
}
]
}
},
{
"properties_value": {
"Objectives": [],
"Effectiveness": null,
"Focus": [],
"Disappointments": [
{
"id": "1b74fe6b-4bc9-808d-962a-d36561d87229"
},
{
"id": "f8c42e5a-65ef-4afa-bdb9-c778b7ccfcae"
},
{
"id": "cee6b6db-1674-46c1-ad9a-7079742f5779"
}
],
"Calendar": [],
"Date": {
"start": "2025-01-13",
"end": "2025-01-19",
"time_zone": null
},
"Monthly Review": [
{
"id": "1794fe6b-4bc9-81a0-9fee-d1303fa1ac9c"
}
],
"Rollups Daily Tracking": {
"type": "array",
"array": [
{
"type": "formula",
"formula": {
"type": "number",
"number": 0
}
},
{
"type": "formula",
"formula": {
"type": "number",
"number": 0
}
}
],
"function": "show_original"
},
"Habit Tracking": [
{
"id": "17a4fe6b-4bc9-8003-8e7a-c8cae9cdda8c"
},
{
"id": "1804fe6b-4bc9-805d-89ac-eee69705060a"
}
],
"Gratitude": [],
"End Date": {
"start": "2025-01-19",
"end": null,
"time_zone": null
},
"Improvements": {
"type": "array",
"array": [
{
"type": "relation",
"relation": []
},
{
"type": "relation",
"relation": []
}
],
"function": "show_original"
},
"Accomplishments": [
{
"id": "1b74fe6b-4bc9-802e-8131-fd9b3ee46fda"
}
],
"Start Date": {
"start": "2025-01-13",
"end": null,
"time_zone": null
},
"🔁 Quarter": [
{
"id": "1794fe6b-4bc9-8133-aeba-fc309de5c0e5"
}
],
"Improvement Summary": [],
"Week (from - to)": [
{
"type": "text",
"text": {
"content": "Jan-13 - Jan-19",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Jan-13 - Jan-19",
"href": null
}
]
}
}
],
"__IMTAGGLENGTH__": 2
}
]
Output Aggregator 2:
[
{
"array": [
{
"array": [
{
"properties_value": {
"Objectives": [],
"Effectiveness": null,
"Focus": [],
"Disappointments": [
{
"id": "1b74fe6b-4bc9-808d-962a-d36561d87229"
},
{
"id": "f8c42e5a-65ef-4afa-bdb9-c778b7ccfcae"
},
{
"id": "cee6b6db-1674-46c1-ad9a-7079742f5779"
}
],
"Calendar": [],
"Date": {
"start": "2025-03-10",
"end": "2025-03-16",
"time_zone": null
},
"Monthly Review": [
{
"id": "1b54fe6b-4bc9-81eb-b8aa-f513eae36082"
}
],
"Rollups Daily Tracking": {
"type": "array",
"array": [
{
"type": "formula",
"formula": {
"type": "number",
"number": 0
}
}
],
"function": "show_original"
},
"Habit Tracking": [
{
"id": "1b54fe6b-4bc9-804c-95b9-c84ddb8bde9f"
}
],
"Gratitude": [],
"End Date": {
"start": "2025-03-16",
"end": null,
"time_zone": null
},
"Improvements": {
"type": "array",
"array": [
{
"type": "relation",
"relation": []
}
],
"function": "show_original"
},
"Accomplishments": [
{
"id": "1b74fe6b-4bc9-802e-8131-fd9b3ee46fda"
}
],
"Start Date": {
"start": "2025-03-10",
"end": null,
"time_zone": null
},
"🔁 Quarter": [
{
"id": "1794fe6b-4bc9-8133-aeba-fc309de5c0e5"
}
],
"Improvement Summary": [],
"Week (from - to)": [
{
"type": "text",
"text": {
"content": "Mar-10 - Mar-16",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Mar-10 - Mar-16",
"href": null
}
]
}
},
{
"properties_value": {
"Objectives": [],
"Effectiveness": null,
"Focus": [],
"Disappointments": [
{
"id": "1b74fe6b-4bc9-808d-962a-d36561d87229"
},
{
"id": "f8c42e5a-65ef-4afa-bdb9-c778b7ccfcae"
},
{
"id": "cee6b6db-1674-46c1-ad9a-7079742f5779"
}
],
"Calendar": [],
"Date": {
"start": "2025-01-13",
"end": "2025-01-19",
"time_zone": null
},
"Monthly Review": [
{
"id": "1794fe6b-4bc9-81a0-9fee-d1303fa1ac9c"
}
],
"Rollups Daily Tracking": {
"type": "array",
"array": [
{
"type": "formula",
"formula": {
"type": "number",
"number": 0
}
},
{
"type": "formula",
"formula": {
"type": "number",
"number": 0
}
}
],
"function": "show_original"
},
"Habit Tracking": [
{
"id": "17a4fe6b-4bc9-8003-8e7a-c8cae9cdda8c"
},
{
"id": "1804fe6b-4bc9-805d-89ac-eee69705060a"
}
],
"Gratitude": [],
"End Date": {
"start": "2025-01-19",
"end": null,
"time_zone": null
},
"Improvements": {
"type": "array",
"array": [
{
"type": "relation",
"relation": []
},
{
"type": "relation",
"relation": []
}
],
"function": "show_original"
},
"Accomplishments": [
{
"id": "1b74fe6b-4bc9-802e-8131-fd9b3ee46fda"
}
],
"Start Date": {
"start": "2025-01-13",
"end": null,
"time_zone": null
},
"🔁 Quarter": [
{
"id": "1794fe6b-4bc9-8133-aeba-fc309de5c0e5"
}
],
"Improvement Summary": [],
"Week (from - to)": [
{
"type": "text",
"text": {
"content": "Jan-13 - Jan-19",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Jan-13 - Jan-19",
"href": null
}
]
}
}
],
"__IMTKEY__": null
}
],
"__IMTAGGLENGTH__": 1
}
]
Output Set Variable:
[
{
"testmap": [
"1b54fe6b-4bc9-81eb-b8aa-f513eae36082"
]
}
]
I just can’t figure out how to set-up the aggregator and afterwards map it correctly, so that it will be accepted by DB1.
This topic seems similar to this one: [From Multi-Select property to Relation of an other DB in Notion | Make.com - #14 by Simone] (From Multi-Select property to Relation of an other DB in Notion | Make.com - #14 by Simone) , however the described solution doesn’t work in my case 
Also another solution I found, to work on the 1-side of a relation will not work in this case, since it’s many-to-many, so there is no 1-side.
Any help will be much appreciated! Thanks in advance!