😀模板核心功能拓展【成绩录入与查询】-引用字段添加电话

 Application.Sheets.Item('班级学生成绩总表').Activate();//选择需要写入的数据表

const sheet = Application.ActiveSheet;

console.log(sheet.Name)

const view = sheet.Selection.GetActiveView()

let all = []

let offset = null;

while (all.length === 0 || offset) {

let records = sheet.Record.GetRecords({

ViewId: view.viewId,

Offset: offset,

})

offset = records.offset

all = all.concat(records.records)

}

const recordsToUpdate = [];

for (let i = 0; i < all.length; i++) {

const item = all[i];

const phone = item.fields.家长联系方式;

// 添加待更新的记录到数组

recordsToUpdate.push({

id: item.id,

fields: {

电话: phone,

}

});

}

// 一次性更新所有记录

const updateResult = sheet.Record.UpdateRecords({

Records: recordsToUpdate

});