How To: Unique Number

[wvantongeren]

Hi,

 

I have 3 tables:

1 Projectorganisation (including personell by personnel number);

2 Personnel data table;

3 Selected personnel for a project.

 

The problem now is, i can not select (all reddy selected personnel in an other project) for a new project.

 

How to solve...

 

[svitlanataran]

Hi, I can recommend to to add checkboxes fields for each project.

Please find an example in the attachment. As you can see the same user can work on different projects.

 

Then you can create views and filter users, who work one one project, based on checked checkboxes. You can reed more at: http://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/

 

Also I can recommend you to watch the video:http://howto.caspio.com/getting-started/create-user-specific-redirect-after-login/

The topic of the video is different, but you can watch how to add checkboxes to the table and create a view to filter table.

 

Hope it helps.