If the users already did something today

Hey guys!

I have a few ideas around this but thought i’d throw it out there if you have any better ideas :slight_smile:

Imagine an app like a diary, users can do an entry per day, but it’s limited to one per day. So I need some clean logic to say if the current users’ diary entries already contains an entry created today, don’t show x BUTTON for example…

How would you guys tackle that?

I’d use something like this:

do a search for (diary entries where created date :extract day = current date/time :extract day) :count = 0

Note - I don’t believe you can extract the day on the created date in this equation so you may need to handle that differently, such as storing a separate field when you create the item and store day created as “current day/time :extract day” so that you can reference that in the equation above instead.

3 Likes