assuming there is only one serial number (12345) -...
# suitescriptm
mg2017
03/18/2019, 4:04 PMassuming there is only one serial number (12345) - how do i select this in code? currently (to test) i hard coded the serial number to see if I can create the line and that seems fine, but not sure how to select the value from the drop down
b
battk
03/18/2019, 4:11 PMgenerally you have 3 options for this sort of thing:
a) Record.setCurrentSublistText
b) Record.setCurrentSublistValue with an internal id from Field.getSelectOptions
c) Record.setCurrentSublistValue with an internal id from an item search
m
mg2017
03/18/2019, 4:18 PMi think i need b) i will try this, thanks for the suggestion
mg2017
03/18/2019, 5:39 PMi tried this but i get Cannot find function getSelectOptions in object:
mg2017
03/18/2019, 5:39 PMvar opts = inventoryDetailSubrecord.getCurrentSublistValue({
sublistId: 'inventoryassignment',
fieldId: 'issueinventorynumber',
}).getSelectOptions();
inventoryDetailSubrecord.setCurrentSublistText({
sublistId: 'inventoryassignment',
fieldId: 'issueinventorynumber',
value: opts[0].value
});
mg2017
03/18/2019, 5:39 PMnot sure if i can use the getSelectOption in this manner
b
battk
03/18/2019, 5:44 PMthat code shouldn't work, getCurrentSublistValue doesn't return a Field, setCurrentSublistText doesn't work with the value from a select option
battk
03/18/2019, 5:46 PMim not sure what the context of your code is, but getSelectOption is a method of a Field and generally only works on dynamic mode records
m
mg2017
03/18/2019, 7:13 PMhow should i use this for the serial/lot number drop down inside the inventory details subrecord?
b
battk
03/18/2019, 7:16 PMthe dropdown is a select field
battk
03/18/2019, 7:16 PMthere are 2 ways to set select fields, with the text value using a variant of setText, and with the internal id number with a vairant of setValue
battk
03/18/2019, 7:18 PMthe first option I gave you requires you to exactly match whatever text the select field uses
battk
03/18/2019, 7:18 PMits honestly hit or miss since the text isn't always what you expect
battk
03/18/2019, 7:19 PMthe second option takes advantage that NetSuite provides a list of valid select options which is accessible from the metadata stored in a Field object
battk
03/18/2019, 7:20 PMthe select options includes both the text value and the internal id value, however you might as well use the internal id if you reached this point
battk
03/18/2019, 7:21 PMthe third option is for when you just can't get the select options, so you search for valid values yourself
battk
03/18/2019, 7:22 PMi generally like option 2
battk
03/18/2019, 7:24 PMwhich requires you to use Record.getSublistField to get the Field and then Field.getSelectOptions which gets the select options and finally to use the value key of one of the returned select options to use in the select field
m
mg2017
03/18/2019, 7:39 PMThanks for the info- will try again in a bit.
mg2017
03/18/2019, 10:59 PMthanks, went for option 2 and that worked