Forum Discussion

JeffBell's avatar
JeffBell
Qrew Trainee
8 years ago

How to update a parent field when child is added?

I have a PM tool I'm building and, obviously, it has tasks. I'm allowing users to add comments on tasks. When they do that, I would like to update the task's "last modified date" or, if that's not possible, another date/time field. Can anyone help me out?
Ask about Quickbase functionality
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Are the comments being added as a child to Tasks?  I will assume so.

    "no problem".

    On the relationship between Tasks and Comments make a Summary (maximum) of the [Date Modified] and call it [Date Modified of Most Recent Comment].

    Then on the Task record make a new formula date/time field called [Date Modified of Task or Comment]

    The formula will be

    Max([Date Modified],[Date Modified of Most Recent Comment])
    • JeffBell's avatar
      JeffBell
      Qrew Trainee
      8 years ago
      Ah yes, that works brilliantly. Thank you!