Formula for combining values of different types in base table

Help
1

What I’m trying to do

I want to combine the values of two table cells into one, where the first value is text and the second is a link. For example, I have a note with the property “text” and the value “text1”. I want to make a formula so that in one cell there is a value: text1 [[note.md]], where [[note.md]] - clickable link.

Things I have tried

If I make the formula: text + [[note.md]], then [[note.md]] ceases to be a link, it becomes a non-clickable string.

2

[text, "text", link]

3

Great, it works! However, the values are displayed in multiple rows in the table cell. Is it possible to achieve a single-row result?

4

You can try to put a .flat() at the end, so you have [text, "text", link].flat().

5

Zodian, thanks, it works!
Here is the final formula for my case - [“:check_mark:”,link(:check_mark:.toString()).asFile()].flat()
Here “:check_mark:” is the file icon, and in the property :check_mark: there is a link to the file itself, result - single line - :check_mark:File, where the File is a clickable link.