Field validation in list view

[aahitha2]

Hi Team,

There is an string field "X", I need to restrict the updation of negative values from table list view.

I have "ONSUBMIT" client script which is restricting from form level and same restriction is not applying for list view.

How can I achieve this?

Thanks,

Aahitha

[Anurag Tripathi]

Hi,

If you need to validate on list view too, just do it via a before Insert/update BR.

-Anurag

[aahitha2]

Hi Anurag,

I have tried using before Insert/update BR, but not working.

Thanks,

Aahita

[Anurag Tripathi]

Can you show the BR you have written?

[Murthy Ch · Accepted solution]

Hi @aahitha 

This may help you

Write OnCell edit client script on your  'X' field

function onCellEdit(sysIDs, table, oldValues, newValue, callback) {
    var saveAndClose = true;
    //Type appropriate comment here, and begin script below
    if (newValue <= 0) {
        alert('Not poosible');
        saveAndClose = false;
    }
    callback(saveAndClose);
}

Thanks

Murthy