Automatically Convert Long Text to Code Block Markdown format

[bobbytang]

Hi folks,

I have a dataset that I want to import into a CMS for blogging.

In order for it to import and display correctly, the field in Long Text needs to be in Markdown - Code Block format so that it can hold a large chunk of HTML rich text.

Is there a way via Script or otherwise to automatically convert cells to be Markdown - Code Block by default, rather than clicking into each field, selecting all the text, and manually choosing Markdown - Code Block?

Before state:

Ideal state:

 

Greatly appreciate any help!

[TheTimeSavingCo]

You could use an automation to wrap all the text in the long text fields with "```", which should do what you're looking for?