I found that the Done button was not responding，When I tried smartgrid widget。

[lli-31]

Does anyone know what caused this?

I downloaded from the markerplace smartgrid widget extension, When I tried it, I found the problem, The "Cancel" button can works.

Thanks!!

[ttielebein]

What exactly are you trying to do here? Have you tried entering a value into that box and then hitting Done?

[sponomarenko-3]

Evidently, you have to create a valid JSON with columns array, which contain quoted names of keys and with only double-quotes everywhere.

Something like this: {    "columns": [       { "name": "User", "type": "text", "display": "User"},        { "name": "Gate", "type": "text", "display": "Object"},        { "name": "Permanent", "type": "text"}  ] }

BTW, if there is any sample of smartgrid usage could anybody share it please, cause there is no information about how to use it at all. How to load data from the infotable for example and so on.

[liliu]

For more infomation like types and usages please check appendGrid - Documentation

[sponomarenko-3]

Yes, I know about the original documentation for appendGrid but I can't get info about how to load data from binded to the Data field infotable.

appendGrid docs do not concern Thingworx specifics.

[liliu · Accepted solution]

For my example:

1. Create a DataShape named UserEmail

2. Create a DataTable named UserEmail and bounded with DataShape "UserEmail"

3. Create a Mashup and bind things as below

So far, availavle API for DataTable only AddOrUpdateDataTableEntities. If you need the delete function works, we many need customized a service and combin DeleteDataTableEntities service.

Hope this is what you want. And if I misunderstand you, please let me know.

Lily

[sponomarenko-3]

Thanks a lot, got it.

[ankigupta]

Sergey Ponomarenko​

Consider marking the Correct answer and helpful comments if the issue is resolved.