This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

you can’t source off a multiselect field, right?

Yes you can
<https://www.netsuiterp.com/2018/11/when-sourcing-multi-select-field-from.html>

Also you can use a workflow to source the value as well

<https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N2751166.html#Set-Field-Value-Action>

I mean field A is multi select, field B uses field A to reduce its options

when I go to create field B, field A is not listed under `Source List`

It works the other way I think....Field A is a single select, but you can have a multi select on the record in field B that is your filter

yeah, I cannot do this I don’t think, this is infuriating, I am super stuck

have multiselect dropdown of type A , second field of type Item is also a multiselect and needs to filter to only options where there exists a record of type X that has xref A/Item

ack.  I am describing my problem poorly.  I don’t want to actually SOURCE off that, just FILTER the possible options down.

What is the list/record referenced in field A?

FYI I think the filtering field needs to be a single select field but we can still attempt it. I think if you try to filter a multi select by another multi select it is not possible. One of them needs to be single select

Is there a field on your item record that references the same custom record?

different lettering, but this is the relationship between record types:

Screen Shot 2024-01-30 at 3.01.26 PM.png

field C should only have options listed in the drop-down where there exists a Custom Record of type E where field F = field B

Screen Shot 2024-01-31 at 3.38.18 PM.png

To use native filtering you would need to assign custom record D as a field on the item record

yeah, was hoping there was some clever workaround

Otherwise this would require a scripted field

but I cannot add/remove options except in UserEvent, so then the act of changing field B won’t trigger the options to change

Yes sorry I remembered i did this awhile back for filtering a custom Units field based on the Units Type, and used insertSelectOption and removeSelectOption to filter a sripted field

then stored the scripted field in a separate stored field to store the value