Advanced Stuff 0:49 video

How to hide controls for specific users

Learn how to hide controls for specific users with SpreadsheetWeb. Follow focused steps, practical examples, and implementation guidance to complete the…

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.