How to "group by" a column that contains "link to other record" (allow linking to several records)

Topic Labels: Base design
295 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I habe a base with two tables (simplified below):

  • 1 for projects & 1 for the people working the projects
  • both tables are connected with "link to other record"
  • one person can work on several projects (allow linking to several records)


in the projects table, how can I do a "grouping" by "person" without have all combinations as a group each but always only a single option. 1 Person, all projects listed below.

--> Eg: Group: person A, below all projects the person is working on

INSTEAD OF (what I always get but don't need): Person A, Person B & Person C, below the project that all of them are working on in this combination (and so on)

If that is not possible, I am open for other ideas how best to organize this.

My assumption was: person is unique, project is unique but the challenge is, that one person can work on different projects and vice versa. Do I need to set up a new table, each primary field is the combination of a person & a project? Hope that makes sense... if not, let me know 🙂 

Thank you in advance 🙂 

1 Reply 1

If you're only looking for display, you could try using the List view

Screenshot 2023-07-13 at 2.39.12 PM.png

Screenshot 2023-07-13 at 2.39.09 PM.png

If you want to add data to a specific project <> person pairing, then what you mentioned re: primary field is the combination of a person & a project would be the way to go