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
Last modified 1yr ago