Many to many relation for the same table

Hello all! 

I have a table users, each user can cover different position: 

  • team leader
  • coordinator
  • normal user

and a coordinator can be manager of 1 or N normal users
and a team leader can manager 1 or N coordinator

So, I have this users table wihtin the following columns: user type, team leaders and coordinators.

Inside appSheet I configured the columns as below: 

Annotation 2022-09-28 133520.png

But it doesn't work.. Inside the application I have only the label but not input field.. 
How can I do this? 

Thanks a lot!

Solved Solved
0 7 241
1 ACCEPTED SOLUTION

In the end, I've chosen to use a dedicated join table between Users and Users, hiding one of the 2 columns of type "List", automatically created and that's it..
Here the join table

DroidTeo_1-1664395289208.png

 

 

View solution in original post

7 REPLIES 7
Top Labels in this Space