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

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.

Answer 1

[Christopher Stapels]

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.

[berg barmy]

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.

Answer 2

[Christopher Stapels]

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:

Configure Accounts and Channels

Write Data to Channel

Read Data from Channel

Prepare and Analyze Data

Visualize Data

Act on Data

The specialized topic tells you how to use other MATLAB toolboxes, for which you would need a license.

Specialized Analysis with MATLAB

And the detailes of the API intercade functions are here, you probably wont need these if you arent reading from a device.

API Reference

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.