Hello, Everybody.
I created the sublist that has ...
# suitescriptx
XueDong Mei
01/27/2021, 9:29 AMHello, Everybody.
I created the sublist that has 2 columns - Item, PurchaseOrder.
Item is List/Record field on Item record.
Now, I want to create drop-down PurchaseOrder column that is filtered by selected Item.
Could you please let me know how can I create this column in custom form in Suitelet?
Thanks
b
battk
01/27/2021, 9:31 AMsuitelets arent known for being dynamic
battk
01/27/2021, 9:33 AMunless you are planning on reloading the page and filling in the select options serverside, you will be using Field.insertSelectOption(options)
x
XueDong Mei
01/27/2021, 9:37 AMHmm... but, when we create a custom field or list, we can use Sourcing & Filtering feature.
It means that we can implement this logic in UI,
b
battk
01/27/2021, 9:38 AMif you can find a sourcing and filtering option in the docs, feel free to use it
battk
01/27/2021, 9:39 AMdont expect to match the features available in the ui using the serverWidget, its not that powerful
x
XueDong Mei
01/27/2021, 9:41 AMSo.... there isn't any other option to do this logic?
b
battk
01/27/2021, 9:48 AMnope, essentially do it yourself
w
Watz
01/27/2021, 10:10 AM@battk would you use Field.insertSelectOptions on lineInit or could you do it serverside for each line already?
b
battk
01/27/2021, 10:32 AMwont be that nice
battk
01/27/2021, 10:32 AMhave to do it on fieldChanged for when the source field change
battk
01/27/2021, 10:33 AMand lineInit since the same field is shared among all lines, meaning same options
battk
01/27/2021, 10:35 AMmay also end up dealing with the ugliness that CurrentRecord.getSublistField(options) requires an existing line
👍 1