Expression Assistance - Only Show Button if Not Record Exists with Today's Date for the Timestamp

seems easy enough, but my brain is fried from appsheet training tutorials :joy:

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

INTERSECT() - AppSheet Help


CONTAINS() - AppSheet Help


IN() - AppSheet Help


The crucial part is to understand the inputs and outputs of each one

3 Likes

Now, for the problem you are trying to solve, this is a way to solve it:

COUNT(
 FILTER(
  "YourTable",
  DATE([Timestamp])=TODAY()
 )
)=0
3 Likes

Thank you for both of these, i shall start reading!

1 Like