Needing help to create a data table [Solved]

[JokingFace_Minecraft]

i wanna build a quiz app but i dont want to create lists of questions and answers and add them into the lists by my hand, it just took too long. So i want to build a data table so that i can just copy and patse or insert an available QandA excel file, i think that would be more comfortable. But i have tried so many ways up to now but couldnt figure it out. Anyone can help me plsss???

[TIMAI2]

There is no “good” method for importing directly from Excel (there is a read only method in an extension somewhere), but you can export your excel file to a csv then use that in AI2.

Alternatively, use Google Sheets

AI2 and Google Drive/Docs/Sheets

 

HOWTO: Query Any Google Sheet with a Web App.

UPDATED! HOWTO - Upload Any File to Google Drive !

HOWTO: Use AI2 to directly submit Google Form Data

HOWTO: Google Drive - Multiple Files Download (file by file)

HOWTO: Download Google sheet as CSV

HOWTO: Send Data to Google Sheet with Web App

HOWTO: Show Image from Google Drive

HOWTO: Upload Image to Google Drive using base64 and Google Apps Script Web App

HOWTO: Upload Image to Google Drive using base64 using Camera Image

HOWTO: Get Data from Private Google Sheet with A Google WebApp

HOWTO: Get the ID of Image after uploading using base64

HOWTO: Upload CSV or List to Google Sheet

HOWTO: AI2 - Google Sheets - Web App - Create/Read/Update/Delete

HOWTO: OCR Images and Camera Pictures with Google Docs

HOWTO: OCR pdf and image files using Google Docs OCR function

HOWTO: Upload "Any" File to Google Drive

HOWTO: Use google web app and google query to download filtered output as pdf from Google Sheet

HOWTO: Use Ai2 to Delete Images (or other files) on Google Drive

HOWTO: Take Photo, get GPS Location and Address, upload Image to Google Drive, and save Location data to spreadsheet 

HOWTO: Select a Single Row from a Spreadsheet, and howto EDIT that data

[JokingFace_Minecraft]

Greatly thanks, i’m checking right now.

[JokingFace_Minecraft]

AAAAAAAAA, i succeeded, tks tks tks tks tks tks tks alot, tks tks tks+n…

[codo]

Use a web component (listed under Palette: Connectivity) to add a publicly viewable Google Sheets link & query the Google Sheets url.

Blocks Example: https://imgur.com/bcy3mqh

The order of items in the url can change the outcome… just play with it until the desired result is achieved. Learn more about the url query language: https://developers.google.com/chart/interactive/docs/querylanguage

[Taifun]

@codo Please edit your answer and add screenshots directly into your post rather than linking to an external site. Thank you.

Taifun

[codo]

No need to export the Google sheets into csv manually. Google Sheets can be used as a live database, so that even after publishing an app, to add or edit information won’t require updating the entire app manually to add a csv file.

Basically, use the web component & join text blocks to form links that query google sheets either for the whole sheet or for the specific row. So far it seems to run faster querying a single row at a time.

To learn more about querying a spreadsheet or specific rows/columns, search online, StackOverflow or YouTube keywords like: “How to Google Sheets URL Query Specific Row”. If the query link doesn’t seem to work after trying a few times, just change the order of parts starting with “&”, as it seems Google Sheets likes the links in a specific order.

[Taifun]

@codo

How to Google Sheets URL Query Specific Row

see also App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps

Taifun

---

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.