I have a CSV file containing my full product catalog with prices, available stock, and category information. I need that data converted into a Google Form that lets clients tick the products they want (using checkboxes) and enter a quantity for each item. Each product must sit under its proper category section so shoppers can browse easily. Key functional points • Quantity inputs must respect the stock level in the CSV; the form should stop users from entering a number higher than what’s available. A lightweight Apps Script that reads the stock column and surfaces a real-time warning is fine—whatever keeps the purchase flow smooth and accurate. • When someone submits the form, I want two things to happen automatically: 1. A neat email summarising the order hits my inbox (product, quantity, price, subtotal, total). 2. All answers land in an attached Google Sheet for tracking, where each column aligns with the CSV headers. • If possible, keep the Google Sheet live-linked so I can update stock there and have the form respect the new limits without manual intervention. Deliverables 1. Google Form with category sections, checkboxes, quantity fields, and live stock validation. 2. Connected Google Sheet pre-formatted for easy order tracking. 3. Apps Script (or alternative) that drives the quantity validation and email notification, fully commented so I can tweak it later. 4. Short walkthrough (video or doc) showing how to update stock or add new products from a fresh CSV. That’s the full scope—let me know your approach, estimated turnaround, and any questions that will help you hit the ground running.