<@U01C3RGHB16> array.join("\n")
# suitescriptm
michoel
01/06/2021, 6:33 AM@SG array.join("\n")
s
SG
01/06/2021, 6:39 AMunable to do with this
m
michoel
01/06/2021, 6:40 AMWhat happens when you try?
s
SG
01/06/2021, 6:42 AMfunction taskDetailsSearch(recid,rec) {
try {
var invoiceSearchObj = search.create({
type: "invoice",
filters: [
["type", "anyof", "CustInvc"],
"AND",
["mainline", "is", "T"],
"AND",
["taxline", "is", "F"],
"AND",
["internalid", "anyof", recid]
],
columns: [
search.createColumn({
name: "internalid",
label: "Internal ID"
}),
search.createColumn({
name: "owner",
join: "activity",
label: "Owner"
}),
search.createColumn({
name: "startdate",
join: "activity",
label: "Date"
})
]
});
var cols=invoiceSearchObj.columns;
var owner,date;
var arr=[];
var str='';
var searchResultCount = invoiceSearchObj.runPaged().count;
log.debug("invoiceSearchObj result count", searchResultCount);
invoiceSearchObj.run().each(function(result) {
owner=result.getText(cols[1]);
date=result.getValue(cols[2]);
var a =owner +' '+date;
arr.push(a);
return true;
});
arr.join("\n");
log.debug('arr',arr);
var id = record.submitFields({
type: record.Type.INVOICE,
id: recid,
values: {
custbody1: arr
},
options: {
enableSourcing: false,
ignoreMandatoryFields : true
}
});
} catch (e) {
log.debug(e.name, e.message);
}
}
SG
01/06/2021, 6:43 AMIn the custom field :
output:
Test1 05-Jan-2021 Test1 05-Jan-2021 Test1 05-Jan-2021
m
michoel
01/06/2021, 6:47 AMarr.join returns a string which you are ignoring and then saving the original array to the custom field
michoel
01/06/2021, 6:48 AMIn your submitFields call you need to replace
custbody1: arrcustbody1: arr.join("\n")s
SG
01/06/2021, 6:48 AMokay
SG
01/06/2021, 6:48 AMlet me try this
SG
01/06/2021, 6:51 AMstill unable
e
ericbirdsall
01/06/2021, 3:16 PM@SG is your custom field a text area? If it's just a text field, it will be combined into one line.