RE: Item Validation based on Project

Hi all,

We have a list of Service Items that we use on transaction forms. Currently, when a transaction form is filled out all service items are available to be selected.

We would like these items to validate against the project selected on the transaction form so that only certain service items can be selected to be expensed to the project.

Example:

Project A has the following related items: Admin, Events, Outreach

Project B has the following related items: Admin, Marketing, Operations

Goal: User filling out an expense report for Project A would only have Admin, Events, & Outreach as options to select from in the list field after selecting Project A in the project field.

Do you have a suggestion as to how to accomplish this?

Des Beginner Asked on January 14, 2020 in Items.

Hi,

Whilst I think you could limit the available items based on the user, I can’t immediately think of an option that would allow you to do it based on another field.

Typically, when faced with this sort of scenario, I have needed to do some scripting of a new custom field that then feeds in to the standard field. But that may not be ideal if you have a large number of items as the scripted fields a standard drop-down.

Thanks,

Chris

on January 15, 2020.
Add Comment
2 Answers

For custom fields, check this out: https://technologyblog.rsmus.com/netsuite/creating-dependent-drop-lists-netsuite/

For standard fields (which I think is what you’re talking about here), I think you’d have to do some scripting, ideally creating a custom record to manage the dependencies.

Intermediate Answered on January 15, 2020.

Thanks James. The linked guide was very helpful in getting me to the finish line. I hadn’t thought of using a Multiple Select field.

on January 16, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.