Forum Discussion

JeffBell's avatar
JeffBell
Qrew Trainee
7 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 pos...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
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
7 years ago
Ah yes, that works brilliantly. Thank you!