This topic contains 1 reply, has 0 voices, and was last updated by rnedelkow 7 years, 4 months ago.

  • Author
    Posts
  • #22817 Score: 0

    DanDeHaven
    • Contributions: 0
    • Level 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.

  • #22818 Score: 0

    rnedelkow
    • Contributions: 0
    • Level 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.

You must be logged in to reply to this topic.