Friday, June 5, 2020

SCRIPT (OTOMATIS) pada GOOGLE FORM

function myFunction() {
  var FORM_OPEN_DATE   =  new Date(2020, 6-1, 5, 20, 00);
  var FORM_CLOSE_DATE  =  new Date(2020, 6-1, 5, 20, 30);
    var now = new Date();

  deleteTriggers(); 
  
  if ((now.valueOf() < FORM_OPEN_DATE.valueOf())) {
    closeForm();

    ScriptApp.newTrigger("openForm")
    .timeBased()
    .at(FORM_OPEN_DATE)
    .create();

    ScriptApp.newTrigger("closeForm")
    .timeBased()
    .at(FORM_CLOSE_DATE)
    .create();
  }
   
  else if ((now.valueOf() >= FORM_OPEN_DATE.valueOf())
&& (now.valueOf() < FORM_CLOSE_DATE.valueOf())){
    openForm();

    ScriptApp.newTrigger("closeForm")
    .timeBased()
    .at(FORM_CLOSE_DATE)
    .create();
  }

  else {
    closeForm();

    ScriptApp.newTrigger("closeForm")
    .timeBased()
    .at(FORM_CLOSE_DATE)
    .create();
  }
 
}



function deleteTriggers() { 
  var triggers = ScriptApp.getProjectTriggers(); 
  for (var i in triggers) {
    ScriptApp.deleteTrigger(triggers[i]);
  }
}

function openForm() {
  var form = FormApp.getActiveForm();
  form.setAcceptingResponses(true);
}

function closeForm() { 
  var form = FormApp.getActiveForm();
  form.setAcceptingResponses(false);
  deleteTriggers();
}



Ket : Anda hapus sampai bersih di script editor, kemudian pastekan script diatas. Rubah pada   var FORM_OPEN_DATE dan var FORM_CLOSE_DATE  (TTTT, B-1,t, JJ, MM) 

Misal : (2020, 6-1, 5, 20, 30)

Artinya 
 TTTT : Tahun (2020) 
 B : Bulan (6 / juni)
 t : 5 tanggal 
JJ : Jam (20 / 8 malam) 
MM : Menit (30 / 30 menit)

Untuk lebih jelasnya... Silahkan tonton videonya DISINI

Thursday, April 16, 2020

SUSULAN TUGAS BELAJAR DI RUMAH

 
    Sebelum Anda mengerjakan susulan Tugas Belajar di Rumah (CORONA 1&2) harap japri saya terlebih dahulu, karena butuh Password .......


1. CORONA tugas 1
2. CORONA tugas 2
3. CORONA tugas 3 (NAMA / KELAS)
4. CORONA tugas 4 (NAMA / KELAS) 



Hasil CORONA 1&2

Hasil CORONA 3    dan  CORONA 4