onCellEdit Help!!

[SandeepKSingh]

How can you allow a user to update the incident state but restrict them from closing it in the list view? 

[Ravi Gaurav · Accepted solution]

Hi @SandeepKSingh 

Solution

You can create an OnCellEdit Client Script on state field that checks if the new state value is "Closed." If the user tries to close the incident by changing the state to "Closed," the script will block the update. If the new state is anything other than "Closed," the record update will proceed as normal.

function onCellEdit(tableName, record, columnName, oldValue, newValue, callback) {
    if (newValue === 'Closed') {
        // Prevent update if the state is being set to "Closed"
        callback(false);  // Pass 'false' to prevent update
    } else {
        // Allow update if the state is not being set to "Closed"
        callback(true);  // Pass 'true' to allow update
    }
}

[PritamG]

you can achieve this by using a UI Policy or Business Rule

UI Policy/Client Script :

in the list view, create a UI Policy/Client Script to disable the "State" field when the value is set to "Closed."

Business Rule:

write a Before Update Business Rule on the incident table to restrict users from setting the "State" to "Closed" unless they have specific roles.

[SriharshaYe · Accepted solution]

Hi @SandeepKSingh , 

write an on cell edit client script with the below code :

function onCellEdit(sysIDs, table, oldValues, newValue, callback) {

var saveAndClose = true;

if(newValue == 7){

alert('Not allowed');

saveAndClose = false;

} else {

saveAndClose = true;

}

callback(saveAndClose);

}

the above code helps you in restricting to update the incident state  from closing it in the list view .

If my solution is helpful , mark it as helpful .

0 Helpfuls

[SandeepKSingh]

Thanks @Ravi Gaurav  and @SriharshaYe  it worked 🙂

[vishwajeet5550]

onCellEdit client script use on the List view when we edit or change the field value using (g_list)

 if (control == 'state' && newValue == '7') { 
       
        g_form.addErrorMessage("You are not allowed to close incidents from the list view.");
        
        g_form.setValue('state', oldValue);
}

This approach only prevents users from closing incidents in the list view. If you also want to restrict closure in the form view, consider combining this with a UI Policy or Business Rule.