please check this block arrangement for list view, i need google spreadsheet data into list view
First you need to add items in global title and global links, the problem here is that you’re selecting items in empty list.
Use when get column block to retrieve the data from your sheets number the add it into the global title and global links
Am not familiar with the aix you’re using
Hi! Since in GotColumn there’s no way to know which column you requested, you can do two things:
- Create a variable that keeps track of the requested column, and in
.GotColumncheck whether it’s column A and add the data totitle, or column B and add the data tolink, then join the elements of the two lists. - Or, more simply, request the entire sheet (I assume with
getAllRows) and work with that data.
Can you show us how your table is structured on Google? And check whether the GetAllRows method exists (if it does, also show us what you receive as a response).
Me too, so if you can kindly provide the link from where you downloaded it.
[PAID $4 INR 299] Google Spreadsheet Extension With Free Image Hosting (An Alternative To Airtable) - Extensions - MIT App Inventor Community this is extension used
Block to be used should be this though there’s no request type of column, maybe you should add it twice first get A second get B
I recommend
How should be block structure for getting list view
Set global title to=get data
You should use these blocks,
request the range, e.g. A1:B10, and you’ll get a list of lists as the result, which is perfect for your case.
And you can set ColinTree.List directly with what you receive.
Edit:
(If you’re not using
RefreshData, there’s no need to specify the action)
not working, app crashes
Hmm, it should at least show an error.
Does it say anything, or does the app just crash?
NO, just close that screen
Show your blocks from that screen
In apk or companion? Show us what you are getting on GotSpreadalSheetData
Without any error it just close that screen.
You forgot to reply
Make sure what you are getting in got column event. Using any lable or variable first understand what does it return then try collintree list
I check this in label get all text from column like (ABCDEFG) but actually this is in column
