For example, our requirement is to fetch a value after the Duration of the call: from the below message like
Tomorrow, Chuck should have a list of part numbers he wants me to quote him.
Call answered at: Mon Jun 12 2023 21:13:04 GMT+0000 (GMT)
Call ended at: Mon Jun 12 2023 21:15:25 GMT+0000 (GMT)
Duration of the call: 00:02:21
Using phone call saved search we get the value 00:02:21 and can set it to a new field using Validation and Defaulting.
In search result add Formula text, add Summary type: Maximum, Under Formula add REGEXP_SUBSTR({message}, ‘Duration of the call: (\d{2}:\d{2}:\d{2})’, 1, 1, ‘i’, 1)
Save the created phone call saved search and go to the created CRM field “Talk Time” under ‘Validation and Defaulting’ subtab select the created phone call saved search and click on save.
Open any phone call records in edit mode and click on save the “Talk Time” field will be populated with the value “00:02:21”