No data found, clearly not so

yes, the data is structured to make reading easier

This will work, as long as you do not have any commas in an item (e.g. , "Wed,23,Aug",)

Alternative to follow....


(draggable and recursive)

1 Like

So many choices, like a kid in a sweet shop!!
The takeaway here is that one cannot programmatically write a list to a single cell in a spreadsheet, but a single datum only.
Thanks for all the input fellers. I have a lot to ponder through and experiment with.

Yes you can, just don't send it in the way we have been doing so far.

so, I can write an array to a cell, just not an embedded array? an array within an array?

Google Sheets would treat it as a string (stringified JSON array) so if you wanted to use it as a list / array you would need to parse it back into a list/JSON array.

It's like making a necktie from rope.
You can, but should you?

like a hangman... :dizzy_face:

In retrospect, Tim, after these enlightening details, I do NOT want to write an array to a cell. When it comes time to pull the data, it is far easier to manipulation as a flat list, as opposed to unflattening and sorting through the details.
After all, the compilation of the lists at inception, is just to collate final end-user data.

I need some assistance with the JsonTxtDecode segment, Tim. Why is it there, to what advantage, and what exactly is it doing?

In my examples, the data initially comes through as a string (a stringified JSON array, to give it its correct term). The JSONTextDecode block parses the string into a JSON array / AI2 list, making it possible to work with it, as a list, in AppInventor.

JSON is like CSV on steroids, good for expressing complicated data structures in text.

This is json:

This is a JSON array:

Jason is a busy boy... is a rabbit hole, eh? I shall spend some time there to gleen a better understanding of Jason. (didn't he wear a mask, and carry a machete, or am I getting confused...?!?)

So after all that reading, experimenting, rewriting, recoding, head scratching, nail biting, it is just that the sheet is empty. I trapped the error 'No data found' and slipped in a WriteColumn (not AddColumn) to just write it in the first column... and it works, not with a list embedded in a list, but it worked. No data manipulation beyond flattening, no textizing and reversing no mumbo jumbo.
I just need to have a header column, and make sure it does not get erased....

You need to get back on topic Charley....

Topic being that whilst writing a column to a sheet I would get No Data found error.... I was just trying to say that I figured out that Adding and Writing a column differ, and that I had to have an existing column to be able to Add another. Despite there being bugs in the works still, and a further, deeper understanding of JSON required, I'll try to figure it out.
Thanks anyway

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.