Exclude options in automatic filter where there are no records in my model with those values

Conlan O'RourkeConlan O'Rourke ✭✭✭✭
edited June 25, 2020 in Questions
Automatically generated filters are great! But I must be missing something, because I don't want to show options that would filter for 0 records.

How do I exclude options from the filter if the model does not have any records that match that value 
image

Also, any idea why my "Other" option wouldn't be showing here?


Comments

  • Pat VachonPat Vachon 💎💎💎
    edited June 25, 2020
    Use an aggregate model and snippet to generate the options. Can even include the qty in choice.
  • Conlan O'RourkeConlan O'Rourke ✭✭✭✭
    edited November 28, 2017
    Awesome! Didn't even need the Snippet, I just used a filter with Select Option - Manually, and used Rows in a Model (with the aggregate model) as the Option Source

    image
  • Pat VachonPat Vachon 💎💎💎
    edited November 28, 2017
    Awesome!
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!