I think you can create a button in form i.e after attaching a attachment the user should click the button, so that we process in background and add fields to MRVS.
1. create a widget/macro button in form, configure button to call a script include on click of button
2. configure script include to parse the file for the current form and return the values in array of objects
script to parse file in server:
var parser = new sn_impex.GlideExcelParser();
var attachment = new GlideSysAttachment();
// use attachment sys id of an excel file
var attachmentStream = attachment.getContentStream(<attachment sys id>);
parser.parse(attachmentStream);
//retrieve the column headers
var headers = parser.getColumnHeaders();
var header1 = headers[0];
var header2 = headers[1];
//print headers
gs.print(header1 + " " + header2);
while(parser.next()) {
var row = parser.getRow();
//print row value for both columns
gs.print(row[header1] + ' ' + row[header2])
}
https://docs.servicenow.com/bundle/madrid-application-development/page/app-store/dev_portal/API_refe...
4. on receiving response set te mrvs with received values.
-satheesh
3. on getting response form
