Untitled

function doGet() {
  const html = `
    <!DOCTYPE html>
    <html>
    <head>
        <title>Survey: Kumpiyansa sa Pre-Calculus</title>
        <style>
            body {
                font-family: Arial, sans-serif;
                margin: 20px;
            }
            label, p {
                font-weight: bold;
            }
            input, select, textarea, button {
                width: 100%;
                margin-top: 10px;
                margin-bottom: 20px;
                padding: 10px;
                font-size: 14px;
            }
            button {
                background-color: #4CAF50;
                color: white;
                border: none;
                cursor: pointer;
            }
            button:hover {
                background-color: #45a049;
            }
        </style>
    </head>
    <body>
        <h1>Survey: Kumpiyansa sa Pre-Calculus</h1>
        <form id="surveyForm">
            <label for="pangalan">Pangalan (Opsyonal):</label>
            <input type="text" id="pangalan" name="pangalan">

            <label for="edad">Edad:</label>
            <input type="number" id="edad" name="edad">

            <label for="kasarian">Kasarian:</label>
            <select id="kasarian" name="kasarian">
                <option value="Lalaki">Lalaki</option>
                <option value="Babae">Babae</option>
                <option value="Non-Binary">Non-Binary</option>
                <option value="Mas pinipiling hindi sumagot">Mas Pinipiling Hindi Sumagot</option>
                <option value="Iba pa">Iba pa</option>
            </select>

            <p>1. Kumpiyansa akong makasagot ng mga tanong sa Pre-Calculus sa klase:</p>
            <input type="radio" name="tanong1" value="1"> 1
            <input type="radio" name="tanong1" value="2"> 2
            <input type="radio" name="tanong1" value="3"> 3
            <input type="radio" name="tanong1" value="4"> 4
            <input type="radio" name="tanong1" value="5"> 5

            <label for="bukas1">Ano ang nararamdaman mo tuwing nakakakuha ka ng tamang sagot sa Pre-Calculus?</label>
            <textarea id="bukas1" name="bukas1" rows="4"></textarea>

            <button type="button" onclick="submitSurvey()">I-submit ang Sagot</button>
        </form>
        <script>
            function submitSurvey() {
                const formData = {
                    pangalan: document.getElementById('pangalan').value || 'N/A',
                    edad: document.getElementById('edad').value || 'N/A',
                    kasarian: document.getElementById('kasarian').value || 'N/A',
                    tanong1: document.querySelector('input[name="tanong1"]:checked')?.value || 'N/A',
                    bukas1: document.getElementById('bukas1').value || 'N/A'
                };

                google.script.run.withSuccessHandler(() => {
                    alert('Salamat sa pagsagot! Naipasa na ang iyong sagot.');
                    document.getElementById('surveyForm').reset();
                }).submitToSheet(formData);
            }
        </script>
    </body>
    </html>
  `;
  return HtmlService.createHtmlOutput(html)
    .setTitle('Survey: Kumpiyansa sa Pre-Calculus');
}

function submitToSheet(formData) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Responses');
  sheet.appendRow([
    formData.pangalan,
    formData.edad,
    formData.kasarian,
    formData.tanong1,
    formData.bukas1
  ]);
}
Editor is loading...