How to disable controls for specific users

You are here:

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.