Auto-creating a child ticket based on a custom field.

[Jonathan Rummel]

Hi All,

Here's what I'm looking to do:

I have a queue called "Data Analysis".  In this queue, there is a ticket custom field called "Progress".

When someone changes the "Progress" custom field on the ticket to "Request Data", I want a child ticket created in the "Data Acquisition" queue and the owner set to "Sarah".

Could someone please help me out with this?  Thanks so much!