Project Manage Due Date Logging
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!
Thanks!
Forum Discussion
5 Replies
- 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 - 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. - 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?
- 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. - Yes it was a very easy build. Thank you.
