How to check if duration value exists?

[AkDk7]

Hi @ll.

I’ve been facing an issue when trying to check if a duration value has been inserted or not. The following screenshot shows some formulas if’ve tried out. So what I’d like know is how I can identify empty duration values.

So here are the formulas for each column:

• “gleich Dauer” > “{Dauer}”
• “if-not” > not({Dauer})
• “if” > if({Dauer}, 1, 0)
• “text Dauer” > text({Dauer})
• “value Dauer” > value({Dauer})

As you can seen if’ve also tried to convert the duration value but even for an empty value I get “0” returned.

Might this be a bug?

Kind regards
AkDk7

[rdb]

Do you use SeaTable Cloud or SeaTable Server? When SeaTable Server, which version?
What browser do you use? Please see https://forum2.seatable.io/t/read-before-you-post-in-user-talk/16

This is what I did:

• The formula in "Echo column ‘Duration’ " is just {Duration} The result is formatted as a number.
• The formula in “Is column ‘Duration’ empty” is if({Duration},"no","yes").
• The formula in "Is column “Echo column ‘Duration’ " empty” is if({Echo column "Duration"},"no","yes").

The first row shows an unexpected result in all three formula columns. The other rows look fine.

@Daniel @Leo.Shi Looks like a bug to me. Can you confirm?

[AkDk7]

I am running a private server in version 3.1.13 and using Firefox in the newest version.

[rdb]

Hi Jörg, SeaTable 3.3 now features a function isempty() which checks if a cell is empty. It returns true when it’s null, it return false when the checked cell contains any value (including 0).

When redoing the above exercise with the isempty() function, you get what you want:

[AkDk7]

Hi Ralf.

That is awesome! Thanks for fixing this issue and adding new feature. I’m happily testing