Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Base design
707 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Helenelene
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)

QUESTION:

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