Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 20, 2022 09:58 PM
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?
Mar 20, 2022 10:24 PM
How about creating such a formula field and overriding it with automation?
LEFT(Notes,SEARCH("[[[",Notes)-1)
Mar 20, 2022 10:30 PM
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.
Mar 20, 2022 10:59 PM
Ah, I see, so the formatting is lost.
Mar 21, 2022 12:45 PM