Learn how to create your own applications for free without programming using AppSheet, an application development tool that doesn't require coding knowledge.
Create a Gmail account to easily create a system, and in this class, we will develop an online database using Google spreadsheets for controlling product quantity, expiration dates, photos, names, and descriptions, which can be used for small businesses or as a learning tool for making applications with Webchat.
Register and update product availability in real time, with a record for future reference, while managing shelf items and preventing spoilage and loss.
Deleting unnecessary columns and rows in the spreadsheet simplifies organization and future database changes, while registering products with photos, descriptions, and IDs on a separate page eliminates repetitive registration on the main worksheet.
Avoid using special characters or accents and leave no spaces to make it easier to read the database in AppSheet; create columns, delete unnecessary ones, arrange headers, and access AppSheet.com to create a system in a simple way.
To access the AppSheet platform, click on "Get Store" if it's your first time or "Sign In" if you've already logged in, then select Google and grant necessary permissions, and finally create a new application.
To create an application in AppSheet, click Create, choose a name and category, and select your data; you can create a worksheet using a specific email and start developing in the next class.
Click the button to add tables, select Google sheet, and configure views, buttons, sharing, and mobile download in AppSheet.
This article is a summary of a YouTube video "Curso AppSheet Basics - Aula 1 | Banco de dados" by SkillKey