Table Widget

General Setting

User can change following things in Table widget:

• Name for widget which will be used data referenceFor Example, if widget name is 'Table', then data of widget is referenced as Table.data

• Show title - User can show/hide widget title

• Title Color

• Background Color

Configure Table Widget

Widget Setting

In Widget Setting option, user can change following parameters:

• Filename - User can change name of Exported file. Default file type is .xlsx and default file name is 'thingsup.xlsx'.

Configure Table Widget

Source

User can select a source mode as MQTT or Action.

Using MQTT

Here, to change value of Text Widget user can publish JSON array on given testData MQTT topic. No need to provide <account_id> while providing the MQTT topic. The JSON array will be as below.

//Example 

[{ 
  "ID":1,
  "Name":"John"
},
{ 
  "ID":2,
  "Name": "Andrew"
},
{ 
  "ID":3,
  "Name":"Peter"
}]


// Here, ID and Name will be the Table Headers. And each Json object of the given
array is consided as unique row in table.

Configure Table Widget

Using Action

Here, to update the table widget, output of the action should contain JSON array as given format in above example. User can also update the widget either onLoad or periodically by providing refresh interval.

Configure Table Widget

Event Handling

Table widget does not support any event.

Example

If we configure Table widget with source type for widget as MQTT and topic configured is 'data'. And if we publish following JSON array over 'data' topic then Table Widget will look as shown in image.

[
  {
    "ID": "121",
    "Name": "John"
  },
  {
    "ID": "S122",
    "Name": "Andrew"
  },
  {
    "ID": "S123",
    "Name": "Peter"
  }
]

// Here, ID and Name will be the Table Headers. And each Json object of the given
array is consided as unique row in table.

Table Widget Example