dalank
(Haytham Dalank)
July 2, 2020, 9:08am
#1
Hello Koders,
in my previous project i was retrieving data from each column from an airtable spread sheet
i was trying this morning without success trying to do the same method but using google sheet hosted in drive any help please.?
the screenshoot show airtable version
1 Like
dalank
(Haytham Dalank)
July 2, 2020, 9:17pm
#3
Why you guys don’t give a direct help in this forum and transfer us to another forum community !?
Rogerio_Rios
(Professional Support)
July 2, 2020, 10:15pm
#4
Simple. Why the answer already exists, so we research and post.
2 Likes
dalank
(Haytham Dalank)
July 2, 2020, 10:22pm
#5
i saw all the tutorials there i didnt found the one i need actually ? can you answer my question in blocks ?
Taifun
July 2, 2020, 11:09pm
#6
you might want to try this solution App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps together with a query, for example
SELECT D
to get all rows of column D
Taifun
1 Like
Hi @dalank
Hi developers,
Am here to introduce Cloudsheets - A dedicated service to link your google spreadsheet with app.
The extension is free to use but need an API that can be generated from our website : https://www.cloudsheets.xyberneo.com
A special mention to @help_cttricks for being by my side in the whole development process and helping me with solutions
Advantages of using google spreadsheet as your app’s database over Airtable :
1 - Its completely free to use where Airtable on the other han…
Have a look at this post.
This extension can fulfil your requirement precisely and you can perform a lot more actions to google sheets from your app with this extension.
Thanks
Fabio
(FábioESantos)
July 17, 2020, 11:50pm
#8
Using this guide I could learn how to get information from Google Sheets.
I believe these could help …
How to write:
How to read:
i have data from google sheet, and i am using list from csv table but i wanna take only data in column that i wanna.
example
I have column ; No, Username, Password
I just wanna get data in Username column
annyone can help me how to solve that?
I wonder if that’s what you need.
1 Like
Am easier way is to use this extension
Hope it helps
Soham_Shah
(Soham Shah )
July 19, 2020, 3:11pm
#10
You can do it easily just need to export the Google sheet as csv and use select item list block
1 Like
dalank
(Haytham Dalank)
July 19, 2020, 6:04pm
#11
Hello, thanks but can you please clear more about this ?
Soham_Shah
(Soham Shah )
July 19, 2020, 6:29pm
#12
If you just want to read column from one sheet of your Google spreadsheet then just copy the link of your spreadsheet and change the ‘edit?usp=sharing’ to ‘export?format=csv’ this should be the web components URL
1 Like
Soham_Shah
(Soham Shah )
July 19, 2020, 6:32pm
#13
This way you will egt the data in csv format
1 Like
Soham_Shah
(Soham Shah )
July 19, 2020, 6:36pm
#14
Then you just need to select the coloum using this method
[blocks]
You have to use the select list item block as shown in the image above. In this example it’s getting data from line 3 column 2.
3 Likes