How to combine multiple text strings that come separated in different collections from a notion request

[Natalia_Arcila]

Hi!

I have a social media calendar in notion and I want to create an automation with Make so that posts are made automatically. The problem I have is that the texts to be published (mainly on LinkedIn) are made up of text and links.

I have a social media calendar in notion and I want to create an automation with Make so that posts are made automatically. The problem I have is that the texts to be published (mainly on LinkedIn) are made up of text and links.

The first thing I’m doing is using the “search objects” module to connect to the database and apply some initial filters to bring up the publication I want.

The result that is giving me problems is in properties values ​​-> Text… since the text (the one shown in the first image) is separated if there are links included. So in this case I separate it into 3 collections

Collection 1: text string
Collection 2: link
Collection 3: text string

IMPORTANT: In this case, I separate it into 3 collections since there is only one link. But the case may happen where there are 2 or more links and therefore there will be more collections

I am trying to put the text together using the toString() function, however I have the following doubts
1: When I go to the results that the notion module brought me, I don’t see the 3 collections where the texts are stored… only “plain text” appears, which contains only the first collection

As you can see, neither the link nor the final hasgtags are included.

In general I am confused

1. I don’t know how to view the texts stored in the 3 collections
2. I don’t know how to put these texts + links together
3. I don’t know how to do it in a more dynamic way so that it includes more collections in case there are more links

I appreciate any help!

[samliew]

Instead of Search Objects, I think you need to use List Page Contents module instead, which should return you the page items with formatting.

For more information, see Context notion Page - #2 by sachin.shrivastava, How to add sublines in Notion automatically? - #4 by Sviatoslav_M

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

[Natalia_Arcila]

Hi!, Thanks for your help.

However this solution doen not work since my data is not a “rich text block” … based on the information you suggested.

Any other Idea?

Thanks

[alex.newpath]

@Natalia_Arcila

Any other Idea?

Can I suggest you work through some of the videos I put together on accessing exactly the type of structure you describe? I just put up Part 5 which has exactly the type of structure you describe - an array where each collection is a separate array element.

[Natalia_Arcila]

@alex.newpath the series of videos to understand data structures and how to manipulate them was just what I needed.

Thank you so much!

[alex.newpath]

@Natalia_Arcila

Thank you so much!

You’re very welcome – it’s hard sometimes to understand from the documentation or even some short comments how Make deals with the various types of structures. I thought some videos would help. I’ll continue doing some more complex manipulations but it will take some time to model them using some sample data that lends itself to more complex stuff like merging 2 different collections based on a criteria.

–
Alex Sirota
Director of NewPath Consulting - we are Make Heroes!

Check out my series of videos and scenario walkthroughs for Make Newbies

My Solutions on Make Community