Deleting records after 1 week

[bahamamama]

Hello there,

I am trying to automatically delete records after 1 week. As I am in free plan, I can't run scripts (currently I don't want to upgrade). I set up a field which tags every opportunity with a delete text. Can someone tell me how to solve that with the Search Step in Make (formerly Integromat). The following delete step is not the problem, I guess. Somehow, I just don't find the right formula.

Thanks in advance!

[Greg_F · Accepted solution]

Hi @bahamamama 

Consider following solution:

1. Create a field "Created date" using the prebuilt created time filed type

2. Create a view that contains records older than 1 week. Example below

3. Lock the view as good practice with a note to self why is it locked.

4. Run a daily schedule (or any other frequency that works for you) to check the "Records to delete" view.

5. Add delete records module.

You could also do it with by adding following formula:

DATETIME_DIFF(NOW(),CREATED_TIME(),"day")>7

I do prefer the views usually as it gives better visibility on what will be deleted.

Let me know if that works?

[bahamamama]

Thanks @Greg_F - I've done it a bit differently without deleting but just showing the view. I didn't see the forest for the trees.

[Rose_Haft1]

I am also interested in this feature. I also do not know how to do it.