Hello smart people. I have the follow records set up in my system. I would like the MultiSelect field C to only show items in the drop-down where a record exists of type E such that the field F on E matches the field B on A. Is this possible somehow? Can I somehow control the options in a multiselect based on a Saved Search or SuiteQL in a script? Obviously regular field sourcing won’t work.

If you can work out a suiteql for what you want to show, you can hide the real field in Beforeload and add a custom multiselect where you add your options. In beforesubmit you then copy the selection to the real field.

This is what I’m thinking. Or have a second (hidden, non-stored, added via UE) field of type E that sources from field B, and then source field C from that.