企业微信智能表格-批量添加字段

发刊日期：

2025/10/28

编辑团队：

实在学院

一、功能描述

在智能表中给指定工作表批量添加字段，本组件与下图操作实现效果一致

二、属性说明

组件输入

访问令牌：字符串；企业微信访问令牌access_token，可使用【企业微信智能表格-建立表格连接】组件进行获取
智能表ID：字符串；操作目标智能表ID
工作表ID：字符串；操作目标工作表ID
字段列表：列表；字段列表, 每个字段是一个字典，包含字段标题和类型，参考字段节点结构请查看：企业微信开发者中心-添加字段
参考字段：fields = [ { "field_title": "文本字段", "field_type": "FIELD_TYPE_TEXT" }, { "field_title": "数字字段", "field_type": "FIELD_TYPE_NUMBER", "property_number": { "decimal_places": 0, "use_separate": False } }, { "field_title": "复选框字段", "field_type": "FIELD_TYPE_CHECKBOX", "property_checkbox": { "checked": False } }, { "field_title": "日期字段", "field_type": "FIELD_TYPE_DATE_TIME", "property_date_time": { "format": "yyyy-mm-dd", "auto_fill": False } }, { "field_title": "文件字段", "field_type": "FIELD_TYPE_ATTACHMENT", "property_attachment": { "display_mode": "list" } }, { "field_title": "成员字段", "field_type": "FIELD_TYPE_USER", "property_user": { "is_multiple": True, "is_notified": False } }, { "field_title": "超链接字段", "field_type": "FIELD_TYPE_URL", "property_url": { "type": "LINK_TYPE_PURE_TEXT" } }, { "field_title": "多选字段", "field_type": "FIELD_TYPE_SELECT", "property_select": { "is_quick_add": True, "options": [] } }, { "field_title": "创建时间字段", "field_type": "FIELD_TYPE_CREATED_TIME", "property_created_time": { "format": "yyyy-mm-dd" } }, { "field_title": "最后编辑时间字段", "field_type": "FIELD_TYPE_MODIFIED_TIME", "property_modified_time": { "format": "yyyy-mm-dd" } }, { "field_title": "进度字段", "field_type": "FIELD_TYPE_PROGRESS", "property_progress": { "decimal_places": 0 } }, { "field_title": "单选字段", "field_type": "FIELD_TYPE_SINGLE_SELECT", "property_single_select": { "is_quick_add": True, "options": [] } }, { "field_title": "地理位置字段", "field_type": "FIELD_TYPE_LOCATION", "property_location": { "input_type": "LOCATION_INPUT_TYPE_MANUAL" } }, { "field_title": "自动编号字段", "field_type": "FIELD_TYPE_AUTONUMBER", "property_auto_number": { "type": "NUMBER_TYPE_INCR", "rules": [{"type": "NUMBER_RULE_TYPE_INCR", "value": "1"}], "reformat_existing_record": False } }, { "field_title": "货币字段", "field_type": "FIELD_TYPE_CURRENCY", "property_currency": { "currency_type": "CURRENCY_TYPE_CNY", "decimal_places": 2, "use_separate": False } }, { "field_title": "群字段", "field_type": "FIELD_TYPE_WWGROUP", "property_ww_group": { "allow_multiple": False } }, { "field_title": "百分数字段", "field_type": "FIELD_TYPE_PERCENTAGE", "property_percentage": { "decimal_places": 2, "use_separate": False } }, { "field_title": "条码字段", "field_type": "FIELD_TYPE_BARCODE", "property_barcode": { "mobile_scan_only": False } } ]