Task Management System with Role-Based Access and Email Notifications

I have two roles: ‘Leader’ and ‘Employee’. There are two tables named ‘Jobs’ and ‘My Team’. The ‘My Team’ table is connected with both ‘Leader’ and ‘Employee’ roles. The ‘Jobs’ table is also linked to the ‘My Team’ table. When a Leader logs in, they will have access to view all jobs. On the other hand, when an Employee logs in, they will only see the jobs assigned to them. Moreover, when a Leader creates a new job, an email notification will be sent to the selected person. How can I implement this scenario?

Hi there,
We are hosting a live Q&A for new Knack customers today at 3pm EST (in 5 mins). Feel free to register and join here: Knack: Webinars. I’ll be responding to a similar question live today.

You may also be interested in the following resources:

Show Records Connected to the Logged-in-User

Show Records Connected To The Logged-in User’s Company Or Other Group
Add Notifications & Email Reminders to Your App