How to test for no data in a TIME column type...

(Colin) #1

How to test for no data in a TIME column type?

I have tried ot test for no data in a TIME column type with this expression:


However, it is not detecting this column as having no data (i.e. blank).

What expression should I use instead?

(Praveen Seshadri (AppSheet)) #2

ISBLANK() should always return true if the value of the column is blank. There should be nothing special about a Time column type.

Where are you using this expression?

(Colin) #3

In a Workflow of my application

(Aleksi Alkio) #4

Would you please give us more details about the usage. Do you have it in the condition rule or in a template or somewhere else?

(Colin) #5

Its in a workflow action of change data, in the section of:




with an Update event of ADDS_AND_UPDATES

it will …DO THIS

Reaction Change data

Action to update the FINISH_NEXT_CONTACT_TIME to being 10 minutes later than the START_NEXT_CONTACT_TIME

When I check the the test results, I can see that the expression part:


will work, but the:


will not.