AppSheet Apps Script Forms

I want a clean, efficient AppSheet application that focuses on data collection and management through easy-to-use forms. Users should be able to open the app, fill out a form, submit it, and know instantly that their information has been stored safely in the connected Google Sheet. My priorities are: • Form creation and submission built in AppSheet, with friendly layouts and field-level validation. • Seamless connection to an existing Google Sheet (or a new one you set up) so I can review and filter entries at any time. • A lightweight Google Apps Script layer to perform any logic the native editor can’t handle—extra validation, automatic time-stamping, email or chat notifications, or small calculations as needed. The workflow must remain simple for non-technical staff: open the app, complete the form, press submit, done. Real-time sync is a plus if it comes automatically with AppSheet; no heavy analytics or dashboards are required right now. Deliverables 1. Fully functional AppSheet app shared to my account. 2. All supporting Apps Script code, clearly commented. 3. A short walkthrough (video or doc) showing me how to maintain the form, add fields, and redeploy. I’ll supply sample data and access to the workspace. Please bring solid AppSheet experience, an eye for clean UX, and enough Apps Script know-how to keep everything running smoothly.