Table A has many children in Table B. I would like it that when a record in Table A is created, two weeks later a record is created in Table B if certain fields meet a specific criteria. Example would be to only create the record in Table B is the status field of the record for Table A is not closed. Which I would also like to scale up to 4 weeks and 6 weeks as well.
Now in Automations I see that I could instantly create the three records in Table B. Though if the status field in Table A is closed before reaching any of those time frames, there are three records in Table B that did not need to be created and need to be deleted.
Any recommendations on how to approach this?