Hi, I’m building an app for a list of projects and the members involve in each project. Which means, one member can involve in multiple projects, and one project will have multiple members working on it. I can’t think of a proper way how to set up the relation in glide. Any help? Much appreciated! …

@Jacktools_Net is correct @Donny_Lau . It should be something like this. Project | Email Project A | a@gmail.com Project A | b@gmail.com

I think what you need here is a helper sheet where you store all assignments of member to projects. Let’s say it will have a project ID and an email of the assignee. Then in the Users sheet, create a relation using the email to the assignments sheet, you will have the multiple projects each person …

You need a third table. In this you have the row id from the project as project id and the row id from the members as members id column. Than you can make related columns in project and menbers that relate to this third table with match multiple.

May I know how this helper table should be structured? Let says I have 2 projects and 5 members. For project A, I have 3 members involved; project B with 5 members. Should I put project ID in column A and members ID in Column B to D?

You only need A and B Than a new row for each relation.

Thanks @ThinhDinh and @Jacktools_Net ! This solve my problem. Happy New Year!

Multiple to multiple

Ask for Help

profechef December 31, 2020, 1:02pm 7

I’ve just posted a demo app in another thread which may suite your needs. It has only two tables
read it

Topic		Replies	Views
Assign multiple users to a project Ask for Help	6	63	November 14, 2024
Many to many relationships Ask for Help	10	2191	January 21, 2024
Is there a way to make a glide table from a row? Ask for Help	11	403	May 27, 2022
Many-to-Many Relationships Ask for Help	38	6228	November 30, 2023
How to make a "2 ways" relation between tables? Ask for Help	3	741	February 18, 2023

Multiple to multiple

Related topics