yes Dora. Isnt it terrible. Im still stuck on the same thing. I saw your solution. I tried it but then I saw it was for a Google Spreadsheet. So I couldnt use it. I tried but it didnt work.
So why didi you create a new topic for same thing ?
Ok, Lists of Lists. I get that. But how then to get rid of the brackets and other stuff even if its list of List stuff?
because I added more detail to my question and was able to better express the problem once I had a better understanding of the thing and the things I had tried and not tried.
So even though you have hard coded the items in the list should I simply substitute your lists for the result from the database?
Don’t see the global initial list(it will look like your query result obtained from database)… just try to do just like given in screen init. If it not work(even in two methods) just let me know
Can I substitute your lists with my SQLlite result?
Construct blocks like this first and let us know the output .
Move all those blocks into when SQLlite after query event block
In the place of global list just use only get response
why do I get the feeling there are some guys watching this thread, shaking their heads and wondering how long its going to take for me to wake up
Its almost as if this is not being seen AT ALL!
learn to work with lists and list of lists…
you might want ot use the list from csv table block to convert a csv table into a list of lists…
First confirm whether your output is a list item or not. Then you can decide.
If it is list, by using select list item list take the first item and analyse how many items are there and whether they are in perfect list item. Again if so try to take first item from the list.
In the if block, you must use condition but you have added the query. So convert it into a logic using logical block like is equal to , not equal to, etc etc
Pls ref here, how SQL blocks need to setup
Thank you. Much appreciated. I hope I find my answers amongst that lot.
Hey… all the app file are exactly the same. Name and tel no. I’ve done that. It’s the delete and refresh I’m struggling with…
That’s is for eg. I thought your output is that format but it is not.
That two list view is to show you the real and modified. See my post. There I added two list view with diff outputs.
Listview1. Actuall(i mean with bracket)
Listview2. Modified list(wthut bracket)