Notions filter - filter for 0 pcs?

[AnikaH]

@TheWizard Not sure if this is a feature or a flaw, but under Notions I tried to filter Quantity to 0 so I could isolate the newly bulk added buttons for updating their details. I’d like there to be an easy way to do this like there is for patterns and fabric and was hoping this would work, but I ran into issues with this that might help with development.

Screenshot 1: The slider allows me to set 0 as both ends of the range, yet no records are shown.

Screenshot 2: Adjusting the slider to 0-6 (actually shows as 6.1) shows records with a quantity set but not 0 quantity records.

Screenshot 3: My last screenshot shows that I do, in fact, have several records with no quantity set. When I sort the records by Quantity, both ascending and descending drop 0 quantity records to the bottom, so that’s something at least.

I suspect that, for the database, that initial 0 is not saved as a number ergo it is not recognized in the quantity filter. But that’s just an offhand guess.

EDIT: I was staring at my screen captures and realized the multiple choice fields probably have No Value filters like they do elsewhere! I ran back to Notions and checked with the Colour field and confirmed, so I’m in business!

[Ariane_et_le_fil]

To complete my bulk added records, I’ve used the filter “Date purchased - New - old”. It could maybe work as a workaround for you ?

[AnikaH]

Thanks for the suggestion, however this date isn’t available to be set during bulk import, so selecting that filter doesn’t really do anything for me. I use Date Added in Patterns and Fabrics, however that isn’t available under Notions.

[AnikaH]

I just posted an edit to my original post - it occurred to me that multiple choice fields, like Colour, have No Value filters elsewhere and I can use those to identify records that haven’t been completed yet. This does what I need, so I’m good to go.

[TheWizard]

Glad you found a workaround but I’ll have a look into what’s going on.