template- dynamincally pull information from long description help

[quintc]

We have a 3rd party company that submits tickets through email. They cannot add the proper information to the ticket fields themselves instead putting all information in description, is it possible for the template to parse that information and fill it?

info i would like to be auto populated:

name of person that sent the actual ticket, currently it just shows the name of the 3rd party company,

location

room

phone number

all other fields are working right with the template.

[Jordan Vignoni]

As long as the inbound email follows the same format every time, I think it could be possible.  If you are using "Inbound Actions", you could parse the information from the email body, or you can use a business rule to parse the description on insert.

[quintc]

how would i set that up?

[Jordan Vignoni]

Let's suppose the description contains this information:

Location: Test Site A
Room:  Room 123

The script in the business rule might look something like this to set the field you use for location:

var description = current.description;

var location = description.substr(description.indexOf("Location:") + 10).split("Room:")[0];
current.location_field_value = location;