How to hide controls for specific users
To hide pages for specific users;
- Add =SpreadsheetWebUserInfo(”UserName”) named range to your workbook.
- Add an If function. We added =IFERROR(IF(C1=”joedoe@pagos.com”;TRUE;FALSE);TRUE) to hide a control for ”joedoe@pagos.com” user.
- Go to User Interface module.
- Click on a control to disable for the user.
- Check ‘Visible’ as ‘By Value Of’
- Then choose the named range.
- Finally, publish your application.