Project Management using multiple tables

366 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I'm creating a project management platform and need some help in terms of organising tables.

I have three different tables:

Users - containing private information

Project - containing projects we have

Project participants - containing a row for project name, user id, and custom fields (columns 1,2,3) which contains information about that user for the project only. For example project user id or if they are participating in the project currently.

I'm having some hard time as we use Softr for this development, and I would like to be able to allow a manager to add or remove participants to a project via the project participants table. That is at least the workflow I have now, but might be that it needs a full redesign. 

Anyone who can help on suggestions and best practises?

0 Replies 0