Hello,
I need to get an information from an Inbound email and set it in a field.
The information always will look as: DUNS: 123456789
I want to do it with a Process Builder, with a immediate action "Update Record". I am trying to fill up the field with the 9 numbers, but I don´t know how to do get the strings.
I did a Formula like this: TRIM(TEXT(FIND("DUNS:", [EmailMessage].TextBody  )+10))
But it just gets the: 12
Does anyone know how to do it?


 

We need to modify some cases (with specifics criterias) to another queue everydat at 5:00p.m European time. (And afterwards also to 1:00am)

An agent gave me a solution:
1. Create a field (Date/Time) than always shows 17:00 Today. The field must be available for all profiles but not available in the Layout

La formula: DATETIMEVALUE(TODAY()+ 0.625)

2. Create a workflow rules with the criterias you need and select "created, and any time it’s edited to subsequently meet criteria "

3. Add a Time-Dependent Workflow Actions that must be 0 hours before the field "Date/Time"
On winter the Time-Dependent Workflow acction must be update with one hour before the field "Date/Time"

4. Add the record updates than will change the owner case from one queue to the other.

The problem is that if I show the Formula Field always shows Today 2:00
And the owner change but not at this time

Does anyone now how could I do it?

Thanks!

Hello,
I need to get an information from an Inbound email and set it in a field.
The information always will look as: DUNS: 123456789
I want to do it with a Process Builder, with a immediate action "Update Record". I am trying to fill up the field with the 9 numbers, but I don´t know how to do get the strings.
I did a Formula like this: TRIM(TEXT(FIND("DUNS:", [EmailMessage].TextBody  )+10))
But it just gets the: 12
Does anyone know how to do it?