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.