Notes on Creating a CRUD Web Application with Google Sheets

Introduction

• Objective: Build a complete CRUD web application on Google Sheets without coding.
• Features include:
  • File uploads
  • Dynamic dropdowns
  • Dependent fields
  • Computed fields (minor coding needed)

Overview of CRUD Operations

• Access multiple app sections for Create, Read, Update, and Delete operations targeting different sheets.
• Creating a New Record:
  • Click "Add New Item" button.
  • Fill out the form and click "Save".
• Editing a Record:
  • Click the pencil icon to open a pre-populated form.
  • Make changes and click "Save".
• Deleting a Record:
  • Click the trash icon and confirm deletion.
• Sorting and Filtering Records:
  • Sort by any field (e.g., deadline date, priority).
  • Search and filter records (e.g., by project name or status).

File Uploads and Dynamic Features

• File Uploads:
  • Upload images/files during record creation.
  • Automatically creates a folder for uploaded files.
• Dynamic Dropdowns and Computed Fields:
  • Select a product to automatically update rate fields.
  • Quantity entry calculates total amount.

Configuration of the Application

• Schema Setup:
  • Necessary to have an ID column for CRUD operations.
  • Schema defines how the table and forms are displayed.
  • Types of Fields:
    • Text, Date, Time, Number, Currency, etc.
    • Options for input fields (e.g., dropdowns) can be pulled from other sheets.
  • Use the join function for options from different sheets.

App Settings

• Location of app settings: App Setting Tab
• Modify app name, currency, and data entry/sheet configurations.
• Important to refresh the sheet list to include new sheets.
• Key names reserved for specific formatting styles (e.g., stars for ratings).
• Save settings after adjustments to ensure they take effect.

Customization Process

• Copy the Spreadsheet:
  • Access via the purchase link provided.
• Deploying the App:
  • Go to Extensions > App Script > Deploy > New Deployment.
  • Set deployment type as Web App, fill in details, and authorize.
• Modify Code for Custom Fields:
  • Access specific functions in the script to customize dependent and computed fields.

Conclusion

• Contact for customized versions of the application.
• Encouragement to like and subscribe for more content.