Can you add a feature that will count how many times a date is changed?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have an open issues app that my team uses.  I would like the ability to be able to keep a history of when the due date is changed.  I would like it to show a running list of the dates that it has been changed to and then also count the number of times.  I would also like this to be displayed in the form.
Photo of Jason

Jason

  • 50 Points

Posted 2 years ago

  • 0
  • 1
I suggest that you make a child table of the due date revisions and set up the app so that the only way to change the due date is to add a record.  The Add Record button can be renamed to be called [Change Due Date].  I suggest that you may want to initially allow a user to enter the due date and call that field [Original Due Date].

Then you will use the reverse relationship method to float up the most recent due date record up to the parent record.

So to do that you make some resealed on the relationship between your main record and the due date revision tables to summarize the maximum record ID number of the due date revisions.  Call it [Record ID# of the most recent due date revision].  While you are there you may as well also do a summary field of the account of the number of due date revision records.

Then you will make a reverse relationship where one due date revision has many made records. For the reference field on the right hand side of the relationship you will use that newly created field [record ID number of the most recent due date revision]  once you have that relationship built you will then do a lock up of the due date to the main record, and call it [revised due date].  
Photo of Neal

Neal

  • 70 Points
Hi Jason,

I have created spreadsheet screenshot prototype from your requirements.


Neal

NealPatil @ gmx.com
Photo of Jason

Jason

  • 50 Points
So this would be a new table with those fields?
Yes, a new table and a relationship where 1 main record has many date revisions