Its Possible Google Form Script Open and Closed Everyday automatic at 00:01 AM to 12:00 PM

Question

i want to Open google form every day at 00:01 and closed at 12:00

this is my Code

   function createDailyTrigger() {
  ScriptApp.newTrigger("openCloseFormTrigger")
  .timeBased()
  .everyDays(1)
  .atHour(18)
  .create();
}

function openCloseFormTrigger() {
  const now = new Date();
  const FORM_OPEN_DATE = new Date(now.getFullYear(), now.getMonth(), now.getDate() + 1, 0, 1);
  const FORM_CLOSE_DATE = new Date(now.getFullYear(), now.getMonth(), now.getDate() + 1, 12);

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


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

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

Here My Execution Tab

if i save and run now, variable Vday is work fine but at 00:01 i must save and run again. if i don't save and run at 00:01 , i cannot open google form ( according to the script I made, it can only be opened from 00:01 to 12:00 )
can this script run automatically ? without save and run at 00:01 ?

Answer 1

You have two options, depending on the precision of the time in which you want the form to get opened and closed.

Running exactly at 00:01 and 12:00:

If you need this to happen at the exact minute (00:01 and 12:00), create a daily trigger (fire createDailyTrigger in the sample below, or alternatively follow these steps) that fires a function every day (openCloseFormTrigger) which every day will create two other triggers for the next day, at 00:01 and 12:00, as desired:

function createDailyTrigger() {
  ScriptApp.newTrigger("openCloseFormTrigger")
  .timeBased()
  .everyDays(1)
  .atHour(18)
  .create();
}

function openCloseFormTrigger() {
  const now = new Date();
  const FORM_OPEN_DATE = new Date(now.getFullYear(), now.getMonth(), now.getDate() + 1, 0, 1);
  const FORM_CLOSE_DATE = new Date(now.getFullYear(), now.getMonth(), now.getDate() + 1, 12);
  ScriptApp.newTrigger("openForm")
  .timeBased()
  .at(FORM_OPEN_DATE)
  .create();  
  ScriptApp.newTrigger("closeForm")
  .timeBased()
  .at(FORM_CLOSE_DATE)
  .create();
}

Not so precise:

If you can cope with +-15 minutes imprecision, you could create two periodic triggers to open and close the form every day:

function createPeriodicTriggers() {
  ScriptApp.newTrigger("openForm")
  .timeBased()
  .atHour(0)
  .nearMinute(1)
  .everyDays(1)
  .create();
  ScriptApp.newTrigger("closeForm")
  .timeBased()
  .atHour(12)
  .nearMinute(0)
  .everyDays(1)
  .create();
}

Reference:

• Date() constructor
• atHour(hour)
• everyDays(n)
• nearMinute(minute)

Answer 2

Yes, it's possible.

One way to achieve this

• Create a time-driven trigger to run every day to run between 10:00 pm and 11:00 pm to create a time driven trigger to run at 12:00 am for the next day.
• Create a time-driven trigger to run every day to run between 10:00 am and 11:00 am to create a time driven trigger to run at 12:00 pm.

The above is necessary because time-driven triggers set to run every day at certain hour, could be executed at any minute of that hour, i.e. if the trigger is set to run at 8 am it might run between 8:00 am and 9:00 am.

For more details see this answer to Is it possible to run a function everyday with time-driven trigger without having an active spreadsheet?.

Related

• Google script trigger weekdays only

Answer 3

If you want your form to open on the exact second then you will need to trigger a helper function early. The helper function then sleeps until the time when you want your form to open.

When you set a function to run at a certain time it runs at plus or minus a minute from the minute that you set it to run at. e.g. Set the function to trigger at 12:15 and it will run anywhere from 12:14 to 12:16. I have observed this through experimentation.

If you want your form to open at exactly 12:15 then trigger a helper function at 12:13 (to be safe). In the helper function, calculate how much time remains until 12:15 and sleep for that long, and then open your form.

Example typescript code:

function createTimeTrigger() {
    let triggerTime: Date = new Date(2023, 4, 28, 12, 13)
    ScriptApp.newTrigger("myOpenFormFunction")
        .timeBased()
        .at(triggerTime)
        .create();
}

function myOpenFormFunction() {
    let openFormTime: Date = new Date(2023, 4, 28, 12, 15)
    let now: Date = new Date()
    let difference: number = openFormTime.valueOf() - now.valueOf()
    // Difference will be negative if the trigger is created for a time in the past. 
    if (difference > 0) {
        Utilities.sleep(difference)
    }
    let form: GoogleAppsScript.Forms.Form = FormApp.getActiveForm()
    form.setAcceptingResponses(true)
}

In this example the open form time is hard-coded in the helper function. You could 'pass' the open form time to the function using this technique.

One more thing to note is that triggers once created hang around (even after they have triggered) until they are deleted. Once the number of triggers reaches 20 you won't be able to create anymore. So you should tidy up your triggers periodically.