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:
- I created a query column that filtered my list by category. this listed rows that matched thd filter = cat1, cat2, etc
- I then created a rollup column for the q column that added the sums of the remaining items
- 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.