Is there a way to delete rows based on a set condition? Now that there are row limitations for free apps, I’m thinking of a way to build an app that basically resets itself every month so that it (hopefully) never hits the 500 row limit.
Here’s the concept: users enter workout details into the app (i.e. on Monday, I biked to work). Each workout has a points value attached. Users are then ranked and top users for the month are recognized in some way for promoting health and wellness (FYI I work at a health centre).
The goal would be to avoid the 500 row limit by clearing the data every month and having users start a fresh “competition” for wellness points each month (without me having to worry about clearing the sheet on the first day of each month).
Any idea if this is possible?
Note: I’m not trying to come up with ways to use Glide for free and avoid paying for the great service. We are a non-profit and this is something that would be meant for employee wellness/team building, which isn’t something we receive funding for (so we do what we can for free whenever we can!).