Need help on limiting the number of items

Ask for Help
1

is it possible to limit the number of NEW lessons a user clicks on a day? The idea is not to binge them all. Limit to 4 new lessons in a day… and after the day expired, the next day should display the remaining lessons within the week… hope you all understand

wellness
wellness1366×644 202 KB

2

Lots of different ways to approach this. Here is one way:

  • Add a User Specific date/time column to your Courses table
  • Each time a user starts (or finishes, whatever) a lesson, use an action to set the value in that column to the current time
  • In your Users table, create a Query column and target it at your Courses table. Filter it where the User Specific date/time column is “within today”
  • Do a Rollup->Count through the Query column. If the count equals 4, don’t allow them to do any more lessons.
  • Set a filter on the Course list using the previously mentioned User Specific column. Only show courses where it is empty.

One downside with the above approach is that it won’t be possible for you (as an Admin user) to see which users have done which courses. I don’t know if that is a problem?

2 Likes
3

This sounds interesting… l am not clear on this " * Each time a user starts (or finishes, whatever) a lesson, use an action to set the value in that column to the current time"… how can l set up the action

4

It depends on how you define the action of starting or finishing a lesson in your app. Do you have any built-in flows to determine those?

5

No, l don’t have any built-in flows.

6

So how does a user start a course?
Do they click on something? Presumably yes.
Does that something have an action? Presumably yes.
Extend that action to set the date/time value.

2 Likes
7

l’m sorry for the late reply… the list of courses are in a collection, it doesn’t have an action yet… how can l add an action on the collection?

8

So when you click on a Collection Item, nothing happens?

1 Like
9

basically nothing happens, it’s like it’s on a read mode… how can we setup an action when a user clicks on a video in a item in the collection??

10

The Video component doesn’t support actions.
You would need to configure an action on the Collection Item itself.

1 Like