Field validation in list view

aahitha2 · ‎01-04-2022

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

Murthy Ch · ‎01-04-2022

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

Thanks,
Murthy

View solution in original post

Murthy Ch · ‎01-04-2022

If you want to achieve this via BR only

Then use below where no script required:

when before insert update BR

Thanks

Thanks,
Murthy

Ankur Bawiskar · ‎01-04-2022

Hi,

can you share your before update BR script and logic?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader