Hello, I have a virtual column named Total Man Downtime.
I put a code
[Total Man Downtime] > “00:00”
But it still visible on the app.
I want if the duration is 00:00, the Virtual Column was not visible, then if the Virtual Column has a value like 00:01 or etc. Then the VC will become visible.
I also try the ISNOTBLANK([Total Man Downtime] <> “00:00”), still visible.
I also try the ISBLANK([Total Man Downtime] <> “00:00”), Its Work! the VC was not visible, but when i put value on the VC, its still hiding, i thought it was show up.
Thank you in advance!
In AppSheet “duration” needs an extra 0 at the beginning.
So a duration of 0 hours is to be denoted as “000:00:00” and a duration of 3 hours 45 minutes is to be denoted as “003:45:00”
On the other hand, a time of 3 :45 AM is to be denoted as “03:45:00” and a time of 10:35:55 AM is to be denoted as “10:35:55”
So please try your show _if expression as
[Total Man Downtime] > “000:00:00”
2 Likes
@Suvrutt_Gurjar Thank you sir!
It’s Working now! I put “00:00” only because I ignore the second.
but why needs an extra 0 at the beginning of duration?
As I shared examples, , the extra zero (0) identifies duration from time.
As you can understand, a duration is elapsed time period or time difference between two time instances such as [Start_Time] and [End_Time] . So duration is computed by [End_Time]-[Start_Time] whereas time is just an instance such as [Start_Time] or [End_Time]
2 Likes
I see. Now i understand. Thank you for the explanation! God bless sir!
2 Likes
