Hello everyone in the MIT App Inventor community: I'm a beginner in App Inventor. I need to create a "library management app," but I'm still unfamiliar with certain logic and database integration, and I've been stuck for a long time. I'm wondering if any experienced members in the community have worked on similar library management, barcode scanning, or borrowing/returning systems projects and would be willing to share their .aia source files so I can import them into my account for learning, reference, and modification?
【I hope to study the core functionalities】
Barcode Scanning: Using the phone's camera (BarcodeScanner) function, scan the "book number barcode" on the inner pages or back cover of books, and manually enter the book title, author, and category through the interface.
Book List and Search: Create a list (ListView) on the app interface and quickly search the library's collection using keywords.
Borrowing/Returning Status Recording: Mark books as "in the library" or "checked out" by clicking or changing their status, and record the borrower's name and the borrowing date.
Data storage (Google Sheets, and it must be secure): This is the part that's getting me most stuck. Because I want my data to not be lost when my phone is restarted, I want to sync it with Google Sheets. However, I want to ensure the security of the connection (e.g., not directly exposing the URL of App Scripts that I have editing permissions, or having better secure encrypted read/write methods).
If any experienced developers are willing to share the open-source code or provide relevant tutorial links, I would be extremely grateful! Thank you all for your help!
In the FAQ you could have found the following link to the documentation of the spreadsheet component
There you could have found another link to the setup.
Spreadsheet is a non-visible component for storing and receiving data from a Google Sheets document using the Google Sheets API.
In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API.
Instructions on how to create the Service Account, as well as where to find other relevant information for using the Google Sheets Component, can be found here.
If this is too complicated for you, there are also other methods... see the FAQ