✦ One-time Setup — Read First
- Go to
sheets.google.com and create a new Google Sheet. Name it FLOCK Assignments.
- In the sheet, go to Extensions → Apps Script. Delete any existing code and paste in the Apps Script code from
flock-apps-script.gs (the second file you received).
- Click Deploy → New deployment. Set type to Web app. Set "Who has access" to Anyone. Click Deploy and copy the Web App URL.
- In both this file and your quarter pages, find the line:
var SHEET_URL = 'https://script.google.com/macros/s/AKfycbxLRhwGzLsSTSFSRJ3mZ3XajHQjacS3j8WtGEgfvrT023SWNU8ttau5v2LXjQ0A7-dc/exec';
Replace the placeholder with your Web App URL.
- That's it. The form submits to the sheet, the display reads from it automatically.