Limit the number of times a user group can access data in a particular table

[daffinm]

Imagine you have set a rule that your kids are only allowed 2 cookies from the jar when they get home from school. They have access to the cookie jar (a particular table), but they can only have 2 cookies (2 records per day). When they try to take a 3rd cookie they will be blocked, and redirected to a different page.

How would one do this with AirTable? We have tried doing it from the UI in Softr, but this requires us to update the UI when users in the kids group have taken 2 cookies, which is a little tricky to get right. It would be much better if this limit could be implemented on the server side, in AirTable, somehow.

Any thoughts anyone, please?

[TheTimeSavingCo]

Hmm, I don't think that's possible natively with Airtable I'm afraid.  I think I'd explore embedding the data on a page, putting a login on that page, and logging whenever each user went to that page.  That would allow me to do acheck whenever a user logs in to see how many times they've taken cookies, and if they've taken 2, do not show the embed

[daffinm]

Thanks. That makes sense.