Create a transcript from list of texts in backend workflow

[karan_trivedi248]

Hi fellow bubblers.

i want to send a transcript of chat messages happened between two users. i.e Lets say john and shaun chatted in the system.

so i want to send a transcript of messages they did to each other in past week like following

John : Hi shaun
Shaun : hi
John: blah blah blah
Shaun: blah blah

this will be a weekly trigger event.

i am stuck at how will i create a list of string like above in backend.
any help or suggestion would be appreciated.

thanks

[codefree]

Hey @karan_trivedi248

You can try tweak the message query like below:

This will generate a text string like:

You can send this generated string via email using a weekly scheduled api workflow.

Let me know if this works for you.

Thanks