Craig Schellenbach
09/21/2024, 4:57 PMbattk
09/22/2024, 4:00 AMbattk
09/22/2024, 4:00 AMborncorp
09/22/2024, 7:10 AMCraig Schellenbach
09/22/2024, 1:29 PMvar searchResults = SearchObj.run(); //SearchObj is a created Search
searchResults.columns.forEach(function(col){
list.addField({
id: col.name,
label: col.label,
type: serverWidget.FieldType.TEXT
});
});
for(var i in results){ //results is the same search paramaters as SearchObj but uses .Run().each and builds an array
var result = results[i];
for(var k in result.columns){
var test = result.columns[k];
var fieldValue = result.getValue(result.columns[k])
var a = Number(i);
var n = result.columns[k].name;
var nn = fieldValue;
list.setSublistValue({
id: result.columns[k].name,
value: fieldValue,
line: a
});
}
} //errors after one loop through.
This is the error I get
{
"type": "error.SuiteScriptError",
"name": "SSS_MISSING_REQD_ARGUMENT",
"message": "Sublist.setSublistValue: Missing a required argument: options.value",
"id": null,
"stack": [
"Error",
" at testForm (/SuiteScripts/sl.js:140:26)",
" at Object.onRequest (/SuiteScripts/sl.js:43:25)"
],
"cause": {
"name": "SSS_MISSING_REQD_ARGUMENT",
"message": "Sublist.setSublistValue: Missing a required argument: options.value"
},
"notifyOff": false,
"userFacing": true
}
battk
09/22/2024, 1:47 PMbattk
09/22/2024, 1:49 PMlist.setSublistValue({
id: result.columns[k].name,
value: undefined,
line: a,
});
using the above instead will give you a better idea of whats happening, but you should have been able to identify that something was wrong with the value parameterCraig Schellenbach
09/22/2024, 3:00 PM