To display the email messages in the custom record Notification page.
First of all retrieved the email using the saved search then added new records in the notification record using the nlapiCreateRecord and added the new value to the corresponding fields
var sentemailSearch = nlapiSearchRecord("sentemail", null,
[
["subject", "contains", "Thanks for your order!"],
"AND",
["sentdate", "on", "4/4/2022 11:59 pm"]
],
[
new nlobjSearchColumn("sentdate").setSort(false),
new nlobjSearchColumn("subject"),
new nlobjSearchColumn("body"),
new nlobjSearchColumn("formulatext1").setFormula("TO_CHAR({sentdate} , 'DD/MM/YYYY')"),
]
);
if (sentemailSearch) {
for (var j = 0; j < sentemailSearch.length; j++) {
var MailSubject = [],
MailMessages = [],
MailDate = [];
MailSubject.push(sentemailSearch[j].getValue('subject'));
MailMessages.push(sentemailSearch[j].getValue('body'));
MailDate.push(sentemailSearch[j].getValue('formulatext1'));
var mailid = sentemailSearch[j].id;
console.log(mailid);
var customrecord_jj_uniqueidSearch = nlapiSearchRecord("customrecord_jj_notification", null,
[
["custrecord20", "equalto", mailid]
],
[
new nlobjSearchColumn("scriptid").setSort(false)
]
);
if (!customrecord_jj_uniqueidSearch) {
var customerRecord = nlapiCreateRecord('customrecord_jj_notification');
customerRecord.setFieldValue('custrecord_jj_message', MailMessages);
customerRecord.setFieldValue('custrecord_jj_message_subject', MailSubject);
customerRecord.setFieldValue('custrecord_jj_notification_date', MailDate);
customerRecord.setFieldValue('custrecord_jj_display_in_website', "T");
customerRecord.setFieldValue('custrecord_jj_notification_customer', field.internalid);
customerRecord.setFieldValue('custrecord20', mailid);
nlapiSubmitRecord(customerRecord);
}
}
}