How to update a parent field when child is added?

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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?
Photo of Jeff Bell

Jeff Bell

  • 200 Points 100 badge 2x thumb
  • confused

Posted 9 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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])
Photo of Jeff Bell

Jeff Bell

  • 200 Points 100 badge 2x thumb
Ah yes, that works brilliantly. Thank you!