Блог

спасибо, что прочитали это. Вот в чем моя проблема. Я создаю строки в зависимости от дня недели в Google формах с помощью скрипта приложений. Проблема, с которой я сталкиваюсь, заключается в том, что каждый день, когда код генерирует новую сетку с несколькими вариантами, даже все имена одинаковы, ответы создают новые столбцы. Поэтому в моем листе ответов каждый день появляются новые столбцы. Я хочу, чтобы независимо от количества таблиц с несколькими вариантами ответов ответы всегда писались в одних и тех же столбцах. Так что в идеале только 5 столбцов для 5 рабочих дней.

Вот код:

   var form = FormApp.openById('1ia2ONGzXt3tHKU1WxvWOKexpVY_htFQNqL1vIUITPy4')
  var curr = new Date;
  console.log(String(curr))
  var currDay = String(new Date).substring(0,3);
  var currTime = parseInt(String(new Date).substring(16,18));
  if (currDay == "Sat" || (currDay == "Fri" amp;amp; currTime >= 19)){
    var firstday = String(new Date(curr.setDate(curr.getDate() - curr.getDay() 8)));
    var lastday = String(new Date(curr.setDate(curr.getDate() - curr.getDay() 5))); 
  }
  else{
    var firstday = String(new Date(curr.setDate(curr.getDate() - curr.getDay() 1)));
    var lastday = String(new Date(curr.setDate(curr.getDate() - curr.getDay() 5))); 
  }
  
  var description = "Fresh Gujarati Food... Just Like Home nnIlaxi's Kitchen serves fresh Gujarati daily tiffins. If you have additional questions please contact us at: (647) 505-2410. nnPlease note that tiffin orders must be submitted a day before you are ordering, we do not take same-day orders.nn The tiffin orders on this form are from "   firstday.substring(4,11)   "- "   lastday.substring(4,11);

  if (currDay == "Fri" amp;amp; currTime < 19 amp;amp; currTime > 7){
    description = description   "nn We are not accepting any more orders this week, please come back today at 8:00PM to order for next week"
  }
  
  var item = form.getItems()[2].asGridItem();
  if (currDay == "Mon"){
    if(currTime > 7){
      rows = ["Tuesday","Wednesday","Thursday","Friday"];
      
    }
    else{
      rows = ["Monday","Tuesday","Wednesday","Thursday","Friday"];
    }
  }
  else if(currDay == "Tue"){
    if (currTime > 7){
      rows = ["Wednesday","Thursday","Friday"];
      
    }
    else{
      rows = ["Tuesday","Wednesday","Thursday","Friday"];
    }
  }
  else if(currDay == "Wed"){
    if (currTime > 7){
      rows = ["Thursday","Friday"];
         
    }
    else{
      rows = ["Wednesday","Thursday","Friday"];
    }
  }
  else if(currDay == "Thu"){
    if (currTime > 7){
      rows = ["Friday"];
      
    }
    else{
      rows = ["Thursday","Friday"];
    }
  }
  else if (currDay == "Fri"){
    if (currTime < 7){
      rows = ["Friday"];
     
    }
    else if(currTime < 19){
      rows = ["DO NOT SELECT"];
    }
    else{
      rows = ["Monday","Tuesday","Wednesday","Thursday","Friday"];
    }
  }
  else{
    rows = ["Monday","Tuesday","Wednesday","Thursday","Friday"];
  }
  item.setRows(rows) 
  //item.setColumns(columns)
  
  
  
  form.setDescription(description);
  
}