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
    }
}

[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
    }
}

[SandeepKSingh]

Let me have a Try and I will get Back to you

[yuvarajkate]

Use this Script:

(function executeRule(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading || newValue === oldValue) return; // Skip if loading or no change

    if (control === 'state') { // Check if editing "state"
        if (newValue == '7') { // Restrict "Closed" state
            g_form.addErrorMessage('Cannot set state to Closed.');
            g_form.setValue('state', oldValue); // Revert value
            return false;
        }
    }
})(control, oldValue, newValue, isLoading, isTemplate);

[SandeepKSingh]

I guess you  have just copy pasted from chatGPT.. I asked for onCellEdit and you are giving onChange.. I am sorry buddy your code is of no Help.