Hello Gurus!
I am new to SuiteScript and am hoping that one of you awesome Guru's can help me by discussing a design overview/best practice approach to create a solution for the problem I've been tasked with.
Problem: We are currently using the native Email Case Capture feature to generate Tickets/Cases via various Ticket Profile email addresses. We will receive emails from an external customer service organization who handle overflow during high volume. The emails will always originate from the organization and will never find a match in the 'From Address' with a Customer Email Address, and so the Customer will always be assigned as anonymous. However, the Customer information is always avaliable in the Email Subject. I need to create a customization that after the email is received by NetSuite, when the Case/Ticket is being created there is a script/workflow that will trigger, parse the subject, and populate the customer field of the Ticket after validating against our list of Customers.
I have programming experience so am not as concerned with writing the actual JS code (except for perhaps names of the critical functions/sublists needed), however, I'm not familiar with the backend process of Email Capture and Case Generation. I would greatly appreciate if you could coach me on what the best approach would be to solving this problem. From my intial research, I'm thinking this could be accomplished by a workflow action script, but I have questions like would that be a workflow on the Case, the Email, would it be a beforeRecordSubmit? From what context can a join to the email from the case to extract and parse the subject?
Again, any help you can provide on overall solution design would be a huge help and more than happy to provide any additional information that I can!
Thanks!
Stephen