Advanced Stuff 0:58 video
How to disable controls for specific users
Learn how to disable controls for specific users with SpreadsheetWeb. Follow focused steps, practical examples, and implementation guidance to complete the…
To disable controls for specific users;
- Add =SpreadsheetWebUserInfo('Username") named range to your workbook.
- Than add an IF condition, we added as =IFERROR(IF(C1="joedoe@pagos.com";TRUE;FALSE);TRUE to disable a specific control to the user 'joedoe@pagos.com)
- Go to User Interface module.
- Choose your control,
- Select 'By Value Of' for enabled.
- Choose the named range.
- Finally, publish your application.