通过js使多维表新增记录

仲傲

通过js使多维表新增记录,使用多个方法都报错

2025-04-10 02:43:26 江苏省

1 +1

全部评论 7

陆斐超

@金山办公

您好，创建记录可以使用 RecordRange.Add 方法 https://365.kdocs.cn/3rd/open/documents/app-integration-dev/guide/dbsheet/AirScript/AirScript-demo.html

2025-04-10 05:13:42 · 湖北省

陆斐超

@金山办公

在多维中是不支持 range等智能表格中的api方法的

2025-04-10 05:14:56 · 湖北省

智造-Howell

const rids=Context.argv.rid const sid=Context.argv.sid[0] const rng=Application.Sheets.ItemById(sid).RecordRange(rids,["@销售单号","@订货日期","@所属门店","@业务员","@产品编码","@产品名称","@产品规格","@颜色","@产品图片","@数量","@库存状态","@特殊信息","@特殊金额","@单价","@应收金额","@生产编码","@剩余库存","@预定交期"]) Application.Sheets("开单(打印专用)").RecordRange.Add(null,null,rids.length)(null,["@销售单号","@订货日期","@所属门店","@业务员","@产品编码","@产品名称","@产品规格","@颜色","@产品图片","@数量","@库存状态","@特殊信息","@特殊金额","@单价","@应收金额","@生产编码","@剩余库存","@预定交期"]).Value=rng.Value 可以在这上面试试

2025-04-10 16:45:31 · 广东省