I have a column for rent start date, rent end date, payment schedule ie quarterly semi and annual and a total rent for a year contract. I want to create a list that would list due amount 30 days before due date. Could anyone help please
thanks in advance
Just an idea here, you might have to dig in more to test if it’s viable:
Based on whether the schedule is quarterly, semi-annual or annual, divide the rent amount so you can have a “due amount” to show.
Show the due amount if the difference is less than or equal to 30 and greater than -1. Hide it when the user has paid.