I want to set a condition for a view to only ...

expressions
(Ronald Boateng) #1

I want to set a condition for a view to only display list of entries for current day.

I used the following formula as a Show_If constraint for the view type. [Date]=TODAY() The expression assistant informs me cannot find the column “Date”. Meanwhile, I have a column name date in my spreadsheet. How do I solve this?

(Aleksi Alkio) #2

You can’t hide the view with the column’s status if the same column is in that table. You need to create a slice or security filter where you can filter the data row by row.

(Ronald Boateng) #3

Will try this. Thanks!

(Ronald Boateng) #4

@Aleksi_Alkio I used security filter option and it worked.