Hi, anyone know how to filter the items available ...
# general
w
Hi, anyone know how to filter the items available on a purchase order based on the supplier chosen? (if possible)
l
Hi Tomas, you would need a script and a saved search for this
w
How would you implement that? I was thinking about having a custom multi select field on items that with a script selects all vendors that are on that item. Then a custom transaction column for my own item list that is filtered with "custom multi select field" equals "vendor". Then a client script that sets the standard item field from the custom, filtered, one.
l
yeah I think that could work. I'm not a developer so there could be another way as well. might be possible to set the saved search as the item filter on the form and have a script reference the vendors that are selected on the item record
w
You can have a saved search as an item filter through ordinary customization of the form. But as far as I know, that cannot make use of filters from the record.