Validating Grid Value

[MS7]

I have a table where i need to validate strings. I am trying it with state definition but it is checking with the whole string and not considering the sub string. So, is there a way to validate string values using sub string in a grid.

Attaching an image of required output:

[posipova]

You'd have to write a custom service for validation and then use the expression widget.

[MS7]

Can you please elaborate a bit about what details shall be given in service and I am trying to provide expression under configure grid columns -> editable table but it is not validating it, where can I provide different colours to each cell?? Also I tried binding Expression widget to the grid widget but no proper option was available for binding.

[posipova]

To my understanding, you'd like to validate only part of the string, correct? And then based on the validation result, change the color of the cell?

You may read the bottom part of this document in the helpcenter about data driven state definitions:

http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx%2FHelp%2FComposer%2FVisualization%2FStyleandStateDefinitions.html