Advanced Stuff 0:56 video
How to hide controls for a specific group of users
Learn how to hide controls for a specific group of users with SpreadsheetWeb. Follow focused steps, practical examples, and implementation guidance to…
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.