Insert Record In Custom Table - Inbound E-Mail Action

[-Andrew-]

Hi there,

Is there a way of creating a record in a custom table when the recipient(s) to the inbound email are "****@******.com"?

I have been reviewing the ServiceNow Docs and community but can't find a way to do this.

I have created a new inbound email action called "Inbound Email Lookup - DPU" but this still generates an Incident and not a record in the chosen table.

Thanks for your help.

Andrew

[Ct111]

Yes you should be able to create new record in custom table.

Make sure you configure the inbound action on that custom table rather than incidetn.

And also make sure you make changes to the code as per the fields of that table.

Example.

Suppose description field of your custom table is cust_description then your code would be 

current.cust_description = email.body.description;

current.insert();

For reference refer the below link

https://docs.servicenow.com/bundle/orlando-servicenow-platform/page/administer/notification/referenc...

[-Andrew-]

Hi there - i have the script and the custom table all setup, as Kieran suggested below i'm going to try the execution order now. 

[Kieran Anson · Accepted solution]

Hi Andrew,

You're on the right tracks with an inbound action however it sounds like you've not set the order of your new action and therefore the OOB create incident action is being used.

Set the execution order lower than 100 (e.g 70) so it processed your action prior to the incident one. Also ensure you have checked 'stop processing'

If my reply helped with your issue please mark helpful 👍 and correct if your issue is now resolved. ✅
By doing so you help other community members find resolved questions which may relate to an issue they're having.

[-Andrew-]

Thanks Kieran will give this a go now!