4 level roll-ups - can this be done?

Hi all - trying to figure out if this can be done.

Simplified question as follows: I have an App with 4 levels of nested tables - Parents, Children, Grandchildren, Great-Grandchildren. Each “child” has a one-to-one Connection to the respective “parent” level above. Let’s also assume each record in each table has the person’s age (years as an integer).

If I want to roll-up (Sum) the ages of the Parent’s children (1 level down) - easy in a table a/o by creating a roll-up field in the Parent table.

If I want to roll-up the ages of the Parent’s grandchildren (2 levels down) I can do this with a table, but doesn’t look like I can create a roll-up that goes two levels deep.

If I want to roll-up the ages of the Parent’s great-grandchildren (3 levels down) - no luck, I can’t figure this out. I did create a “pre-rolled” field at the grandchildren level (grandchildren roll-up of their great-grandchildren’s ages) but I’m limited on how I can roll-up the roll-ups at the Parent and Children level’s above.

So question is - if I have tables nested more than two levels deep, is there any way to use the Roll-up a/o Sum functions? As a data modeling exercise, I don’t think there’s any limit on rolling up nested tables X levels deep, so maybe this is a Tadabase limitation?

Anyone have thoughts on how to make this work? Any workarounds out there using additional fields / additional tables / additional formulas?

Thanks all for any / all help!

@DJ_Cosmo -

I have been working on an application with a similar rollup need. However, after speaking with TB staff, this concept exceeds the capabilities of the current platform without working outside of TB with API calls.

IOW, it can’t be done natively in TB at this time.

Sorry,
Adam