【分享】轻维表筛选本周数据同步到下一周

阅读次数 136
share dbsheet

文件格式如图： image.png 筛选数据

function main() {
  let all = []
  let offset = null;
  while (all.length === 0 || offset) {
    let records = Application.Record.GetRecords({
      SheetId: 9,
      Offset: offset,
        Filter: {
      mode: 'AND',
      criteria: [
        {field: '课表排课',op: 'Equals',values: ['固定']},
        {"field": "日期","op": "Equals","values": [
         {
          "dynamicType": "lastWeek",
          "type": "DynamicSimple"
          }]}
      ]
    }
    })
    offset = records.offset
    all = all.concat(records.records)
  }

修改时间批量添加

大圣151

if (all) { var newObj = []
for(var i=0;i var date = new Date(all[i].fields['日期']);
date.setDate(date.getDate() + 7);
var newDate = date.getFullYear() + '-' + (date.getMonth() + 1) + '-' + date.getDate();
newObj.push({
"fields": {
"学员":{"recordIds":all[i].fields['学员']},
课程:all[i].fields['课程'],
"老师":{"recordIds":all[i].fields['老师']},
时间:all[i].fields['时间'],
日期:newDate,
发送签到:true
}})
}
}
const records = Application.Record.CreateRecords({
SheetId: 9,
Records: newObj,
})
}
main()

大圣•
0 Answers