Rent due calculation

Ask for Help
1

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

1 Like
2

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.

  • Use JavaScript or something that works to calculate the “due dates” based on the schedule. Say I have a semi-annual rent, starts on 1st Oct 2023 and ends on 1st Oct 2024, the code would give me the due dates being 1st April 2024 and 1st Oct 2024.

  • Use another JavaScript column to calculate the “next due date” based on current time, and a math column to calculate the difference between that next due date and the current date.

  • 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.

1 Like