How to Prevent Admin Users from Creating Records in a Specific Sheet?

If you want to prevent users with Admin Access Right from creating records in a specific sheet, you can follow the steps below:

Step 1: Open the Javascript Workflow Editor

Right-click on any sheet name and select Javascript Workflow.

Step 2: Switch to Pre-workflow

Step 3: Copy and Paste the Following Code

if(param.isCreateNew() && !user.isInGroup('SYSAdmin')){
response.setStatus('INVALID');
response.setMessage('None-SYSAdmin users are not allowed to create entries');
}

In the code above, 'Non-SYSAdmin users are not allowed to create entries' is the error message that Admin users will see when they try to create a new record. You can customize this message as needed. Once done, remember to Save before exiting the JavaScript Workflow Editor.

In the future, when Admin users try to create a new record, they will see this error message.

Note: For Survey Users or Bulletin Users, you can directly adjust their "Create Record" Access Rights in the Additional Access Rights Settings.