ISBLANK works when I open the app and the space is empty, when I fill it it returns me a False as it should work. But when I leave the space empty again, it keeps refreshing me FALSE instead of TRUE.
Hi @Hern-ec53, welcome to the community! Thank you for raising this with us.
I tried this out, and I'm seeing the same behavior as you've described; I'm passing this along to our team to address. For a solution now, you can use
="" instead of
ISBLANK to validate if the field is empty or not. It would look like:
Hope that helps, and thank you again for bringing this to our attention.
Just adding onto @Alyssa:
Cleared datetime fields default to 0 instead of "", so you need to use
I've been using
OR(ISBLANK($[DataCell]),$[DataCell]=""), which has been working for the most part.
thank you for your reply. what I used was LEN(). Thank you!