We have made a data retrieval and upload sheet and 1 of the requirement for it is to not allowing the user to open the sheet with read permissions to PI Tags. I tried playing around with PI Identity but was unsuccessful.
As a workaround what we have done is created a Dummy PI Tag and mapped that tag to users which has only write permission and in the open event of the sheet we are pushing a value to a tag,so that when a user with read permission to this dummy tag opens this sheet he will be prompted with a message that "Not authorised to open this Sheet".
Can any 1 help me in making this generic like based on PIIdentity we should restrict te user to open up the sheet.
Thanks in Advance,