Apps-Script-enabled-form-codes

Google Sheets Apps Script Project

This repository contains the code and links for two Google Sheets: Workbook A (form input) and Workbook B (database with web app). Workbook A collects data via a form and posts it to Workbook B using Apps Script. Workbook B has a deployed web app to handle incoming data.

Apps Script Code

• Form script for Workbook A: FormScript.gs
• Web app script for Workbook B: WebApp.gs

View the Sheets

• Workbook A (Form): View Link
• Workbook B (Database): View Link

Embed the Sheets

Workbook A (Form Input)

Workbook B (Database - Online Sales Data)

How It Works

• Workbook A: Contains a form where users input data. An Apps Script (e.g., FormScript.gs) posts this data to Workbook B.
• Workbook B: Acts as the database, storing data received from Workbook A. It includes a deployed web app (e.g., WebApp.gs) to handle incoming data.
• Data Example: Workbook B contains sales data with columns like Transaction ID, Date, Product Category, Product Name, Units Sold, Unit Price, Total Revenue, Region, and Payment Method.

To use:

1. Open the view links above to see the sheets.
2. Copy the Apps Script code to your own Google Sheets project.
3. Ensure sharing settings allow access (set to “Anyone with the link” as Viewer).
4. Deploy the web app in Workbook B as described in the script comments.

Note: Ensure no sensitive data is shared in the sheets. Use dummy data for public sharing.