CRUD Application Using Google Sheets

Overview

• Create a complete CRUD web application on Google Sheets without coding.
• Customize multiple apps using app settings and schemas.
• Features include:
  • File upload
  • Dynamic dropdowns
  • Dependent fields
  • Computed fields (minor coding required)

Application Sections

• Multiple sections for performing CRUD operations targeting different sheets:
  • Search records
  • Create new records

Project Tab in Google Sheets

• Contains fields:
  • Project Name
  • Project Category
  • Deadline Date
  • Status
  • Approval
  • Priority
  • Assigned User
• CRUD application displays projects in a formatted table.

Creating Records

• Click on Add New Item button.
• Fill out the form and click Save to create a new record.
• Newly created record appears at the top of the table.

Editing Records

• Click the pencil icon to edit a record.
• Pre-populated form appears; make changes and hit Save.

Deleting Records

• Click the trash icon to delete a record.
• Confirm deletion to remove the record successfully.

Sorting, Searching, and Filtering

• Sort records by any field (e.g., Deadline Date, Priority).
• Search for specific projects (e.g., Project G).
• Filter to show only pending projects.

File Uploading and Dynamic Dropdowns

• Demonstrate file upload in sales form with product rates.
• Upload an image when creating a new product.
• Record is created and displayed appropriately.

Dependent Fields and Computed Fields

• Selecting a product updates the rate field.
• Quantity entry calculates the amount field.
• Dynamic dropdowns can pull options from other sheets (e.g., Products).

Configuration Process

1. ID Column
   • Necessary for CRUD operations; can be named anything.
2. Schema Overview
   • Dictates table display and form construction.
   • Copy and customize schema sheet.
   • Ensure headers in the key column match the record tab headers.
3. Field Types
   • Select from: Text, Date, Time, Number, etc.
   • Set fields as mandatory (required column).
   • Provide options for select fields or use other sheets for dropdowns.
4. Sorting and Alignment
   • Set sortable columns and text alignment (start, center, end).
5. Hide Columns
   • Hide certain columns or disable fields in forms as needed.

App Settings

• Do not change the app settings tab name; hardcoded in scripts.
• List different apps and set local & currency for formatting.
• Change data entry and schema sheets if needed.
• Refresh sheet lists to update dropdowns.

Formatting Styles

• Reserved key names for auto-formatting (e.g., rating as stars).
• Detailed instructions available in comments.

Customizing and Deploying the App

1. Copy the Spreadsheet
   • Purchase link available.
2. Deploying the App
   • Go to Extensions > App Script.
   • Deploy as a web app, configure permissions, and obtain the app URL.
3. Modifying Code for Customization
   • Edit functions for computed fields in the compute mixin file.
   • Contact for customized versions at an affordable price.

Conclusion

• Like and subscribe for more tutorials.
• Thank you for watching!