我正在使用Google电子表格脚本.我在那里跟踪我的调度.我创建了一个按钮，当按下该按钮时，它将使用您所在的行来创建日历事件. 我正在处理的当前问题是查找事件的任务类型和日期. 我正在使用的3列是:交付，集成，培训.都是日期. 我的第一个(如果没有的话)将日期分配给将用作事件开始日期/时间的变量. 否则，我将任务类型分配给要附加到事件标题的变量.

I'm using google spreadsheet scripting. I track my dispatches there. I created a button that when pressed uses the row you are in to create a calendar event. My current problem I'm working with is finding what type of task the event will be and the date. The 3 columns I'm working with are: Delivery, Integration, Training. All are dates. My first if else I'm assigning the date to a variable that will be used as the event start date/time. The second if else I'm assigning the task type to a variable to append to the event title.

我当前的错误是:丢失；声明前(第15行)-这是我的第一个条件

My current error is: Missing ; before statement (line 15) - that is my first if

     function AddEvent() {

  var ss = SpreadsheetApp.getActiveSheet();
  var row = ss.getActiveRange().getRow();
  var rec = ss.getRange(row,2,1,28).getValues();
  var loc = ss.getRange(row,5).getValue();
  var ttl = ss.getRange(row,2).getValue();
  var typ;
  var stt;
  var del=ss.getRange(row,10).getValue();
  var int=ss.getRange(row,11).getValue();
  var trn=ss.getRange(row,12).getValue();

    //determine what date to use, del-delivery, int-integration, trn-training
    If (isBlank(trn)=False) {stt=trn};
    Else If (isBlank(int)=False) {stt=int};
    Else {stt=del};

    //I will append my event title with this value to know the task type
    If (isBlank(trn)=False) {typ="Training: "};
    Else If (isBlank(int)=False) {typ="Integration: "};
    Else {typ="Delivery: "};

Logger.log(stt, typ);


}