I am trying to set list item permissions different for two group of users : Members and Manager. As shown in the scenario below, solution works for grou "Members", but not for group "Managers". Is suing workflow my only way out as stated here List permissions for different groups? Will workflow prevent Members from downloading to Excel ?
AddOnlyItem (Custom permission level)
-Advanced settings : Item-level permission set to Read items that were created by the user and Create items and edit items that were created by the user
-Group1 permission set to AddOnlyItem
-Group2 set to Contribute
-Can add new items to List1
-Should view or download only items of List1 created by same user
-Good : List1 behaves as expected considering above settings
-Should be able to view, edit or download any or all items of List1
-Bad : Actually Managers do not have access to any item since they were all created by others (the Members).
Your suggestions wil be greatly appreciated.