Skip to main content
Question

How to update a parent field when child is added?

  • February 23, 2018
  • 0 replies
  • 21 views
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?
    This topic has been closed for replies.

    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])
    Terms & ConditionsAccessibility statement