Slightly SuiteScript adjacent question - I am creating a custom record and adding a custom field of List/Record sourcing from Inventory Numbers. I am trying to filter this field to only show options which are currently On Hand, but the only Filter Using option available is the Item.
1) is there a way to filter in this way without using script?
2) if no, is there a way to have a proper List/Record field on the record, but have a UE beforeLoad run on Create only to set what the available options are? Ie run a saved search and dump the results into the drop down?