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! Go to Solution.
Are you using this expression in the add action's condition or what?
ISBLANK( FILTER( table , AND( [date]=TODAY() , [user]=USEREMAIL() ) ) )
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.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |