Discussions

Expand all | Collapse all

How to update a parent field when child is added?

  • 1.  How to update a parent field when child is added?

    Posted 02-23-2018 15:50
    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?


  • 2.  RE: How to update a parent field when child is added?

    Posted 02-23-2018 16:06
    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])


  • 3.  RE: How to update a parent field when child is added?

    Posted 02-23-2018 18:29
    Ah yes, that works brilliantly. Thank you!