I don’t have a particular need for this feature…yet…but I think it would be useful to be able to pick a date column in a table and have it drive an automated process to automatically delete the row if the date in that column is so many days older than today’s date.
Much like how you can select row owner columns or protected columns, you could designate an ‘Expire’ column with an option to choose how many days a row can exist before it expires and automatically deletes that row.
For example, if you designate 30 days as the number of days before a row expires, then after 30 days, the Glide system will automatically delete the row. If a row contains an empty date, then it could be set up so the row never expires and never deletes.
I think it would be reasonable for this process to compare dates based to GMT time or anything within reason. This would be a nice way to keep data sets small. Also with glide tables, it would be easier to maintain since we can’t currently run any scripts against the data in them to do any automatic cleanup.