I need an expression that considers blank rows...

I have a table that users enter a new row daily.  I need the expression to check if the user has already enter a value(s) for that day = TODAY()

 

Here is what I have, I can't get the ISBLANK... correct.  I want the user to be able to enter a new row if it is a NEW day, meaning they have NOT entered data for today()

Table = Pre Trip Inspection table

[VR DATE] = TODAY() 

 

OR(
ISNOTBLANK(FILTER(Pre Trip Inspection table,
AND(
USEREMAIL() <> [Employee Email],
ISNOTBLANK([key]),
[Status] <> "Complete"
))),
ISBLANK(FILTER(Pre Trip Inspection table,
AND(
TODAY() = [VR Date],
ISBLANK([key])
)))
)

 

 

Solved Solved
0 2 88
1 ACCEPTED SOLUTION

Are you using this expression in the add action's condition or what? 

ISBLANK( FILTER( table , AND( [date]=TODAY() , [user]=USEREMAIL() ) ) )

View solution in original post

2 REPLIES 2

Are you using this expression in the add action's condition or what? 

ISBLANK( FILTER( table , AND( [date]=TODAY() , [user]=USEREMAIL() ) ) )

Sorry.  No - I am using it to Show if a view.  I do NOT want this view shown if it does not meet the criteria.

Top Labels in this Space