How to hide controls for specific users

You are here:

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.
Tags: