Skip to main content

As a business consultant, I would like to display parent/child relationships within a table as an indented outline within a grid view so that I can decompose items like organizational goals and project tasks and clearly show the hierarchical relationship. This would allow me to use Airtable instead of other specialized software that supports sub-items (e.g., subtasks, subgoals, etc.). All my items have the same columns, including a “parent”, but the current views (such as grouping by “parent”) do not suffice. No special rollup capability is needed within the hierarchy.


Example:

Title Priority Parent

My first item High

L A subitem Medium My first item

L A subsubitem High A subitem

I have a similar need. I am trying to create a budget where all the accounts are in the main table (grid view), but some of them are subaccounts of other accounts, and other are sub-sub-accounts. All the parent/child relationships are between records in the same table. How do I display the data where the sub accounts are intended under their parent records and can roll up (including a calculated sum field) For example, 

100 Personnel Costs

        110 Salary & Wages

        120 Healthcare

200 Facilities

        210 Rent

        220 Maintenance

        230 Exterior

                231 Grounds

                232 Signage

etc....

I tried the List view type, but that requires a relationship between records in two different tables.


At time of writing, a same table parent-child field feature is number one on my most needed feature.


I have just added a comment here as well. 

Seems this is a pretty common request
https://community.airtable.com/t5/product-ideas/recursiveness-parent-child-subitems/idc-p/188024#M18076


Reply