Add New Records into a Column as a List instead of using Rows

[pepewaio]

Dear Support and Community,

We are trying to keep a record of string i.e email reminders in the format “21 Jul 2024 1:24 PM by Bill” in column.

We have used “Array to Set” & “Add Element to Set” and create/add the new records and we achieve the following format:

[“21 Jul 2024 12:55 PM by Bill”,“21 Jul 2024 12:59 PM by Bill”,“21 Jul 2024 1:15 PM by Bill”,“21 Jul 2024 1:17 PM by Bill”]

We are trying to format the above format and found it very cumbersome i.e very tricky to remove the “” and to further achieve the following:

21 Jul 2024 12:55 PM by Bill, 21 Jul 2024 12:59 PM by Bill,21 Jul 2024 1:15 PM by Bill,21 Jul 2024 1:17 PM by Bill

so that we can split and display as such:

21 Jul 2024 12:55 PM by Bill
21 Jul 2024 12:59 PM by Bill
21 Jul 2024 1:15 PM by Bill
21 Jul 2024 1:17 PM by Bill

Questions:

1. Is there a better way to implement the above use case?
2. Any advise how we can we remove the “”, or not insert in the first place?
3. Any videos we can check and understand better on “Array to Set” & “Add Element to Set”

Any advise and help is greatly appreciated!

[Jeff_Hager]

Haven’t really used datasets, but I think a template column would be an easy way to remove the brackets and quotes. Just set up a template column with [, ], and " as replacement values, and replace them with nothing.

[pepewaio]

It works! Ingenius!