Skip to main content
1-Visitor
November 15, 2018
Question

Validating Grid Value

  • November 15, 2018
  • 1 reply
  • 1992 views

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:

1 reply

20-Turquoise
November 15, 2018

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

MS71-VisitorAuthor
1-Visitor
November 16, 2018
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.
20-Turquoise
December 6, 2018

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