What tables will I need if my task sounds like this?

11146
New Member

Hello! What tables will I need if my task sounds like this?

  1. Create the task manager application
  2. There are several leaders in the company
  3. Each leader has his subordinates
  4. The leader can set tasks only to his subordinates
  5. The leader and subordinates see only their tasks
Solved Solved
0 3 239
1 ACCEPTED SOLUTION

Youโ€™ll need to create a filter of some kind.

Thereโ€™s a lot of ways to go about this, all depending on how people will be using the app.

You could create slices or security filters to accomplish what you wish.

View solution in original post

3 REPLIES 3

For starters youโ€™d need:

  • Employees
  • Tasks

But then other supporting tables like:

  • Clients
  • Projects

And maybe some tables to connect things together:

  • Task Assignments
  • Task time-logs
  • Task notes

Those would be good starting points. Hereโ€™s some documentation to point you in the right direction:

Thanks, I read the docs. Now more clearly.

Tell me please. I have tasks and each task has a director and performer. How to make users see only those tasks in which they are the director or performer?

Youโ€™ll need to create a filter of some kind.

Thereโ€™s a lot of ways to go about this, all depending on how people will be using the app.

You could create slices or security filters to accomplish what you wish.

Top Labels in this Space