seems easy enough, but my brain is fried from appsheet training tutorials 😂
I have created a new table called Daily Totals, and the column I am interested in is [Timestamp]
I have a button called "Submit Daily Totals" and i only want it to show up if there is no record in the Daily Totals table with a timestamp equal to today, but I am not quite sure how to target this.
I'm guessing i need to check a list of values from Date[Timestamp] and show the button if the list does not contain TODAY() but i currently get confused with looking for values in a list due to a brief argument with INTERSECT and CONTAINS and some general confusion about the use cases for both.
Help me understand a proper expression for this context?
Thanks
The crucial part is to understand the inputs and outputs of each one
Now, for the problem you are trying to solve, this is a way to solve it:
COUNT(
FILTER(
"YourTable",
DATE([Timestamp])=TODAY()
)
)=0
Thank you for both of these, i shall start reading!
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |