Hi All, hope someone could help me with my problem.
I have triggers setup "OnActivateSheet" where I select in field values depending on a user (OSUser()) to filter data for that user, then lock that field so that users can't see other user's data.
The problem I have is when it is a "manager" that is supposed to see all data, that user can see everything because that user is not in the list of the trigger, but the values in that field can't be selected to filter.
I add a trigger (OnActivateSheet) , Select in Field, add the field , in the search string I add an IF statement that does the selection ( IF(match(OSUser(UserName),'User1',User1,
then I lock the field.
When User3 opens the sheet, all the data is available , but User3 can't select any values in the "UserName" field.
I tried adding the "unlock field" option with criteria (IF(match(OSUser(UserName),'User3',UserName) but no luck....
Any Ideas on where my issue might be.
Hi Miguel , will definitely have a look, never work with section access before. the tricky part on my side is the Username for each user isn't a 100% match to their username in the data. So I hard code the matching user to the name in the data
eg. Username = JohnK , name in data = JOHN
Username = John.JamesL , name in data = JJ
and so on....
the data name is stored in a mapping table which gets updates by the users to link them to their clients.
but will see if I can use section access to solve my issue
thank you very much for the input