How to hide controls for a specific group of users

You are here:

To hide controls for a specific group of users;

  • Add =SpreadsheetWebUserInfo(”Group”) named range to your workbook.
  • Add an If function. We added =IFERROR(IF(StatusName=”Sales”;TRUE;FALSE);TRUE) to disable a control for ”Sales” group.
  • Go to User Interface module.
  • Click on your control.
  • Choose ‘Visible’ as ‘By Value Of’
  • Then choose the named range.
  • Finally, publish your application.
Tags: