Solved: Re: Resetting due date

naresh_chauhan1 · 10-15-2021 09:03 PM

Hi everyone I recently found the magic of Appsheet, thanks !
I am new to it and I am creating this payment management app where for my building where monthly or quarterly payment is mad through net banking or cheque etc. where we used to manage it in simple excel. so I converted it to Appsheet app, but now I stuck in to this problem where I need latest due date per flat no which are fixed and unique as each time they pay new due date is generated. I want only one which is latest due date not past. kindly see my data.
thanks in advance !

https://www.appsheet.com/start/973bf02d-392f-4e09-a702-03efdcf1b766

WillowMobileSys

I assume the column circled in the image below is where you are having a problem? A payment was made on 10/16 so the NEXT Due Date should not be 10/22 but whatever the Due Date after that is?

Generally speaking, you are going to need, datawise, 2 things in the app:

The list of known Due Dates per user/entity.
Ability to explicitly identify which Due Date (or Due Dates assuming that multiple Due Dates can be made at the same time) that a payment is being submitted for.

Once you know those things, then you can get the list of UNPAID Due Dates and select the min Date as the NEXT Due Date.

Unfortunately, accessing the app doesn’t help with a solution. We need to see how you have implemented that Column to retrieve the NEXT Due Date and how you are identifying which Due Dates have been paid.

View solution in original post

WillowMobileSys

I assume the column circled in the image below is where you are having a problem? A payment was made on 10/16 so the NEXT Due Date should not be 10/22 but whatever the Due Date after that is?

Generally speaking, you are going to need, datawise, 2 things in the app:

The list of known Due Dates per user/entity.
Ability to explicitly identify which Due Date (or Due Dates assuming that multiple Due Dates can be made at the same time) that a payment is being submitted for.

Once you know those things, then you can get the list of UNPAID Due Dates and select the min Date as the NEXT Due Date.

Unfortunately, accessing the app doesn’t help with a solution. We need to see how you have implemented that Column to retrieve the NEXT Due Date and how you are identifying which Due Dates have been paid.

naresh_chauhan1

this is how my data look

from this multiple due date I want to select only latest (as per most recent payment) as it is recurring payment monthly. I want to add that due date to Flat Table which has 44 Flat unique.
thanks!

naresh_chauhan1

thanks it helps me to see it different angle to solve this problem.

I used this approach to solve it…
there are total 44 fixed tenant in the building so every payment details is included with that table and this information is logged to other table name invoice using action and bots.
each time payment is done resetting the field so new due date for that flat. all the previous payment details are saved in invoice table.