I have a custom record with two fields: 1. Field `Allowed Departments`: A list of departments. Lets say there are 3 specific departments there. 2. Field

Target Department

. A single select list of departments. Is it possible to filter the options on Field

Target Department

to only show the departments in the Field

Allowed Departments

?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Yes, it is possible to filter the options on Field

Target Department

to only show the departments in the Field

Allowed Departments

. This can be achieved by using the sourcing and filtering feature in NetSuite. Here are the steps to do this: 1. Go to the custom field definition of

Target Department

. 2. Navigate to the 'Sourcing & Filtering' subtab. 3. Set the 'Filter Using' field to

Allowed Departments

. 4. Set the 'Compare Type' to 'equal'. 5. Set the 'Compare to Field' to

Allowed Departments

. This will ensure that the

Target Department

field only shows the departments that are listed in the

Allowed Departments

field. Please note that this approach assumes that both

Allowed Departments

and

Target Department

are custom fields on the same record. If they are not, you may need to use a client script or a workflow to achieve the desired functionality.