Empty row, remove validation

Tags: #<Tag:0x00007f51c4a6e308>
#1

Hi,
Empty cell validation only applicable for row has a value.Here empty row has been checked,but i can’t able to change row background color to white (mention in the code).
Please help me how to change red color to white color for entire row, this scenario only applicable for empty row. It’s possible to do that?any way to remove highlight red color.

Jsfidle : https://jsfiddle.net/Sissoo/7207fa0b/

In this scenario, the user has type some text in all columns A1,A2,A3 and remove the text from A2,A3 columns at row 2, If i remove the last text from cell A1 then row should be changed to white color due to empty row.

#2

Hi @NagaB

If you are only looking to allow to add an empty value you can return any numeric value when user leaves the cell blank, here’s how I do it https://jsfiddle.net/pk7Lg7yw/ (I am using beforeValidate hook)

#3

Thank for your reply - aleksandra

It should highlight empty value - means user have to provide all column values, For your reference see the below image.

https://jsfiddle.net/pk7Lg7yw/ - In this jsfiddle not showing red color for blank values

#4

Hi @NagaB

If I understand correctly you may use isEmptyRow to block validation for a whole blank row like in this demo http://jsfiddle.net/jpw0rLj5/

#5