Grouped by 1 field

[EdAirtable]

Hey Airtable Community,

I have a list of tasks, and I group them by project (which is a separate table). I also have a field in the project table, specifically a progress field, and I’d like to display this field alongside the grouped tasks in the interface.

I remember I've done it before and I even have a screenshot I attach below. But I can't remember how it's done!

Any help or pointers would be greatly appreciated!

Thanks in advance!

[Mike_AutomaticN · Accepted solution]

Hey @EdAirtable!

That is a fun one. Let me try to guide you through:

1. Create a List Interface
2. Select your Projects table (not your tasks table)
3. On your right panel, and under "Hierarchy", make sure you set it to two levels -see image below.

4. Level 2 should be projects, Level 1 should be tasks.
5. You can decide what fields to show at a Projects level as you would do on any other list interface. In this case, make sure you show the Progress field.

Sorry for the ugly screenshots, lol.

Mike, Consultant @ Automatic Nation

[EdAirtable]

@Mike_AutomaticN you're the best! Thanks for taking the time to help me out with this. This is exactly what it is.

I was playing around with levels, and only tried the nested records - thought that adding a level above will do the same.

Then again, thanks a ton for the help! Highly appreciate the time, Mike.

Have an awesome weekend ahead!

[Mike_AutomaticN]

Hey @EdAirtable!

Happy to help 😄

If you ever need any further help, please feel free to schedule a call using this link.

Mike, Consultant @ Automatic Nation