You need to sign in to do that
Don't have an account?
John Gallinagh 8
Parsing Task Comments Field
So I'm sure that this challenge has been solved in somewhere. Here's what I'm looking to do. Our phone integration with Salesforce populates the Comments field on the Task object with the information below. I want to parse each line and take specific text from each line to populate a custom field. Any help would be greatly appreciated.
For example:
Call status: Connected - I would like to capture the word "Connected" and populate a custom field called Call Disposition.
Duration of the call: 00:00:38 - I would like to capture the time element (00:00:38) and populate a Call Duration field.
Call started at: 09:05 AM Wed, Aug.17
Call ended at: 09:06 AM Wed, Aug.17
Duration of the call: 00:00:38
Caller: 5089587007
Extension: 1004
Call status: Connected
Comments: Testing workflow to update task type field to Call
For example:
Call status: Connected - I would like to capture the word "Connected" and populate a custom field called Call Disposition.
Duration of the call: 00:00:38 - I would like to capture the time element (00:00:38) and populate a Call Duration field.
Call started at: 09:05 AM Wed, Aug.17
Call ended at: 09:06 AM Wed, Aug.17
Duration of the call: 00:00:38
Caller: 5089587007
Extension: 1004
Call status: Connected
Comments: Testing workflow to update task type field to Call
Nadeem Khan 71
Hi John, I have the exact same requirement - wanted to find out if you managed to resolve this?