Check-in system

[katlavender50]

Hi! I want to create a check-in system where users can check in everyday to get points. Users can then use it to purchase products.
I want to:

• Make sure they can only check in once per day, not when they refresh the page
• award more points on holidays and weekends
  I’d appreciate it a lot if someone could help me

[georgecollier]

1. Create data type ‘point’ which has User, date (date) and ‘points’ (number)

2. Have field ‘points’ on User

3. When page is loaded, only when Do a search for points (date = Current date/time rounded down to day):first item is empty, create a new point for current user and add points to Current user’s points

4. Extract day from Current date time, if Saturday/Sunday increase points by X

5. For holidays, you could create a data type holiday which has the date of each valid holiday and search the Holidays to see if today is a holiday.

[katlavender50]

Hi, thanks a lot for your fast reply, I followed your instructions but every time the search for points: first item in the debugger turns up empty, even though it isn’t in the data.

[georgecollier]

The date of your point is Sept 3rd 11:29, and your Current date time expression rounds to Sept 3rd 00:00, so the dates aren’t equal.

Add the dates so that each date is at midnight, or make the search constraints a range so date >= current date time rounded down to day and date< current date time rounded down to day +days (1)

[katlavender50]

Thank you so much so much! It’s now working