Responding to Part 1. Not sure how to do Part 2 with only a formula.

Long Text Field

Word1

Word2

Word3

Formula Field

IF({Long Text Field}, "- " & SUBSTITUTE({Long Text Field}, "\n", "\n- "),"")

- Word1

- Word2

- Word3

The formula basically just adds "- " to any new line characters (\n).

Two words - Script Block.

@Btbml was hoping to avoid

manually having to run a script

@Bill.French

Is it possible (or advisable) to have a scripting block always running?

It’s possible to create script blocks that never stop, but it would require the browser instance running the block to remain logged in and connected all the time. And this assumes that Airtable would allow it. They may already have throttles in place to stop runaway scripts.

Yep, it seems to be the increasingly case. To achieve that you need to go to a glue-factory (like Zapier) or a custom API proces$.

Hi @Btbml, how are you defining the start of each new line? If it’s just plain sentence text ending in a period, you can use use the SUBSTITUTE function to force a line break whenever a period is present (and also maintain the period in the final result). Since it lives in a formula this would always transform the text in the referenced field without any manual intervention.

Here’s an example using the formula below:

SUBSTITUTE(Text, ". ", ".\n \n")

You can also add in a bullet point to the start of each new line using an emoji: SUBSTITUTE(Text,". ", ".\n \n • ")

I completely forgot about the substitute formula.

Re: script running all the time, we do use integromat for a number of other things so I’ll look into that