We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

Can I add a list in cell instead of just a number

Answered

If I get a json data like
{green,book,list:[{id:1,name:’abc’},{id:2,name:’efg’}]}
How can I put each name in list push in cell instead of just push a total or others.
 

3 answers

WebDataRocks Team WebDataRocks August 20, 2019

Hello,
Thank you for posting your question here.
WebDataRocks does not support array data type https://www.webdatarocks.com/doc/data-types-in-json/.
You will need to make the join operation and have something like this:

{{color:'green', item:'book',id:1,name:’abc’},{color:'green', item:'book', id:2,name:’efg’}}

Regards,
WebDataRocks Team

lianghaihsia August 21, 2019

How can I get every cell data,like pivottable ,the jquery plugin,Maybe I could use jquery method to operate dom .It will useful for me to add list.  
 
Like the image I need to show a checkboxgroup in cell.
 
Thanks.

WebDataRocks Team WebDataRocks August 27, 2019

Hello,
 
In case you need to get the data from a cell, please try using getCell() API call. It returns the CellDataObject: https://www.webdatarocks.com/doc/cell-data-object/.
If you need to edit cell content please try our customizeCell approach: https://www.webdatarocks.com/doc/customizecell/.
 
Regards,
WebDataRocks Team