Skip to Main Content

Share your product feedback

Status Future consideration
Categories Application
Created by Jonathan Steel
Created on Dec 24, 2024

Better equation function to compare against empty notes

What is the challenge?

Sometimes you want to check if a note (like descriptions) are empty in an equation field. There are two empty states, one where the note is truly empty, and one where the note is empty after previously having content in it. The latter has some html content that is not visible on the screen. You have to compare using the following:

if(field("Feature description") == "<p><br/></p>", "empty", if(field("Feature description") == "", "empty", "not empty"))

What is the impact?

It's impossible for users to figure this out on their own and makes it impossible to check against an empty note value.

Describe your idea

Provide some means of checking the empty value. This could be a new function.

if (empty(field("Feature description"))

or

if (empty_field("Feature description"))

or

if (empty_note_field("Feature description"))


  • Attach files
4 MERGED

Calculation columns should recognize note field values as blank/0 characters when content has been deleted

Merged
What is the challenge? When using a calculation column in a report to capture if a note field is blank there are currently two states of emptiness. The first is when the note is truly empty and has a character length of 0, the second is when a not...
Guest 22 days ago in Reports 0 Future consideration