Is there a way to create a filtered dropdown based...
# generals
screnshaw
02/07/2022, 2:00 PMIs there a way to create a filtered dropdown based on the item fulfillment's status? I currently have custom record that has 2 fields. 1 has a name and the 2nd is the item fulfillment status. The custom record has 4 entries and each record has the Item fulfillment status I want to filter on in the dropdown.
What I'm trying to do is filter the dropdown based on what the item fulfillment's status is.
So if they select "Picked", I want it to show A & B. If it is "Packed" I want it to filter the dropdown to show C & D.
Is this possible without scripting?
k
KevinJ of Kansas
02/07/2022, 2:37 PMYeah, create a multi select field on your custom record
KevinJ of Kansas
02/07/2022, 2:38 PMIf it a b c or d can be on Multiple stages
KevinJ of Kansas
02/07/2022, 2:39 PMThen use your status field is equal to the transaction status as a filter on the custom field on the transaction
s
screnshaw
02/07/2022, 2:39 PMThey can't be on multiple stages unfortunately. Each entry is tied to a specific item fulfillment status, and they can only selectd 1 at a time
screnshaw
02/07/2022, 2:40 PMoh wait. I misread. So I do have a dropdown list on the custom record in which I select the status I want to tie it to
k
KevinJ of Kansas
02/07/2022, 2:40 PMYes.
KevinJ of Kansas
02/07/2022, 2:40 PMmay take some trial and error
s
screnshaw
02/07/2022, 2:40 PMIs the picture I sent what you were referring to? if so, it doesn't work sadly
k
KevinJ of Kansas
02/07/2022, 2:41 PMIt should be.
KevinJ of Kansas
02/07/2022, 2:41 PMmay require some... finaggling
KevinJ of Kansas
02/07/2022, 2:41 PMyou sure you got the right lists?
s
screnshaw
02/07/2022, 2:42 PMSo the first picture is my custom field and the 2nd one is the custom record. It looks to be the correctd list
screnshaw
02/07/2022, 2:43 PMIt just doesn't seem to be looking at the item fulfillment status
k
KevinJ of Kansas
02/07/2022, 2:43 PMI don't think you've got the right lists
s
screnshaw
02/07/2022, 2:44 PMthe correct list/record?
screnshaw
02/07/2022, 2:45 PMThere's only one "Additional Statuses" that I just created so it is correct unfortunately
screnshaw
02/07/2022, 2:46 PMI am wanting to compare it against a native netsuite field. Not sure if that matters
screnshaw
02/07/2022, 3:03 PMYeah, no matter what I do, it will not filter the list based on the item fulfillment status
screnshaw
02/07/2022, 3:36 PMMan. I've tried transaction status, Status, and shipping status. Any other ideas of what it could be? This is quite frustrating
k
KevinJ of Kansas
02/07/2022, 3:40 PMUnfortunately not - this might not be a field with a list that can be accessed.
KevinJ of Kansas
02/07/2022, 3:41 PMCan you make another field that is not stored value, but text - and then source the status field you want in - and see if that will let you compare values?
s
screnshaw
02/07/2022, 3:43 PMlameeeeeeee. Good ole netsuite.
Nah, I'd rather script it before doing that
screnshaw
02/07/2022, 6:17 PMAh, so my theory is on the Item Fulfillment, the value returns A, but on the custom record, it is returnning actual numerical ids.
No idea why NS is doing that
2 Views