Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Edit a Rich Text Long Text Field

Topic Labels: Automations
434 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

I am trying to create an automation that will look for a string in a rich text long text field, and delete that string from the field, while keeping the rest of the rich text in place. The string will ways be at the end of the field and will start with “[[[”.

I created a formula to identify the “[[[” and the text after it. Now I’m not sure what the best way to delete the results from that formula from the original field with an automation. Any ideas?

4 Replies 4

How about creating such a formula field and overriding it with automation?

LEFT(Notes,SEARCH("[[[",Notes)-1)

Part of the problem with dealing with rich text fields is that when you use a rich text field in a formula, you loose the rich text formatting.

If you want to retain rich text formatting when you manipulate the text, your best bet is to use scripting.

Ah, I see, so the formatting is lost.

Yes - the retaining the rich text formatting is exactly the issue! I will look into scripting. Thank you @kuovonne and @Sho!