How to hide controls for a specific group of users
To hide controls for a specific group of users;
- Add =SpreadsheetWebUserInfo(”Group”) named range to your workbook.
- Add an If function. We added =IFERROR(IF(StatusName=”Sales”;TRUE;FALSE);TRUE) to disable a control for ”Sales” group.
- Go to User Interface module.
- Click on your control.
- Choose ‘Visible’ as ‘By Value Of’
- Then choose the named range.
- Finally, publish your application.