Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Edit a Rich Text Long Text Field

Topic Labels: Automations
2158 4
cancel
Showing results for 
Search instead for 
Did you mean: 
egordin
7 - App Architect
7 - App Architect

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
Sho
11 - Venus
11 - Venus

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!