My question has two parts.
First, how to calculate the total due for a tenant that is past due on their rent? The equation should look like this: "Total due" = "Rent" + "Late Fee" + "Late Fee Per Diem" x (Day of month(today) - (Day Due). Where Day of month(today) would return 4 (for the 4th of April - for example) and (Day Due) is an integer field in my item and is between 1 and 31 for the day of the month the payment is due.
Second, I would like to automatically send an email (using GlobiFlow) to be triggered when today's date is greater than the grace period. So for example, if the rent is due on the 1st, and the grace period is 3 days, then an email would automatically be sent.
Please sign in to leave a comment.