Help

Formula to Bullet Point a list

Topic Labels: Formulas
Solved
Jump to Solution
7909 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Btbml
7 - App Architect
7 - App Architect

I have a multiline text field and I would like to use a formula field to take that multiline text and use the existing content but add a bullet point character in front of each new line. Is this possible? I’d like it to happen automatically without manually having to run a script

Part 2 - If that works, I’d like to take the bulleted list and split it after 10 lines into a second field. Is this possible?

1 Solution

Accepted Solutions
Jason
Airtable Employee
Airtable Employee

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")

Screen Shot 2020-03-06 at 3.47.49 PM

See Solution in Thread

7 Replies 7
Zollie
10 - Mercury
10 - Mercury

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$.

Jason
Airtable Employee
Airtable Employee

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")

Screen Shot 2020-03-06 at 3.47.49 PM

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

Btbml
7 - App Architect
7 - App Architect

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