Discussions

Expand all | Collapse all

Project Manage Due Date Logging

  • 1.  Project Manage Due Date Logging

     
    Posted 06-25-2018 18:23
    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!


  • 2.  RE: Project Manage Due Date Logging

     
    Posted 06-25-2018 18:45
    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


  • 3.  RE: Project Manage Due Date Logging

    Posted 06-25-2018 18:48
    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.


  • 4.  RE: Project Manage Due Date Logging

     
    Posted 06-26-2018 12:45
    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?


  • 5.  RE: Project Manage Due Date Logging

     
    Posted 06-26-2018 12:55
    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.


  • 6.  RE: Project Manage Due Date Logging

     
    Posted 06-26-2018 13:15
    Yes it was a very easy build. Thank you.