viewing all channel fields in one frame(tabular form) with all refreshed values
4 views (last 30 days)
Show older comments
i need to present all the field value of all channels in tabular form in one frame and all the values should keep on updating with time. can we get this by coding or any other method.
0 Comments
Answers (2)
Christopher Stapels
on 16 Oct 2019
You can create a MATLAB visualization and use uitable.
myT = thingSpeakRead(1417,'outputformat','table','numminutes',200);
array1 = myT.CheerLightsHEXColor
array2 = myT.LastCheerLightsCommand;
uitable('Data',[array1 array2])
If you have a paid license, you can click the AutoUpdate check box in the visualization editing view, and the visualization will auto update. You can also force the visualization to update manually with a page refresh.
If you want to do this for multiple channels, you can do multiple reads. Then you can extract the arrays or you might want to build one big table before reading out the arrays.
myT1 = thingSpeakRead(1417,'outputformat','timetable','numminutes',200);
myT2 = thingSpeakRead(38629,'outputformat','timetable','numminutes',200);
myBigT = [myT1; myT2] % if the arrays have the same number of columns
%array1 = myT.column1label... and so on
Christopher Stapels
on 17 Oct 2019
Start with the Get started tutorial.That will help you get oriented with the basic functionality of ThingSpeak.
Then you can browse the rest of the documentation for help on each topic in the standard ThingSpeak workflow:
The specialized topic tells you how to use other MATLAB toolboxes, for which you would need a license.
And the detailes of the API intercade functions are here, you probably wont need these if you arent reading from a device.
Once you are in the MATLAB documentation, you can search for the name of any function to find the page that describes it specifically. For example this link for uitable.
0 Comments
Communities
More Answers in the ThingSpeak Community
See Also
Categories
Find more on Configure Accounts and Channels in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!