Need to Implement Section Access in the App . I have a stream with one app and there are around 20 users access to that Stream & App .
In the App i have 2 have managers Level Data ( Mgr1 & Mgr2 ) and their reportees . I need to create Section access With Manager Level Data hierarchy .
Ex - If Mgr2 logins , he shud see this Mgr1 data and their reportees and if Mgr1 logins he shud his reportees data Hierarchy Data . If others users login they shud see full data
Should i Maintain a sheet with all users who have access to App and thier ID and the Mgr1 & Mgr2 Names and their ID and do the authentication ? and what field shoud i give as it is Hierarchy data
Please help to write this script . Hierarchy Belongs to function using how to write this
