[DanDeHaven Contributions: 0Level 1☆]

How can I limit the values listed in an Available Filter (list field) on a saved search?

Let say I add the State/Province list field to a Customer Saved Search's Available Filter, how can I limit the list to just US States?

Or, another example, how can I limit the Customer (Name) list field to just "Customers" and exclude Leads and Prospects?

Thanks!

Dan
This is a cached copy. Click here to see the original post.

[rnedelkow Contributions: 0Level 1☆]

The US State filter should be doable using the alternate solution provided in SuiteAnswers Answer Id: 38602.

---

DanDeHaven replied on 06/12/2017, 03:44 PM: Thanks Robert, I’ve read that Answer, and while I agree it is a good work around I was hoping for a dynamic solution that doesn’t require a maintenance component.

It would be nice if Available Filters could be limited with a formula or a Saved Search, and cascade each into each subsequent filter (from left to right) and thus only show values in a filter list that are present in the data set.

[Author]

Posts