Hello everyone. I’m creating a scenario where I need to connect (relation property in Notion) starting from a multi-select. In practice I need it to automate the tagging that Readwise does for each content (with multi-select), connecting the content to my topic DB (via relation).
I’ll explain:
step 1: trigger when an item is added to the content DB. This page will have tags (multi-select properties) taken from Readwise.
step 2: I search in my “Topics” DB only for topics that have the same name (I made sure to use the same text in the Readwise tags)
step 3: I connect the topics found to the content of Step 1
How I set it up works only if I have 1 tag/topic connected. The problem arises when I put 2 or more tags. As step 2 only passes me only 1 tag (the first)(only 1 bundle). I assume it’s because it’s a multi-select, but I’m not sure
instead, I have to make sure that if I pass 2 or 3 tags to the content, step 2 finds them and then I can connect them with step 3.
If you add an aggregator before the search module and add the Tags Array as source & adjust the mapping in the search module to the Array output, the search module will look for each tag and make the updates accordingly
I’m not sure if I understand the workflow correctly… My understanding was
Content DB with multi select Tags property
Topics DB where the names are aligned with the Tags property of the Content DB
When you have a new item in Content DB, you want to relate this page to each relevant Topic. So if you have 2 tags you will update 2 pages in the Topics DB.
→ looking at your screenprint I assume you are updating the Content DB with the links to the related Topics pages.
Since you want to update the Content DB only 1 time, you will need an aggregator (so you will continue with 1 bundle only). In the mapping you have to merge the page IDs which you found in the search module. You can try the following function {{join(2.array.id + “,”)}}
also the last step doesn’t seem to do anything like that. in fact no topics are reported. I put “key” in topics field? otherwise I could choose my own values, but if I put the text (name) it gave me an error
You have to select the Iterator as the source, this way you will get 1 bundle out of the Aggregator.
You don’t have to fill the “Group by” in the aggregator
In the Update database item, you can use the formula to join the Page IDs
copy-pasting formulas here in the community and back to Make sometimes creates weird changes… The ‘+’ and the " should not be there…
Besides that, I think I was too fast with the formula (again ) . Try this:
This actually outputs the array with the page ID that come from the aggregator. Maybe this is enough because I think the API for the topics expects an Array as well.
Hope this was the final step
Since your trigger is grabbing all the tags at once, you’ll need to break them up into separate pieces. In Make.com, you can use a tool like a text parser to split up the tags. You just need to decide what you’re using to separate the tags, like a comma or a space, and the text parser will do the rest.
You have to use an iterator, which means you process bundles individually.
