I’m currently on the starter plan of glide so can’t check this out for myself just yet. Will be upgrading upon go-live.
I need to delete rows of data after 30 days. Ideally I’d use the API to get row that are 30 days old, export them to csv and then delete the rows using Make, however, I don’t see a way to get rows in the API docs, so is this even possible?
If not, the alternative is to do it via Airtable I guess.
Use an ITE on the table you want to delete rows on and state IF Date Created is > 30 days old, “DELETE”.
Then on your user table, create a Single Value that just says “DELETE”. Next, create a relation between both DELETE. Finally, create a button that only you can see that has an action of Delete Row attached to the DELETE relation. This will delete all rows that are 30 days old.
Its manual vs automated but only gotta do it once per month
Yes I’d planned to use this to export to CSV too, the problem is control.
Unfortunately it is not quite this straight forward a this, if I build in the delete rows that are 30 days old by relation and export to CSV from one button, then it would work for deletion, but the export would be overkill, and way too many emails would be generated. I don’t need 10k CSV exports a month .
I need to give it some deep thought as im sure there is a way to get it to work but without being able to schedule an automation it does become a real pain.
Hence I’m thinking airtable might be the way forward for this part of the app. It will allow delete on schedule and on demand export via webhook and Make, or even on schedule export.
I just need to consider what affect this will have when it comes it update usage.
All becomes rather complex with so many factors and limitations at play!