Im not sure if this has been asked before. I tried searching for it but could not find a solution. So here it goes.
Im trying to do a simple recurring monthly subscription record.
John is billed every 13th of the month. On his record there is a checkbox, bill date and next bill date.
The next billdate is a formula that adds 30 days from the bill date.
I have created a view called Monthly. When John makes a payment, the check box will be checked and it will appear on the monthly view. I wanted to uncheck this boc 7 days before the next bill date and how do I update the next bill date so it would add 30 days everytime?