FAQ
How can we help?
Full Site Search

How to prevent "Admin" users from creating entries in a specific sheet?

If you want to apply "No create" setting for "Admin" users on a specific sheet, you may follow the steps below:

Step 1. Open the JavaScript Workflow

Right-click on the sheet name and select "JavaScript Workflow"

Step 2. Switch to "Pre-workflow"

Step 3. Copy and paste the code

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

In above code, 'None-SYSAdmin users are not allowed to create entries' is the error message that users will see when trying to save new entries. You may customize the error message if necessary. Once completed, please save and then exit the JavaScript Workflow editor.

In the future, when "Admin" users try to save new entries, they'll see the error message you set.

Note: For "Survey User" or "Bulletin User" access rights, you may set this from the additional access rights settings.

Top of Page

    Start Ragic for free

    Sign up with Google