I am new to App Sheets and creating a business lead entering and viewing app. Can anyone please guide me how to full-fill below requirement.
User role and restrictions requirement
Assign different user roles (admin, manager, supervisor, user) and assign different permissions.
Admin: Access all features, Views and menu items, Create all types of users
Manager: Create supervisor and user accounts, Add own leads, View and edit all leads
Supervisor: Create only user accounts, Add own leads, View and edit own and supervisor assigned user leads
User: View, Add and Edit only own leads
Note: I have created two tables in google sheets for user details and lead details