viewing all channel fields in one frame(tabular form) with all refreshed values

1 view (last 30 days)
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.

Answers (2)

Christopher Stapels
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
or see this MATLAB answer for more help on concatenation.
  1 Comment
berg barmy
berg barmy on 17 Oct 2019
Since i am new user on this portal, unable to get clear understanding. Please provide function details and parameters whch are being used for this outcome. Also it will be helpful, if you could provide any link to get details of functions(codes) , so that i can go through.

Sign in to comment.


Christopher Stapels
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.

Communities

More Answers in the  ThingSpeak Community

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!