My question is: are my formulas in the last screenshot correct? I’m not very technical so I’m always very nervous with these things, especially when the last box says “Apply to: All rows”
So with that, each morning, your table will be cleaned
PS : Personal suggestion, rather than deleting your row, I suggest you to add a status like “active/inactive”, and that your automation put the status to inactive, and you filter your view to show only active. So that you will always have access to your data rather than deleting it !
hi @Quentin_Morel , to start with your last advice. That seems the way to go for me: do not delete but hide.
anyway, @Duy_Nguyen asked us to help with a delete. it can be done in various ways like the one described very well by @Quentin_Morel . What I like about the question is the honesty related to ‘all rows’. What the software does is indeed running over all rows, but it is up to us to tell the software what to do with each row. We are in control
Below my take on it.
table with checkbox and column that contains the last change
checkbox that only gets active when there is a delta of 30 days and the update is checked
next we add a rule that is only active when the date is 30 days in the past and the checkbox is checked. Two conditions have to be met. Since the function does not allow for manuel manipulation, I added a test column to show you how it works.
@Quentin_Morel since my approach is already somewhat similar to yours, I ultimately went with your method, but like @Christiaan_Huizer said, both can get me to the finish line
I love @Christiaan_Huizer 's way of adding the formula right into the Date Updated column so it would actually calculate all the previous rows as well, so I used that instead of creating an automation.
To answer your question about why I want to delete the rows: It’s because after 7-14 days most, if not all orders would have been received by the customers, so we would have no need for it.
If we still need to look it up, we can look up the order tracking via email (since that’s the original source & where we pull the data from).
To also lighten the load on Coda (with GSheets, I know once you get to a certain number of rows, it starts to get slow). Just trying to be proactive
)
