Text.content, plain text, etc, only display a single line of text

How To
,
1

Hello there Make community!

So, to give you a clear idea of what I’m trying to achieve:
-I have a databse in notion I’ve succesfuly linked up to Make under the “watch database” module.
-Using the retrieved data, I want to extract the text contained in specified cells, and feed it to an OpenAI assistant.

Now, the issue is the following : the modules appear to consider different portions of text as individual items (as displayed in the attached screenshot)

image
image468×769 11.8 KB

My question is therefore : how do I make it so that the OpenAI module manages to grab the whole text, rather than only the first line?
I have tried using a {{join}} function under this format : {{join(1.Properties Value: Texte original, “\n”)}} where “Texte original” is the column of the cell which content I’m attempting to retrive.

I have also, unsuccesfuly, attempted to make use of a text aggregator module.

Any and all tips on how to manage what I’m trying to accomplish will be greatly appreciated, thank you in advance!

2

Try the join() function on the rich_text array.

How did you map the text aggregator? Text aggregator should work fine as well.

3

I have attempted to use rhe tich_text array in the text aggregator, mapped in this way :

image
image1165×410 65.8 KB

I have also attempted to map it like so : join(1.Properties_Value. Texte_Original: Rich_text," "), which didn’t appear to work either.

(As an aside, I’ve found a workaround to the issue, by simply switching from using a Notion database to a GSheets one, but would still like to know how to resolve this issue for future proofing, since I’m not always going to be able to simply decide to switch tool like this on the fly, thank you in advance).

4

Ah sorry, took a closer look and you’ll need to use the map() function to extract the array before joining them together. Here’s a reference to mapping if your not familiar with it.
https://www.make.com/en/help/mapping/mapping-arrays