Forum Discussion

CandaceGregory's avatar
CandaceGregory
Qrew Member
6 years ago

Populating the most recent text from the child table to the parent table

Hi all, I am trying to update the project record with the most recent comments from the task.  I have 2 tables, Projects (parent) and Tasks (child).  I would like to populate a most recent comments ...
Relationships
LeoSanchez's avatar
LeoSanchez
Qrew Trainee
6 years ago
Hi Mark,
But what happens if the parent record is modify but no new comments were added at that point?
Wouldn't the formula be broken since the last comment modified will not be equal to the last modify date on the record?
I thought the solution might be to trim the last task or comment on a log field.
Maybe I was not understanding the original question.

------------------------------
Leo Leo
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
My proposed solution does not use the [Last Modified date] of the Parent.  It it fits obtains the last Modified date of all tasks for that project to identify the tasks which has the comment we need.  Then we look that up down to all task records to be able to have a tier summary field, of the combined text from all tasks records (probably just 1 Record) where that lucky task is the one that matches as being the most recently modified task.

i suppose that summary field could also be modified to only summarize tasks which do that a non blank comment.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • LeoSanchez's avatar
    LeoSanchez
    Qrew Trainee
    6 years ago
    Ohh I see now! Awesome. 
    Makes a lot of sense.
    Thank you sir!

    ------------------------------
    Leo Leo
    ------------------------------