Forum Discussion

Qrew Captain

6 years ago

Capture date modified if reference field changes

Hi Everyone , I am currently in a project where i need to give data changes which has happened from past 1 week . Initially it looked easy as we have date modified in each and every table. But the ...

Tables and fields

QuickBaseCoachD

Qrew Captain

If lu want to have a parent know that maximum Date Modified of it�s children, then make a summary field of the Maximum Date Modified of its children.

Then have a field that calculates the

Max([Date Modified Of Children], [Date Modified])

You can use this same technique with lookup fields as well when you are going �down� instead of Iup.

ArchiveUser

Qrew Captain

6 years ago

Thank you , Yes your solution worked . But the only issue which I have at the moment is that my Parent table is connected to 30-40 child table, which requires me to create 30 date modified columns. Would you recommend to do the same or if there is any other solution.