How to disable controls for specific users
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=”firstname.lastname@example.org”;TRUE;FALSE);TRUE to disable a specific control to the user ‘email@example.com)
- Go to User Interface module.
- Choose your control,
- Select ‘By Value Of’ for enabled.
- Choose the named range.
- Finally, publish your application.