Read information from rich text

I want a formula to extract a number out of an email message. Just like you can from a normal text field by using the powerful formula functions.

Use case:
We get the assignment to cost centers of invoices via email and manually write them down. I want the cost center numbers to be extracted from the emails but can’t access the rich text field.

Is there any way to do that with scripting?

I may suggest to use Fibery AI and extract information from rich text via automation rule or action button. If you can send an example of the text I may try to create a prompt to do it

1 Like