The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Populate fields from email from inbound email action

daggupati
Tera Contributor

Hi,

How to populate fields from email if it has same name but it is under different section. I am attaching my email. In the email it contains Problem Number 1 , Problem Number 2 and Problem Number 3 under each it has issue and details. So i want to populate Problem Number 1 Issue into Issue 1(In service now form field) and Details into Details 1(Form field) same like this for Problem Number 2 and Problem Number 3.

Any suggestions

email format.JPG

Thanks

6 REPLIES 6

Somehow array is not working for me, but was able to get in this way, see if this helps.



var arraystr = [];


arraystr = email.body_text.trim().split('Problem Number');


for(var i = 1; arraystr.length >= i; i++){


var prob = [];


prob = arraystr[i].split('\n');


switch(i) {


case 1:


var details1 = prob[3].split(':')[1];


var issue1 = prob[2].split(':')[1];


gs.log('details1' + details1);


gs.log('issue1' + issue1);


break;


case 2:


var details2 = prob[3].split(':')[1];


var issue2 = prob[2].split(':')[1];


gs.log('details2' + details2);


gs.log('issue2' + issue2);


break;


case 3:


var details3 = prob[3].split(':')[1];


var issue3 = prob[2].split(':')[1];


gs.log('details3' + details3);


gs.log('issue3' + issue3);


break;


}


}


gs.log(details1 + ':' + details2 + ':' + details3 + ':' + issue1 + ':' + issue2 + ':' + issue3);



When I am not typing email.body it is not taking the refrence.