Creating recurring records


I’m trying to create recurring records, the logic is as follows:

I have a table with Field A and Field B
Field A is a date.
Field B is a calculated date one week from Field A’s date.

When a record’s Field A is older than NOW(), I want to create a new record with Field A being populated with the date from Field B.

Is there a way?

Please note I’m not trying to update records, I need to keep the previous records and just create new ones based on the above rules.

A Way to Handle Recurring Tasks?

Have you tried using zapier? sounds pretty simple.
Trigger: record enters view (view is defined as date>now)
Action: create record (in which date is original record date + 7d)