(This likely needs to be elevated to MachForm's developer kiddos, but the employee who set up our account with access to the "Billing Area" has left without leaving the password for it... but that's whole other problem.)
As an admin for a university, I need to be able to filter forms that have zero entries.
However when I create a Smart Folder with any of the following rules:
• Total Entries Less than 1
• Total Entries Is 0
• Total Entries Is {null}
I always get "There are no forms in this folder", but by manually clicking on the "Entries" tab of individual forms I can find hundreds of forms without a single user entry.
This is likely happening because the count stored in the database is defaulted to `` ( aka, null ), and comparing ANYTHING to null (in many cases even against another null) will result in false, meaning they'll never match for result selection.
--
Furthermore, after our recent MachForm update, forms older than 2024 have lost their "Creation Date" leaving those forms with a null for their creation date within the database as well. So when I filter for forms with a Creation Date Before 12/31/2023 query, I also get "There are no forms in this folder" despite their being over 300 forms made between our purchase of MachForm in c.2021 and 2024.
Unrelated: this Discussion Board's "new user sign-up" form allows a plus sign (+) within email addresses (like my usual address), however your email verification system breaks when clicking on the sent confirmation link (The resulting page displays an "Invalid confirmation token" error and does not allow me to go any further.)
Null Island