Mashup design question: dynamic Products & Machines table

[MA8731174]

Hi Community,

I want to design a mashup where Products are shown as columns and Machines as rows. Inside the cells, admins can add or remove “Errors.”

Example mockup:

Both Products and Machines are dynamic (number of columns and rows can change).

Question: What’s the best way in ThingWorx to implement such a dynamic mashup layout?
Which widget should i use for this approach?

Additional info: My datashape contains infotable type productStations (machine) field in which we can add more then one machine to one prod and in this infotable we have then another infotable error to save more then one error in it.

Datashape results

1)

2)

3)

Thanks for any design suggestions!

[Rocko]

Do you want to solve this on the unsupported 9.3 version or are you looking at a more current version?

Because the newer versions quite improved in their capabilities and you might choose a different solution on those.

[MA8731174]

Unfortunately i have to make this solution on unsupported version 9.3 but by the end of this year we would get a new version of thingworx and for now we need this solution on 9.3

What would you recommend i mean in which widget should i implement this solution.

[Rocko · Accepted solution]

I can't tell what already available on 9.3 and what's working but the two main approaches to evaluate are

1) a grid where you bind the configuration JSON and you dynamically create this with a service

2) a collection if you can influence when it makes a new line, i.e. how many components go into one row.

A third theoretical option would be to directly render an HTML table but it would be difficult to have it support the user interaction in the cell that you seek.

I would also evaluate this on a ThingWorx 10 to see if that solution still flies there.

[MA8731174]

We have decided to change the table structure and make it flat with both parameters to identify the row which belongs to a specific product and machine. In Thingworx 9.3 its not quite possible to have a table with such structure. After may be updating our thingworx version we would have more choices to have such a structure but for now its fine for us to make a table with simple structure.