Some businesses has the requirement to have a dropdown/multi-select field to show specific values depending on the values of another field. In this topic, we will show you on how to do this by utilizing the Custom List and Record feature.
Create a Custom List:
1. Navigate to Customization > Lists, Records, & Fields > Lists > New
2. On the Custom List page, set the Name (In this case, we'll use Product Area) and feel free to add any values you need for the list.
For our example, we've listed values for Product Areas as seen below:
Create the Custom Record:
1. Navigate to Customization > Lists, Records, & Fields > Record Types > New
2. On the Custom Record page, set the Name (In this case, we'll use NSC Thread Topic) and click on Save & Edit
Create a Field in the Custom Record:
1. Click on New Field
2. On the NSC Thread page, set the following fields:
- Label: Product Area
- Type: List/Record
- List/Record: Product Area (The custom list we've created)
Create values for the Custom Record:
1. Navigate to More > View Records > New NSC Thread Topic
2. On the NSC Thread Topic page, input the following fields:
- Name: Custom Fields (We'll use this as an example)
- Product Area: SuiteBuilder (Select the Product Area this belongs to)
3. Keep repeating Step 2 until you're done creating the list of topics for your Custom Record as seen below:
Create the fields for the Custom List and Record:
Note: For this example, we'll be applying it to a Custom Record (NSC Thread). You can add this to the standard transactions (Sales Orders, Purchase Orders, Invoices, etc.):
1. Click on New Field
2. On the NSC Thread Field page, set the following fields below:
- Label: Product Area
- Type: List/Record
- List/Record: Product Area (The Custom List we've created)
- Store Value: Yes
3. On the NSC Thread Field page, create another field and set the following fields below:
- Label: Topics
- Type: Multiple Select
- List/Record: NSC Thread Topic (The Custom Record we've created)
- Store Value: Yes
Sourcing & Filtering subtab:
- Filter Using: Product Area
- Compare Type: Equal
- Compare To Field: Product Area
Results:
Once done, it should now filter the Multiple Select field (Topics) depending on the selected Product Area as seen below:
Hope this helps! 😊
Want to learn more about Customization? Visit New to NetSuite: SuiteBuilder & SuiteBundler
Do you have any feedback? Let us know in the comments!