Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

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 😂

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

0 3 94
3 REPLIES 3

INTERSECT() - AppSheet Help

SkrOYC_0-1661459310547.png


CONTAINS() - AppSheet Help

SkrOYC_1-1661459349678.png


IN() - AppSheet Help

SkrOYC_2-1661459412568.png


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!

 

Top Labels in this Space