Announcements
I'm trying my first fx columns in a model driven app. The first columns worked fine now I try an if statement with date only fields. I wan to check if a field is blank to decide which value to show in the field. I am sure that the = blank() is wrong but what would be the correct statement to check if a field is empty?
You can use The IsBlank function which tests for a blank value or an empty string.
If( IsBlank( 'Extended Warranty' ), 'Product Warranty Expiry', 'Extended Warranty')
Please thumbs up if it helped or mark as solution if it worked for you 🙂
Hi Lauren,
thank you for the quick reply. I tried that way also but it always gives me an error. I get the slight feeling that there is something in the environment that is not correct. Just for the record I get the error only when using the blank or IsBlank in a different field I have a if statement and that works.
The error is one of the brilliant kind: "Something went wrong. Please try again later."
I found the cause for the error. It was in the field Extend warranty which is using the product warranty in it's formula and that causes the exception.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
