FAQ
How can we help?
Full Site Search

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.

    Start Ragic for free

    Sign up with Google

    Terms of Service | Privacy Policy