How to add validation for textbox inside grid

[rk-31]

Header 1	Header 2	Header 3
25	30
25	30

My mashup will be like above.

When a user enter value in header3, I need to keep a validation that should not be greater than header2 and less than header1. If validation fails I need to higlight textbox with red color else green color.

I am new to Thingworx. Please help.

Thanks

Raju

[rk-31]

I accomplished this by using Validation Expression. ​When validation fails system is showing the textbox in Red color.

Can we show green color if validation is success.

[mazri]

Hi Raju,

Could you tell me how you managed to implement the validation expression into the editable grid, because in my usecase it always show me invalide input and the color of the textbox is always red. 

Thanks,

Azri,