Project Manage Due Date Logging

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
We manage projects with very extended development cycles. I have due dates for milestones, but I want a log that keeps track of every time a due date is changed.

Thanks!
Photo of Garfield

Garfield

  • 170 Points 100 badge 2x thumb
  • lucky to have such a good community

Posted 5 months ago

  • 0
  • 1
Photo of Rob White IV

Rob White IV

  • 948 Points 500 badge 2x thumb
Why not create a log table and write an entry to it everytime a change occurs in the due date field. 

You could probably get that done with a fairly simple QuickBase Action.  Go check out adding an action to the table containing the due date field.  It is really straight-forward.

~Rob
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
Actions can be very useful for logging date changes.  Here is some help on Actions
https://help.quickbase.com/user-assistance/creating_a_quickbase_action.html


So, for example you could set up a child table of date changes and create an entry in the child log table when the due date changes.

Note that you can only trigger an action when the record is edited and the date changes, it will not trigger if the due date changes as a result of a lookup field changing.
Photo of Garfield

Garfield

  • 170 Points 100 badge 2x thumb
There is no way for me, in a form, to just have a text box that just adds a line every time the date field changes?
Photo of Rob White IV

Rob White IV

  • 906 Points 500 badge 2x thumb
No. A form operation would not give you the results it seems you are after. Use an Action to record the changes to another table. Then review that table for your insights.

Setting up the table and action should take you about 15 minutes, I would guess. Possibly less.
Photo of Garfield

Garfield

  • 170 Points 100 badge 2x thumb
Yes it was a very easy build. Thank you.