Choice list doesn't display when filtered

I have a choice list that is filtered to not display items that don’t have a count > 0. This works great but when all the items in the list have a count of zero the entire choice component disappears from the layout.

Is there a way to still show the list and since there is no required field - simply still list the component but only the empty selection? My users may get confused when the choice list vanishes.

UPDATE:

I found a workaround that perhaps can be used by others:

  1. I created a query column that filtered my list by category. this listed rows that matched thd filter = cat1, cat2, etc
  2. I then created a rollup column for the q column that added the sums of the remaining items
  3. I created a single value column in the users table that pointed to the rollup sums. So when any given category is out of items i have a way to display a message that says “no more of x” when the choice list disappears.

This works, but I assume the reason you don’t do this in the Users table from the start (the query & rollup part) is because they have to be by category?

1 Like

you would be correct. thanks for asking

1 Like