In order to send the reminder, you’ll have to store that date somewhere - then you need a system to watch where that data is stored and run your report whenever something comes up.
What I would do is in your report table, you’ve got a report date and from that you get your follow ups; create columns to hold the dates of each follow up. You can use an app formula to easily calculate the next follow up date based on the date of the report along with any criteria you wish to include.
Then you’ll need a report that runs… daily… weekly??? something like that, but in any case a report that’s watching these follow up date columns and whenever that date matches TODAY() - the report fires off and does what you wish.
You can read more about the report system and how to schedule things here: