案例文章
推荐的的流程模板
请稍后...
Code
1801
维格表当有数据新增或更新时，钉钉(自建应用)发起待办事项
<p>维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项</p>
zh-Hans
2022-10-31T10:06:29.000Z
2022-10-31T10:06:29.000Z
2022-12-26T11:13:31.000Z
br4815gv
维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项
anyone
5pu3ZRjqjphA
official
wm7415
passed
张守琚
br4815gv
张守琚
[
{
"desc": "当有满足条件的数据新增或更新时同步数据并触发流程",
"app_id": 310,
"action_type": "1",
"sort": "1",
"action_id": 2444,
"note": null
},
{
"desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"app_id": 89,
"action_type": "2",
"sort": "2",
"action_id": 241,
"note": null
},
{
"desc": "根据条件公式（包含并且，或等公式）进行数据查询",
"app_id": 310,
"action_type": "2",
"sort": "3",
"action_id": 541,
"note": null
},
{
"desc": "使用钉钉自建应用根据员工手机号查询员工ID",
"app_id": 69,
"action_type": "2",
"sort": "4",
"action_id": 404,
"note": null
},
{
"desc": "使用钉钉自建应用通过输入指定接收员工ID发起待办事项",
"app_id": 69,
"action_type": "2",
"sort": "5",
"action_id": 405,
"note": null
}
]
1
false
3
{
"1": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"2": [
{
"label": "请输入要调整的日期时间",
"key": "from_time",
"required": true,
"multiples": true,
"help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段"
},
{
"label": "请输入当前日期时间格式",
"key": "from_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换",
"choices": [
{
"value": "auto_format",
"label": "自动识别格式"
},
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
],
"defaulttext": "auto_format"
},
{
"label": "请输入要转换到的日期时间格式",
"key": "to_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"choices": [
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
]
},
{
"label": "调整时间",
"key": "timedelta",
"help_txt": "您可以在日期格式转换后进行时间增加或者减少，请输入一个整数例如1,2,-1,-2"
},
{
"label": "调整的时间单位",
"key": "timedelta_type",
"dropdown": true,
"choices": [
{
"value": "minutes",
"label": "分钟"
},
{
"value": "hours",
"label": "小时"
},
{
"value": "days",
"label": "天"
}
]
}
],
"3": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"4": [
{
"key": "mobile",
"label": "员工手机号",
"type": "string",
"required": true,
"help_txt": "请输入员工手机号"
}
],
"5": [
{
"key": "sourceId",
"label": "业务ID",
"type": "string",
"help_txt": "当ISV接入钉钉待办后，传递ISV应用业务系统侧的唯一标识任务ID。当待办创建成功后，需要更换新的sourceId，保持一个待办任务对应一个sourceId。创建钉钉官方待办时，该字段无需传入。"
},
{
"key": "subject",
"label": "待办标题",
"required": true,
"type": "string"
},
{
"key": "creatorId",
"label": "创建者的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "operatorId",
"label": "当前操作者用户的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "description",
"label": "待办备注描述",
"type": "string",
"help_txt": "最大长度为4096"
},
{
"key": "dueTime",
"label": "截止时间",
"type": "string",
"help_txt": "日期格式，示例：2022-06-01 12:00:00, 可使用“内置应用-日期时间格式变更”进行日期时间转换"
},
{
"key": "executorIds",
"label": "执行者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "participantIds",
"label": "参与者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "detailUrl",
"label": "详情页url跳转地址",
"type": "obj",
"items": [
{
"key": "appUrl",
"label": "APP端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
},
{
"key": "pcUrl",
"label": "PC端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
}
]
},
{
"key": "isOnlyShowExecutor",
"label": "生成的待办是否仅展示在执行者的待办列表中",
"type": "boolean"
},
{
"key": "priority",
"label": "优先级",
"type": "string",
"dropdown": true,
"choices": [
{
"key": "10",
"label": "较低"
},
{
"key": "20",
"label": "普通"
},
{
"key": "30",
"label": "紧急"
},
{
"key": "40",
"label": "非常紧急"
}
]
}
]
}
[]
[]
[
{
"id": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.000Z"
}
},
{
"id": 52,
"name": "日期时间格式变更",
"description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式，应用B中的日期格式是时间戳或者其他时间格式，在这种情况下，我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤，将时间格式转换后再进行同步。</p>",
"popular": 55,
"published_at": "2021-10-25T03:26:32.000Z",
"created_at": "2021-10-25T03:26:30.000Z",
"updated_at": "2023-02-20T11:20:39.000Z",
"app_id": "89",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "变更日期时间格式",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3479,
"name": "datetime.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "datetime_bed27e05e9",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.4,
"url": "/uploads/datetime_bed27e05e9.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:50:28.000Z",
"updated_at": "2022-04-21T08:50:28.000Z"
}
},
{
"id": 25,
"name": "钉钉(自建应用)",
"description": "<p>钉钉，阿里巴巴出品，专为全球企业组织打造的智能移动办公平台，含PC版，Ipad和手机版。远程视频会议，消息已读未读，DING消息任务管理，让沟通更高效；移动办公考勤，签到，审批，企业邮箱，免费企业OA，企业通讯录，钉钉教育解决方案，让工作学习更简单！</p>",
"popular": 216,
"published_at": "2021-10-25T03:01:37.000Z",
"created_at": "2021-10-25T03:01:35.000Z",
"updated_at": "2023-11-09T07:07:58.000Z",
"app_id": "69",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "阿里协同OA系统",
"available": true,
"appid": null,
"website": "https://www.dingtalk.com",
"video": null,
"videos": 109,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 1811,
"name": "Dingding.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Dingding_ac75c3cf81",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 9.4,
"url": "/uploads/Dingding_ac75c3cf81.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-01-26T02:46:50.000Z",
"updated_at": "2022-01-26T02:46:50.000Z"
}
}
]
[
{
"id": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
}
]
[
{
"id": 54,
"key": null,
"published_at": "2021-11-24T06:44:05.000Z",
"created_at": "2021-11-24T06:44:03.000Z",
"updated_at": "2023-11-06T07:41:35.000Z",
"action_id": "241",
"action_name": "日期时间格式调整",
"error": null,
"description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"action_type": "action",
"app": null,
"template": null,
"action_key": "241"
},
{
"id": 2721,
"key": null,
"published_at": "2022-07-25T08:33:21.000Z",
"created_at": "2022-07-25T08:33:21.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2444",
"action_name": "当有满足条件的数据新增或更新时",
"error": null,
"description": "当有满足条件的数据新增或更新时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2444"
},
{
"id": 364,
"key": null,
"published_at": "2021-11-29T10:03:16.000Z",
"created_at": "2021-11-29T10:03:15.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "404",
"action_name": " 根据员工手机号查询员工ID",
"error": null,
"description": "钉钉(自建应用)根据员工手机号查询员工ID",
"action_type": "action",
"app": null,
"template": null,
"action_key": "404"
},
{
"id": 365,
"key": null,
"published_at": "2021-11-29T10:03:35.000Z",
"created_at": "2021-11-29T10:03:34.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "405",
"action_name": "发起待办事项",
"error": null,
"description": "钉钉(自建应用)发起待办事项",
"action_type": "action",
"app": null,
"template": null,
"action_key": "405"
},
{
"id": 239,
"key": null,
"published_at": "2021-11-26T05:46:39.000Z",
"created_at": "2021-11-26T05:46:36.000Z",
"updated_at": "2021-11-26T05:46:39.000Z",
"action_id": "541",
"action_name": "公式搜索数据",
"error": null,
"description": "公式搜索维格表数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
}
]
[
{
"id": 21,
"title": "数据同步",
"sort": 1,
"scene": 5,
"published_at": "2022-12-08T09:01:59.000Z",
"created_at": "2022-12-08T09:01:58.000Z",
"updated_at": "2022-12-14T03:27:10.000Z",
"template": 1781,
"seo": []
}
]
[]
100+
100+
100+
100+
59
Msg
1801
维格表当有数据新增或更新时，钉钉(自建应用)发起待办事项
<p>维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项</p>
zh-Hans
2022-10-31T10:06:29.000Z
2022-10-31T10:06:29.000Z
2022-12-26T11:13:31.000Z
br4815gv
维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项
anyone
5pu3ZRjqjphA
official
wm7415
passed
张守琚
br4815gv
张守琚
[
{
"desc": "当有满足条件的数据新增或更新时同步数据并触发流程",
"app_id": 310,
"action_type": "1",
"sort": "1",
"action_id": 2444,
"note": null
},
{
"desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"app_id": 89,
"action_type": "2",
"sort": "2",
"action_id": 241,
"note": null
},
{
"desc": "根据条件公式（包含并且，或等公式）进行数据查询",
"app_id": 310,
"action_type": "2",
"sort": "3",
"action_id": 541,
"note": null
},
{
"desc": "使用钉钉自建应用根据员工手机号查询员工ID",
"app_id": 69,
"action_type": "2",
"sort": "4",
"action_id": 404,
"note": null
},
{
"desc": "使用钉钉自建应用通过输入指定接收员工ID发起待办事项",
"app_id": 69,
"action_type": "2",
"sort": "5",
"action_id": 405,
"note": null
}
]
1
false
3
{
"1": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"2": [
{
"label": "请输入要调整的日期时间",
"key": "from_time",
"required": true,
"multiples": true,
"help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段"
},
{
"label": "请输入当前日期时间格式",
"key": "from_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换",
"choices": [
{
"value": "auto_format",
"label": "自动识别格式"
},
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
],
"defaulttext": "auto_format"
},
{
"label": "请输入要转换到的日期时间格式",
"key": "to_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"choices": [
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
]
},
{
"label": "调整时间",
"key": "timedelta",
"help_txt": "您可以在日期格式转换后进行时间增加或者减少，请输入一个整数例如1,2,-1,-2"
},
{
"label": "调整的时间单位",
"key": "timedelta_type",
"dropdown": true,
"choices": [
{
"value": "minutes",
"label": "分钟"
},
{
"value": "hours",
"label": "小时"
},
{
"value": "days",
"label": "天"
}
]
}
],
"3": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"4": [
{
"key": "mobile",
"label": "员工手机号",
"type": "string",
"required": true,
"help_txt": "请输入员工手机号"
}
],
"5": [
{
"key": "sourceId",
"label": "业务ID",
"type": "string",
"help_txt": "当ISV接入钉钉待办后，传递ISV应用业务系统侧的唯一标识任务ID。当待办创建成功后，需要更换新的sourceId，保持一个待办任务对应一个sourceId。创建钉钉官方待办时，该字段无需传入。"
},
{
"key": "subject",
"label": "待办标题",
"required": true,
"type": "string"
},
{
"key": "creatorId",
"label": "创建者的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "operatorId",
"label": "当前操作者用户的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "description",
"label": "待办备注描述",
"type": "string",
"help_txt": "最大长度为4096"
},
{
"key": "dueTime",
"label": "截止时间",
"type": "string",
"help_txt": "日期格式，示例：2022-06-01 12:00:00, 可使用“内置应用-日期时间格式变更”进行日期时间转换"
},
{
"key": "executorIds",
"label": "执行者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "participantIds",
"label": "参与者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "detailUrl",
"label": "详情页url跳转地址",
"type": "obj",
"items": [
{
"key": "appUrl",
"label": "APP端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
},
{
"key": "pcUrl",
"label": "PC端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
}
]
},
{
"key": "isOnlyShowExecutor",
"label": "生成的待办是否仅展示在执行者的待办列表中",
"type": "boolean"
},
{
"key": "priority",
"label": "优先级",
"type": "string",
"dropdown": true,
"choices": [
{
"key": "10",
"label": "较低"
},
{
"key": "20",
"label": "普通"
},
{
"key": "30",
"label": "紧急"
},
{
"key": "40",
"label": "非常紧急"
}
]
}
]
}
[]
[]
[
{
"id": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.000Z"
}
},
{
"id": 52,
"name": "日期时间格式变更",
"description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式，应用B中的日期格式是时间戳或者其他时间格式，在这种情况下，我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤，将时间格式转换后再进行同步。</p>",
"popular": 55,
"published_at": "2021-10-25T03:26:32.000Z",
"created_at": "2021-10-25T03:26:30.000Z",
"updated_at": "2023-02-20T11:20:39.000Z",
"app_id": "89",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "变更日期时间格式",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3479,
"name": "datetime.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "datetime_bed27e05e9",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.4,
"url": "/uploads/datetime_bed27e05e9.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:50:28.000Z",
"updated_at": "2022-04-21T08:50:28.000Z"
}
},
{
"id": 25,
"name": "钉钉(自建应用)",
"description": "<p>钉钉，阿里巴巴出品，专为全球企业组织打造的智能移动办公平台，含PC版，Ipad和手机版。远程视频会议，消息已读未读，DING消息任务管理，让沟通更高效；移动办公考勤，签到，审批，企业邮箱，免费企业OA，企业通讯录，钉钉教育解决方案，让工作学习更简单！</p>",
"popular": 216,
"published_at": "2021-10-25T03:01:37.000Z",
"created_at": "2021-10-25T03:01:35.000Z",
"updated_at": "2023-11-09T07:07:58.000Z",
"app_id": "69",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "阿里协同OA系统",
"available": true,
"appid": null,
"website": "https://www.dingtalk.com",
"video": null,
"videos": 109,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 1811,
"name": "Dingding.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Dingding_ac75c3cf81",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 9.4,
"url": "/uploads/Dingding_ac75c3cf81.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-01-26T02:46:50.000Z",
"updated_at": "2022-01-26T02:46:50.000Z"
}
}
]
[
{
"id": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
}
]
[
{
"id": 54,
"key": null,
"published_at": "2021-11-24T06:44:05.000Z",
"created_at": "2021-11-24T06:44:03.000Z",
"updated_at": "2023-11-06T07:41:35.000Z",
"action_id": "241",
"action_name": "日期时间格式调整",
"error": null,
"description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"action_type": "action",
"app": null,
"template": null,
"action_key": "241"
},
{
"id": 2721,
"key": null,
"published_at": "2022-07-25T08:33:21.000Z",
"created_at": "2022-07-25T08:33:21.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2444",
"action_name": "当有满足条件的数据新增或更新时",
"error": null,
"description": "当有满足条件的数据新增或更新时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2444"
},
{
"id": 364,
"key": null,
"published_at": "2021-11-29T10:03:16.000Z",
"created_at": "2021-11-29T10:03:15.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "404",
"action_name": " 根据员工手机号查询员工ID",
"error": null,
"description": "钉钉(自建应用)根据员工手机号查询员工ID",
"action_type": "action",
"app": null,
"template": null,
"action_key": "404"
},
{
"id": 365,
"key": null,
"published_at": "2021-11-29T10:03:35.000Z",
"created_at": "2021-11-29T10:03:34.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "405",
"action_name": "发起待办事项",
"error": null,
"description": "钉钉(自建应用)发起待办事项",
"action_type": "action",
"app": null,
"template": null,
"action_key": "405"
},
{
"id": 239,
"key": null,
"published_at": "2021-11-26T05:46:39.000Z",
"created_at": "2021-11-26T05:46:36.000Z",
"updated_at": "2021-11-26T05:46:39.000Z",
"action_id": "541",
"action_name": "公式搜索数据",
"error": null,
"description": "公式搜索维格表数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
}
]
[
{
"id": 21,
"title": "数据同步",
"sort": 1,
"scene": 5,
"published_at": "2022-12-08T09:01:59.000Z",
"created_at": "2022-12-08T09:01:58.000Z",
"updated_at": "2022-12-14T03:27:10.000Z",
"template": 1781,
"seo": []
}
]
[]
100+
100+
100+
100+
59
Data
1801
维格表当有数据新增或更新时，钉钉(自建应用)发起待办事项
<p>维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项</p>
zh-Hans
2022-10-31T10:06:29.000Z
2022-10-31T10:06:29.000Z
2022-12-26T11:13:31.000Z
br4815gv
维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项
anyone
5pu3ZRjqjphA
official
wm7415
passed
张守琚
br4815gv
张守琚
[
{
"desc": "当有满足条件的数据新增或更新时同步数据并触发流程",
"app_id": 310,
"action_type": "1",
"sort": "1",
"action_id": 2444,
"note": null
},
{
"desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"app_id": 89,
"action_type": "2",
"sort": "2",
"action_id": 241,
"note": null
},
{
"desc": "根据条件公式（包含并且，或等公式）进行数据查询",
"app_id": 310,
"action_type": "2",
"sort": "3",
"action_id": 541,
"note": null
},
{
"desc": "使用钉钉自建应用根据员工手机号查询员工ID",
"app_id": 69,
"action_type": "2",
"sort": "4",
"action_id": 404,
"note": null
},
{
"desc": "使用钉钉自建应用通过输入指定接收员工ID发起待办事项",
"app_id": 69,
"action_type": "2",
"sort": "5",
"action_id": 405,
"note": null
}
]
1
false
3
{
"1": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"2": [
{
"label": "请输入要调整的日期时间",
"key": "from_time",
"required": true,
"multiples": true,
"help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段"
},
{
"label": "请输入当前日期时间格式",
"key": "from_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换",
"choices": [
{
"value": "auto_format",
"label": "自动识别格式"
},
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
],
"defaulttext": "auto_format"
},
{
"label": "请输入要转换到的日期时间格式",
"key": "to_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"choices": [
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
]
},
{
"label": "调整时间",
"key": "timedelta",
"help_txt": "您可以在日期格式转换后进行时间增加或者减少，请输入一个整数例如1,2,-1,-2"
},
{
"label": "调整的时间单位",
"key": "timedelta_type",
"dropdown": true,
"choices": [
{
"value": "minutes",
"label": "分钟"
},
{
"value": "hours",
"label": "小时"
},
{
"value": "days",
"label": "天"
}
]
}
],
"3": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"4": [
{
"key": "mobile",
"label": "员工手机号",
"type": "string",
"required": true,
"help_txt": "请输入员工手机号"
}
],
"5": [
{
"key": "sourceId",
"label": "业务ID",
"type": "string",
"help_txt": "当ISV接入钉钉待办后，传递ISV应用业务系统侧的唯一标识任务ID。当待办创建成功后，需要更换新的sourceId，保持一个待办任务对应一个sourceId。创建钉钉官方待办时，该字段无需传入。"
},
{
"key": "subject",
"label": "待办标题",
"required": true,
"type": "string"
},
{
"key": "creatorId",
"label": "创建者的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "operatorId",
"label": "当前操作者用户的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "description",
"label": "待办备注描述",
"type": "string",
"help_txt": "最大长度为4096"
},
{
"key": "dueTime",
"label": "截止时间",
"type": "string",
"help_txt": "日期格式，示例：2022-06-01 12:00:00, 可使用“内置应用-日期时间格式变更”进行日期时间转换"
},
{
"key": "executorIds",
"label": "执行者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "participantIds",
"label": "参与者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "detailUrl",
"label": "详情页url跳转地址",
"type": "obj",
"items": [
{
"key": "appUrl",
"label": "APP端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
},
{
"key": "pcUrl",
"label": "PC端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
}
]
},
{
"key": "isOnlyShowExecutor",
"label": "生成的待办是否仅展示在执行者的待办列表中",
"type": "boolean"
},
{
"key": "priority",
"label": "优先级",
"type": "string",
"dropdown": true,
"choices": [
{
"key": "10",
"label": "较低"
},
{
"key": "20",
"label": "普通"
},
{
"key": "30",
"label": "紧急"
},
{
"key": "40",
"label": "非常紧急"
}
]
}
]
}
[]
[]
[
{
"id": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.000Z"
}
},
{
"id": 52,
"name": "日期时间格式变更",
"description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式，应用B中的日期格式是时间戳或者其他时间格式，在这种情况下，我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤，将时间格式转换后再进行同步。</p>",
"popular": 55,
"published_at": "2021-10-25T03:26:32.000Z",
"created_at": "2021-10-25T03:26:30.000Z",
"updated_at": "2023-02-20T11:20:39.000Z",
"app_id": "89",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "变更日期时间格式",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3479,
"name": "datetime.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "datetime_bed27e05e9",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.4,
"url": "/uploads/datetime_bed27e05e9.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:50:28.000Z",
"updated_at": "2022-04-21T08:50:28.000Z"
}
},
{
"id": 25,
"name": "钉钉(自建应用)",
"description": "<p>钉钉，阿里巴巴出品，专为全球企业组织打造的智能移动办公平台，含PC版，Ipad和手机版。远程视频会议，消息已读未读，DING消息任务管理，让沟通更高效；移动办公考勤，签到，审批，企业邮箱，免费企业OA，企业通讯录，钉钉教育解决方案，让工作学习更简单！</p>",
"popular": 216,
"published_at": "2021-10-25T03:01:37.000Z",
"created_at": "2021-10-25T03:01:35.000Z",
"updated_at": "2023-11-09T07:07:58.000Z",
"app_id": "69",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "阿里协同OA系统",
"available": true,
"appid": null,
"website": "https://www.dingtalk.com",
"video": null,
"videos": 109,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 1811,
"name": "Dingding.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Dingding_ac75c3cf81",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 9.4,
"url": "/uploads/Dingding_ac75c3cf81.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-01-26T02:46:50.000Z",
"updated_at": "2022-01-26T02:46:50.000Z"
}
}
]
[
{
"id": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
}
]
[
{
"id": 54,
"key": null,
"published_at": "2021-11-24T06:44:05.000Z",
"created_at": "2021-11-24T06:44:03.000Z",
"updated_at": "2023-11-06T07:41:35.000Z",
"action_id": "241",
"action_name": "日期时间格式调整",
"error": null,
"description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"action_type": "action",
"app": null,
"template": null,
"action_key": "241"
},
{
"id": 2721,
"key": null,
"published_at": "2022-07-25T08:33:21.000Z",
"created_at": "2022-07-25T08:33:21.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2444",
"action_name": "当有满足条件的数据新增或更新时",
"error": null,
"description": "当有满足条件的数据新增或更新时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2444"
},
{
"id": 364,
"key": null,
"published_at": "2021-11-29T10:03:16.000Z",
"created_at": "2021-11-29T10:03:15.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "404",
"action_name": " 根据员工手机号查询员工ID",
"error": null,
"description": "钉钉(自建应用)根据员工手机号查询员工ID",
"action_type": "action",
"app": null,
"template": null,
"action_key": "404"
},
{
"id": 365,
"key": null,
"published_at": "2021-11-29T10:03:35.000Z",
"created_at": "2021-11-29T10:03:34.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "405",
"action_name": "发起待办事项",
"error": null,
"description": "钉钉(自建应用)发起待办事项",
"action_type": "action",
"app": null,
"template": null,
"action_key": "405"
},
{
"id": 239,
"key": null,
"published_at": "2021-11-26T05:46:39.000Z",
"created_at": "2021-11-26T05:46:36.000Z",
"updated_at": "2021-11-26T05:46:39.000Z",
"action_id": "541",
"action_name": "公式搜索数据",
"error": null,
"description": "公式搜索维格表数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
}
]
[
{
"id": 21,
"title": "数据同步",
"sort": 1,
"scene": 5,
"published_at": "2022-12-08T09:01:59.000Z",
"created_at": "2022-12-08T09:01:58.000Z",
"updated_at": "2022-12-14T03:27:10.000Z",
"template": 1781,
"seo": []
}
]
[]
100+
100+
100+
100+
59
permission
1801
维格表当有数据新增或更新时，钉钉(自建应用)发起待办事项
<p>维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项</p>
zh-Hans
2022-10-31T10:06:29.000Z
2022-10-31T10:06:29.000Z
2022-12-26T11:13:31.000Z
br4815gv
维格表当有满足条件的数据新增或更新时，日期时间格式变更日期时间格式调整，维格表公式搜索数据，钉钉(自建应用)查询员工ID，钉钉(自建应用)发起待办事项
anyone
5pu3ZRjqjphA
official
wm7415
passed
张守琚
br4815gv
张守琚
[
{
"desc": "当有满足条件的数据新增或更新时同步数据并触发流程",
"app_id": 310,
"action_type": "1",
"sort": "1",
"action_id": 2444,
"note": null
},
{
"desc": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"app_id": 89,
"action_type": "2",
"sort": "2",
"action_id": 241,
"note": null
},
{
"desc": "根据条件公式（包含并且，或等公式）进行数据查询",
"app_id": 310,
"action_type": "2",
"sort": "3",
"action_id": 541,
"note": null
},
{
"desc": "使用钉钉自建应用根据员工手机号查询员工ID",
"app_id": 69,
"action_type": "2",
"sort": "4",
"action_id": 404,
"note": null
},
{
"desc": "使用钉钉自建应用通过输入指定接收员工ID发起待办事项",
"app_id": 69,
"action_type": "2",
"sort": "5",
"action_id": 405,
"note": null
}
]
1
false
3
{
"1": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"2": [
{
"label": "请输入要调整的日期时间",
"key": "from_time",
"required": true,
"multiples": true,
"help_txt": "填写一个日期时间或者选择上面步骤中的动态日期时间字段"
},
{
"label": "请输入当前日期时间格式",
"key": "from_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"help_txt": "请选择上面输入的日期时间格式以便正确的进行格式转换",
"choices": [
{
"value": "auto_format",
"label": "自动识别格式"
},
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
],
"defaulttext": "auto_format"
},
{
"label": "请输入要转换到的日期时间格式",
"key": "to_time_type",
"required": true,
"dropdown": true,
"dynamic": true,
"choices": [
{
"value": "%Y年%m月%d日 %H:%M:%S",
"label": "YYYY年MM月DD日 HH:mm:ss（2006年01月22日 13:29:54)"
},
{
"value": "%Y年%m月%d日",
"label": "YYYY年MM月DD日（2006年01月22日)"
},
{
"value": "%B %d %Y %H:%M:%S",
"label": "MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)"
},
{
"value": "%Y-%m-%dT%H:%M:%S.%fZ",
"label": "YYYY-MM-DDTHH:mm:ss.sssZ (2006-01-22T13:29:53.455Z)"
},
{
"value": "%Y-%m-%dT%H:%M:%SZ",
"label": "YYYY-MM-DDTHH:mm:ssZ (2006-01-22T13:29:53Z)"
},
{
"value": "%B %d %Y",
"label": "MMMM DD YYYY (January 22 2006)"
},
{
"value": "%b %d %Y",
"label": "MMM DD YYYY (Jan 22 2006)"
},
{
"value": "%m-%d-%Y",
"label": "MM-DD-YYYY (01-22-2006)"
},
{
"value": "%m/%d/%Y",
"label": "MM/DD/YYYY (01/22/2006)"
},
{
"value": "%m/%d/%y",
"label": "MM/DD/YY (01/22/06)"
},
{
"value": "%d-%m-%Y",
"label": "DD-MM-YYYY (22-01-2006)"
},
{
"value": "%d/%m/%Y",
"label": "DD/MM/YYYY (22/01/2006)"
},
{
"value": "%d/%m/%y",
"label": "DD/MM/YY (22/01/06)"
},
{
"value": "%Y%m%d",
"label": "YYYYMMDD (20060106)"
},
{
"value": "timestamp",
"label": "时间戳秒 （1597247662）"
},
{
"value": "timestamp_ms",
"label": "时间戳毫秒（1597247662000）"
},
{
"value": "custom",
"label": "自定义格式"
}
]
},
{
"label": "调整时间",
"key": "timedelta",
"help_txt": "您可以在日期格式转换后进行时间增加或者减少，请输入一个整数例如1,2,-1,-2"
},
{
"label": "调整的时间单位",
"key": "timedelta_type",
"dropdown": true,
"choices": [
{
"value": "minutes",
"label": "分钟"
},
{
"value": "hours",
"label": "小时"
},
{
"value": "days",
"label": "天"
}
]
}
],
"3": [
{
"key": "sheet_id",
"label": "选择维格表",
"dropdownTree": true,
"required": true,
"dynamic": true,
"queryParams": [
{
"label": "父节点id",
"key": "node_id",
"is_key": true
},
{
"label": "标识",
"key": "flag",
"defaulttext": "root_node"
}
],
"url": "/v1/api/application/newViKaTable/dropdownTree/nodesList",
"choices": []
}
],
"4": [
{
"key": "mobile",
"label": "员工手机号",
"type": "string",
"required": true,
"help_txt": "请输入员工手机号"
}
],
"5": [
{
"key": "sourceId",
"label": "业务ID",
"type": "string",
"help_txt": "当ISV接入钉钉待办后，传递ISV应用业务系统侧的唯一标识任务ID。当待办创建成功后，需要更换新的sourceId，保持一个待办任务对应一个sourceId。创建钉钉官方待办时，该字段无需传入。"
},
{
"key": "subject",
"label": "待办标题",
"required": true,
"type": "string"
},
{
"key": "creatorId",
"label": "创建者的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "operatorId",
"label": "当前操作者用户的userId",
"type": "string",
"required": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "description",
"label": "待办备注描述",
"type": "string",
"help_txt": "最大长度为4096"
},
{
"key": "dueTime",
"label": "截止时间",
"type": "string",
"help_txt": "日期格式，示例：2022-06-01 12:00:00, 可使用“内置应用-日期时间格式变更”进行日期时间转换"
},
{
"key": "executorIds",
"label": "执行者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "participantIds",
"label": "参与者的userId",
"type": "string",
"multiples": true,
"help_txt": "\n 可以在企业管理后台-通讯录中查看或使用【查询员工ID】动作以及触发动作样本中获取\n "
},
{
"key": "detailUrl",
"label": "详情页url跳转地址",
"type": "obj",
"items": [
{
"key": "appUrl",
"label": "APP端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
},
{
"key": "pcUrl",
"label": "PC端详情页url跳转地址",
"type": "string",
"help_txt": "创建钉钉官方待办时，该字段无需传入;创建第三方待办时，需传入自身应用详情页链接"
}
]
},
{
"key": "isOnlyShowExecutor",
"label": "生成的待办是否仅展示在执行者的待办列表中",
"type": "boolean"
},
{
"key": "priority",
"label": "优先级",
"type": "string",
"dropdown": true,
"choices": [
{
"key": "10",
"label": "较低"
},
{
"key": "20",
"label": "普通"
},
{
"key": "30",
"label": "紧急"
},
{
"key": "40",
"label": "非常紧急"
}
]
}
]
}
[]
[]
[
{
"id": 524,
"name": "维格表",
"description": "<p>维格表将过去复杂的IT数据库技术，做得像表格一样简单 ，可以将复杂的可视化数据库、电子表格、实时网络协同、低代码开发技术四合为一，1个维格表，满足团队协作、项目管理、数据协作等1000+场景，让所有工作连接和整合。</p>",
"popular": 1,
"published_at": "2022-07-25T08:32:52.000Z",
"created_at": "2022-07-25T08:32:52.000Z",
"updated_at": "2023-11-09T02:46:42.000Z",
"app_id": "310",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "低代码应用表单系统",
"available": true,
"appid": null,
"website": "https://vika.cn/",
"video": null,
"videos": 14,
"app_version": "1.0.1",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 5408,
"name": "weigebiao_9542978808.svg",
"alternativeText": "",
"caption": "",
"width": null,
"height": null,
"formats": null,
"hash": "weigebiao_9542978808_c8cf818960",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 7.89,
"url": "/uploads/weigebiao_9542978808_c8cf818960.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-07-25T08:39:11.000Z",
"updated_at": "2022-07-25T08:39:11.000Z"
}
},
{
"id": 52,
"name": "日期时间格式变更",
"description": "<p>日期时间格式变更帮助解决不同应用步骤中对日期时间格式的不同要求。比如应用A中的日期格式是“年月日”的格式，应用B中的日期格式是时间戳或者其他时间格式，在这种情况下，我们可以在应用A步骤与应用B步骤之间添加一个日期时间格式变更步骤，将时间格式转换后再进行同步。</p>",
"popular": 55,
"published_at": "2021-10-25T03:26:32.000Z",
"created_at": "2021-10-25T03:26:30.000Z",
"updated_at": "2023-02-20T11:20:39.000Z",
"app_id": "89",
"category": "Jijianyun",
"locale": "zh-Hans",
"short_description": "变更日期时间格式",
"available": true,
"appid": null,
"website": null,
"video": null,
"videos": null,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 3479,
"name": "datetime.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "datetime_bed27e05e9",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 1.4,
"url": "/uploads/datetime_bed27e05e9.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-04-21T08:50:28.000Z",
"updated_at": "2022-04-21T08:50:28.000Z"
}
},
{
"id": 25,
"name": "钉钉(自建应用)",
"description": "<p>钉钉，阿里巴巴出品，专为全球企业组织打造的智能移动办公平台，含PC版，Ipad和手机版。远程视频会议，消息已读未读，DING消息任务管理，让沟通更高效；移动办公考勤，签到，审批，企业邮箱，免费企业OA，企业通讯录，钉钉教育解决方案，让工作学习更简单！</p>",
"popular": 216,
"published_at": "2021-10-25T03:01:37.000Z",
"created_at": "2021-10-25T03:01:35.000Z",
"updated_at": "2023-11-09T07:07:58.000Z",
"app_id": "69",
"category": "Teamwork",
"locale": "zh-Hans",
"short_description": "阿里协同OA系统",
"available": true,
"appid": null,
"website": "https://www.dingtalk.com",
"video": null,
"videos": 109,
"app_version": "1.0.0",
"key_words": null,
"qr_code": null,
"qr": null,
"sharelink": null,
"seo": null,
"icon": {
"id": 1811,
"name": "Dingding.svg",
"alternativeText": "",
"caption": "",
"width": 50,
"height": 50,
"formats": null,
"hash": "Dingding_ac75c3cf81",
"ext": ".svg",
"mime": "image/svg+xml",
"size": 9.4,
"url": "/uploads/Dingding_ac75c3cf81.svg",
"previewUrl": null,
"provider": "local",
"provider_metadata": null,
"created_at": "2022-01-26T02:46:50.000Z",
"updated_at": "2022-01-26T02:46:50.000Z"
}
}
]
[
{
"id": 5,
"name": "办公协同",
"locale": "zh-Hans",
"published_at": "2022-05-30T07:29:32.000Z",
"created_at": "2022-05-20T08:12:53.000Z",
"updated_at": "2022-05-30T07:29:32.000Z",
"sort": 8
}
]
[
{
"id": 54,
"key": null,
"published_at": "2021-11-24T06:44:05.000Z",
"created_at": "2021-11-24T06:44:03.000Z",
"updated_at": "2023-11-06T07:41:35.000Z",
"action_id": "241",
"action_name": "日期时间格式调整",
"error": null,
"description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接",
"action_type": "action",
"app": null,
"template": null,
"action_key": "241"
},
{
"id": 2721,
"key": null,
"published_at": "2022-07-25T08:33:21.000Z",
"created_at": "2022-07-25T08:33:21.000Z",
"updated_at": "2023-11-06T07:47:44.000Z",
"action_id": "2444",
"action_name": "当有满足条件的数据新增或更新时",
"error": null,
"description": "当有满足条件的数据新增或更新时同步数据并触发流程",
"action_type": "trigger",
"app": null,
"template": null,
"action_key": "2444"
},
{
"id": 364,
"key": null,
"published_at": "2021-11-29T10:03:16.000Z",
"created_at": "2021-11-29T10:03:15.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "404",
"action_name": " 根据员工手机号查询员工ID",
"error": null,
"description": "钉钉(自建应用)根据员工手机号查询员工ID",
"action_type": "action",
"app": null,
"template": null,
"action_key": "404"
},
{
"id": 365,
"key": null,
"published_at": "2021-11-29T10:03:35.000Z",
"created_at": "2021-11-29T10:03:34.000Z",
"updated_at": "2023-11-06T07:38:11.000Z",
"action_id": "405",
"action_name": "发起待办事项",
"error": null,
"description": "钉钉(自建应用)发起待办事项",
"action_type": "action",
"app": null,
"template": null,
"action_key": "405"
},
{
"id": 239,
"key": null,
"published_at": "2021-11-26T05:46:39.000Z",
"created_at": "2021-11-26T05:46:36.000Z",
"updated_at": "2021-11-26T05:46:39.000Z",
"action_id": "541",
"action_name": "公式搜索数据",
"error": null,
"description": "公式搜索维格表数据",
"action_type": "action",
"app": null,
"template": null,
"action_key": null
}
]
[
{
"id": 21,
"title": "数据同步",
"sort": 1,
"scene": 5,
"published_at": "2022-12-08T09:01:59.000Z",
"created_at": "2022-12-08T09:01:58.000Z",
"updated_at": "2022-12-14T03:27:10.000Z",
"template": 1781,
"seo": []
}
]
[]
100+
100+
100+
100+
59
触发动作
执行动作
