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?
Best answer by Jason11
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")
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?
@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$.
+20Hi @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")
+20Hi @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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.