Then create lead record if internal ID matches Lin...
# suitescriptm
Marygolds3
12/12/2018, 7:35 PMThen create lead record if internal ID matches Line 1.
a
andrewh
12/12/2018, 7:42 PMso you are getting the sublist value in the item sublist of the field 'line' ?
andrewh
12/12/2018, 7:43 PMthe record itself will have an internal id, the item records will have an internal id, the lines have a lineid in the field 'line'
andrewh
12/12/2018, 7:43 PMlineids often start at 0
andrewh
12/12/2018, 7:45 PMbut 11075 does not look like a line id, so I'm thinking your trying to look at the item's internal id? getSublistValue({ sublistId: 'item', fieldId: 'item', line: x})
m
Marygolds3
12/12/2018, 7:49 PMyes items internal id
Marygolds3
12/12/2018, 7:49 PMis 11075
Marygolds3
12/12/2018, 7:50 PMyes that is my script
Marygolds3
12/12/2018, 7:50 PMto pull the line value
a
andrewh
12/12/2018, 7:50 PMyou want the item value
m
Marygolds3
12/12/2018, 7:50 PMyes that is 11075
Marygolds3
12/12/2018, 7:50 PMthen i want to use that value
Marygolds3
12/12/2018, 7:50 PMin an if statement
Marygolds3
12/12/2018, 7:50 PMto create my lead record
Marygolds3
12/12/2018, 7:51 PMi can do it in 1.0 no problem
Marygolds3
12/12/2018, 7:51 PM2.0 is giving me fits
a
andrewh
12/12/2018, 7:51 PMvar itemInternalId = getSublistValue({ sublistId: 'item', fieldId: 'item', line: x})
andrewh
12/12/2018, 7:51 PMif (itemInternalId == 11075) ...
andrewh
12/12/2018, 7:53 PMmore specifically, something long the lines of rec = context.newRecord (or record.load(something))
andrewh
12/12/2018, 7:53 PMand then it's actually more like "rec.getSublistValue()"
m
Marygolds3
12/12/2018, 7:54 PMright so my rec is Objrecord.getSublistValue
Marygolds3
12/12/2018, 7:54 PM1 sec
Marygolds3
12/12/2018, 7:54 PMvar itemLineCount = Objrecord.getLineCount({sublistId:'item'});
log.debug('itemLineCount=='+itemLineCount);
for(var i = 0; i < itemLineCount; i++)
{
var itemsub= Objrecord.getSublistValue({line:i, sublistId:'item',fieldId:'item'});
}
Marygolds3
12/12/2018, 7:54 PMNow I want to use that internal ID to create my lead record
Marygolds3
12/12/2018, 7:54 PMin an if statement
Marygolds3
12/12/2018, 7:54 PMso i've tried if(itemsub==11075)
Marygolds3
12/12/2018, 7:54 PMand if(itemsub)
Marygolds3
12/12/2018, 7:54 PMand if(parseInt(itemsub))
Marygolds3
12/12/2018, 7:54 PMnothing is working though
a
andrewh
12/12/2018, 7:55 PMI would log itemsub just to make sure you're seeing 11075...
andrewh
12/12/2018, 7:56 PMcan you be 100% confident the code is actually running? can you modify a log statement and verify it is reflected correctly? Double check the script is not inactive and the deployment is deployed - you might have a config issue in your way...
andrewh
12/12/2018, 7:59 PMclient script? UE? what's your entry point?
m
Marygolds3
12/12/2018, 8:07 PMaftersubmit of SO record
Marygolds3
12/12/2018, 8:07 PMyes everything is running, if i do not add the if statement, the record creates just fine
a
andrewh
12/12/2018, 8:13 PMand you're able to see the value of itemsub in your logs as 11075?
m
Marygolds3
12/12/2018, 8:14 PMyes
a
andrewh
12/12/2018, 8:20 PMwow, it seems like you're doing it right - I'm at a loss, never had an issue with that, can you paste the entire script?
m
Marygolds3
12/12/2018, 8:23 PMif(parseInt(itemsub)==11075) {
Marygolds3
12/12/2018, 8:23 PMThats the only other part
Marygolds3
12/12/2018, 8:23 PMvar Objrecord = context.newRecord;
var recordid=Objrecord.id;
var salesOrder = context.newRecord;
log.debug('recordid=='+recordid);
Marygolds3
12/12/2018, 8:23 PMThat's the beginning
a
andrewh
12/12/2018, 8:26 PMuse three backticks around your whole script and paste it all (```) at the beginning and at the end
m
Marygolds3
12/12/2018, 8:32 PMill try a few things
Marygolds3
12/12/2018, 8:32 PMthank you for your help
Marygolds3
12/12/2018, 8:32 PMI appreciate it
4 Views