https://smadt.net/linksite/asesmen2.html
https://docs.google.com/spreadsheets/d/1TxU1WjvI-HJlhEaw6fbtOXr0f5sMvrMvxn2-bf_gqXs/edit?gid=0#gid=0
Google Apps Script
function doPost(e) {
const ss = SpreadsheetApp.openById('1TxU1WjvI-HJlhEaw6fbtOXr0f5sMvrMvxn2-bf_gqXs');
const sheet = ss.getSheetByName('Formulir');
const data = JSON.parse(e.postData.contents);
sheet.appendRow([
new Date(),
data.nama,
data.kelas,
data.minat,
data.hobi,
data.kerja,
data.masalah,
data.eq,
data.sq,
data.catatan
]);
return ContentService.createTextOutput(JSON.stringify({status: 'success'}))
.setMimeType(ContentService.MimeType.JSON);
}
Asesmen2.html
<!DOCTYPE html>
<html lang="id">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Formulir ESQ Talent DNA</title>
<style>
body { font-family: Arial, sans-serif; max-width: 700px; margin: 40px auto; }
h2 { text-align: center; color: #2d4a9d; }
label { display: block; margin-top: 15px; font-weight: bold; }
input, select, textarea { width: 100%; padding: 10px; margin-top: 5px; border-radius: 5px; border: 1px solid #ccc; }
button { margin-top: 20px; padding: 12px 20px; background: #2d4a9d; color: white; border: none; border-radius: 5px; cursor: pointer; }
button:hover { background: #1f3372; }
</style>
</head>
<body>
<h2>Formulir ESQ Talent DNA</h2>
<form id="esqForm">
<label>Nama Lengkap</label>
<input type="text" name="nama" required>
<label>Kelas</label>
<input type="text" name="kelas" required>
<label>Minat Utama</label>
<input type="text" name="minat" required>
<label>Hobi atau Aktivitas Favorit</label>
<input type="text" name="hobi" required>
<label>Apakah kamu lebih suka bekerja dalam tim atau mandiri?</label>
<select name="kerja">
<option value="Tim">Dalam Tim</option>
<option value="Mandiri">Mandiri</option>
</select>
<label>Bagaimana cara kamu memecahkan masalah?</label>
<select name="masalah">
<option value="Logika dan Analisis">Logika dan Analisis</option>
<option value="Kreativitas dan Inovasi">Kreativitas dan Inovasi</option>
<option value="Empati dan Komunikasi">Empati dan Komunikasi</option>
</select>
<label>Skor EQ (1–10)</label>
<input type="number" name="eq" min="1" max="10" required>
<label>Skor SQ (1–10)</label>
<input type="number" name="sq" min="1" max="10" required>
<label>Catatan Tambahan</label>
<textarea name="catatan"></textarea>
<button type="submit">Kirim</button>
</form>
<script>
document.getElementById('esqForm').addEventListener('submit', e => {
e.preventDefault();
const formData = new FormData(e.target);
const data = Object.fromEntries(formData.entries());
fetch('https://script.google.com/macros/s/AKfycbwkb0bdpHwIa3CnPUDZuzDHfTbBBydkfdTU8xPG8ShoBL5SsuQY9weGU9lavxzzDpUmbA/exec', {
method: 'POST',
body: JSON.stringify(data)
})
.then(res => res.json())
.then(response => {
alert('Data berhasil dikirim! Terima kasih.');
e.target.reset();
})
.catch(err => alert('Terjadi kesalahan: ' + err));
});
</script>
</body>
</html>
Tidak ada komentar:
Posting Komentar