• 当前模板排行信息
  • 周排行
  • 月排行
  • 季度排行
  • 年度排行

    教学视频

    案例文章

推荐的的流程模板
请稍后...
自定义您的业务流程
选择的触发与执行动作,建立自动化的业务流程。
当这个情况发生时触发动作
  • 当审批任务开始时
    当钉钉(自建应用)有审批任务开始时,触发流程
  • 当审批任务转交时
    当钉钉(自建应用)有审批任务转交时,触发流程
  • 当审批任务结束时
    当钉钉(自建应用)有审批任务结束时,触发流程
  • 当审批流程开始时
    当钉钉(自建应用)有审批任务开始时,触发流程
  • 当审批流程结束时
    当钉钉(自建应用)有审批流程结束时,触发流程
  • 当员工打卡时
    当钉钉(自建应用)有员工打卡时,触发流程
  • 当员工排班变更时
    当钉钉(自建应用)有员工排班变更时,触发流程
  • 当员工加班时
    当钉钉(自建应用)有员工加班时,触发流程
  • 群会话添加成员时
    当钉钉(自建应用)有群会话添加成员时,触发流程
  • 群会话用户主动退群时
    当钉钉(自建应用)有群会话用户主动退群时,触发流程
  • 当智能表单有新增数据时
    当钉钉(自建应用)有智能表单有新增数据时,触发流程
  • 当有日志新增时
    当有日志新增时流程触发
  • 当指定部门有新员工加入时
    当指定部门有新员工加入时
  • 当有新的待入职员工时
    当有新的待入职员工时同步数据并触发流程
  • 当通讯录中有人员增加时
    当通讯录中有人员增加时
  • 当通讯录中有人员信息被修改时
    当通讯录中有人员信息被修改时
  • 当群会话解散群时
    API创建的企业群,当企业群会话解散群时,触发此事件
  • 当符合条件的审批任务结束时
    当符合条件的审批任务结束时
  • 当符合条件的审批流实例结束时
    当符合条件的审批流实例结束时
  • 当有客户新增时
    当有客户新增时
  • 当有联系人新增时
    当有企业客户更新时
  • 当有跟进记录新增时
    当有个人客户新增时
  • 当有员工离职时
    当有员工离职时
  • 当有满足条件的数据新增或更新时
    当有满足条件的数据新增或更新时同步数据并触发流程
  • 当有数据更新时(按自定义字段排序)
    当有数据更新时同步数据并触发流程
做这件事情执行动作
  • 发送文本消息
    通过输入指定成员ID发送文本
  • 发送Markdown
    通过输入指定成员ID发送Markdown消息
  • 发送文本通知
    发送部门或全体的文本格式通知(通过下拉列表或插入数据方式)
  • 发送markdown通知
    发送部门或全体的Markdown格式通知(通过下拉列表或插入数据方式)
  • 发送文本通知给部门内指定成员
    发送文本通知给部门内指定成员(通过下拉列表或插入数据方式)
  • 发送Markdown通知给部门内指定
    发送Markdown通知给部门内指定成员(通过下拉列表或插入数据方式)
  • 根据员工手机号查询员工ID
    钉钉(自建应用)根据员工手机号查询员工ID
  • 发起待办事项
    钉钉(自建应用)发起待办事项
  • 查询审批实例详情
    钉钉(自建应用)查询审批实例详情
  • 创建日程
    当系统有新增计划或任务时客自动创建日程
  • 创建日志
    当系统有新任务时自动创建日志
  • 获取日志模板详情
    当有新增日志时,获取日志模板详情
  • 使用服务助手推送消息
    使用服务助手推送消息
  • 创建视频会议
    创建视频会议,用户可以自定义会议主题,邀请参会人员
  • 关闭视频会议
    调用本接口关闭视频会议,仅限该会议的主持人有关闭视频会议的权限
  • 批量查询视频会议信息
    查询会议信息以及参会人员,目前只支持查询正在进行的会议
  • 创建新用户
    创建新用户
  • 更新指定用户信息
    更新指定的用户信息
  • 同意或拒绝审批任务
    根据指定模板ID、实例ID、审批节点ID和审批人,对单个审批任务进行处理
  • 获取审批实例ID列表
    调用本接口获取权限范围内的相关部门审批实例ID列表
  • 发起审批实例
    在钉钉中发起一个审批实例
  • 查询用户详情
    使用用户id查询用户的详细信息
  • 获取员工花名册字段信息
    获取员工花名册字段信息
  • 更新员工花名册信息
    更新智能人事中花名册信息
  • 批量获取员工离职信息
    批量获取智能人事员工离职信息
  • 创建群会话
    创建新的群会话
  • 获取群会话信息
    获取群设置和成员信息
  • 修改群会话
    修改群设置和群成员信息
  • 发起审批实例1.0.1
    基于执行动作发起审批实例兼容了表单明细控件的功能
  • 创建审批模板
    创建审批模板
  • 获取在职员工列表
    获取在职员工列表
  • 创建个人或企业客户
    创建个人或企业客户
  • 批量新增联系人数据
    批量新增联系人数据
  • 删除用户
    删除用户
  • 查询审批实例详情1.0.1
    查询审批实例详情(新抹平)
  • 查询审批实例详情1.0.2
    使用钉钉自建应用询审批实例详情(兼容表格抹平)
  • 撤销审批实例
    根据审批实例id撤销发起的审批实例
  • 日期时间格式调整
    调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接
  • 批量日期时间格式调整
    批量调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接
  • 添加记录
    向维格表中添加数据
  • 修改数据
    修改维格表的数据
  • 上传附件
    像维格表中上传附件
  • 查询数据
    查询维格表中的数据
  • 公式搜索数据
    公式搜索数据
开始创建吧
立即创建使用
相关文章
查看更多>
  • week 100+
  • month 100+
  • quarter 100+
  • year 100+
  • user_name 张守琚
  • used_count 1
  • shared_tem_count 56
  • 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-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "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-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "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": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2721, "key": null, "published_at": "2022-07-25T08:33:21.000Z", "created_at": "2022-07-25T08:33:21.000Z", "updated_at": "2022-07-25T08:33:21.000Z", "action_id": "2444", "action_name": "当有满足条件的数据新增或更新时", "error": null, "description": "当有满足条件的数据新增或更新时同步数据并触发流程", "action_type": "trigger", "app": null, "template": null }, { "id": 364, "key": null, "published_at": "2021-11-29T10:03:16.000Z", "created_at": "2021-11-29T10:03:15.000Z", "updated_at": "2021-11-29T10:03:16.000Z", "action_id": "404", "action_name": " 根据员工手机号查询员工ID", "error": null, "description": "钉钉(自建应用)根据员工手机号查询员工ID", "action_type": "action", "app": null, "template": null }, { "id": 365, "key": null, "published_at": "2021-11-29T10:03:35.000Z", "created_at": "2021-11-29T10:03:34.000Z", "updated_at": "2021-11-29T10:03:35.000Z", "action_id": "405", "action_name": "发起待办事项", "error": null, "description": "钉钉(自建应用)发起待办事项", "action_type": "action", "app": null, "template": null }, { "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 } ] [ { "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+ 56
  • 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-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "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-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "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": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2721, "key": null, "published_at": "2022-07-25T08:33:21.000Z", "created_at": "2022-07-25T08:33:21.000Z", "updated_at": "2022-07-25T08:33:21.000Z", "action_id": "2444", "action_name": "当有满足条件的数据新增或更新时", "error": null, "description": "当有满足条件的数据新增或更新时同步数据并触发流程", "action_type": "trigger", "app": null, "template": null }, { "id": 364, "key": null, "published_at": "2021-11-29T10:03:16.000Z", "created_at": "2021-11-29T10:03:15.000Z", "updated_at": "2021-11-29T10:03:16.000Z", "action_id": "404", "action_name": " 根据员工手机号查询员工ID", "error": null, "description": "钉钉(自建应用)根据员工手机号查询员工ID", "action_type": "action", "app": null, "template": null }, { "id": 365, "key": null, "published_at": "2021-11-29T10:03:35.000Z", "created_at": "2021-11-29T10:03:34.000Z", "updated_at": "2021-11-29T10:03:35.000Z", "action_id": "405", "action_name": "发起待办事项", "error": null, "description": "钉钉(自建应用)发起待办事项", "action_type": "action", "app": null, "template": null }, { "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 } ] [ { "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+ 56
  • 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-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "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-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "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": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2721, "key": null, "published_at": "2022-07-25T08:33:21.000Z", "created_at": "2022-07-25T08:33:21.000Z", "updated_at": "2022-07-25T08:33:21.000Z", "action_id": "2444", "action_name": "当有满足条件的数据新增或更新时", "error": null, "description": "当有满足条件的数据新增或更新时同步数据并触发流程", "action_type": "trigger", "app": null, "template": null }, { "id": 364, "key": null, "published_at": "2021-11-29T10:03:16.000Z", "created_at": "2021-11-29T10:03:15.000Z", "updated_at": "2021-11-29T10:03:16.000Z", "action_id": "404", "action_name": " 根据员工手机号查询员工ID", "error": null, "description": "钉钉(自建应用)根据员工手机号查询员工ID", "action_type": "action", "app": null, "template": null }, { "id": 365, "key": null, "published_at": "2021-11-29T10:03:35.000Z", "created_at": "2021-11-29T10:03:34.000Z", "updated_at": "2021-11-29T10:03:35.000Z", "action_id": "405", "action_name": "发起待办事项", "error": null, "description": "钉钉(自建应用)发起待办事项", "action_type": "action", "app": null, "template": null }, { "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 } ] [ { "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+ 56
  • 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-01-28T09:02:30.000Z", "app_id": "310", "category": "Teamwork", "locale": "zh-Hans", "short_description": "低代码应用表单系统", "available": true, "appid": null, "website": "https://vika.cn/", "video": null, "videos": null, "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-01-28T09:03:31.000Z", "app_id": "69", "category": "Teamwork", "locale": "zh-Hans", "short_description": "阿里协同OA系统", "available": true, "appid": null, "website": "https://www.dingtalk.com", "video": null, "videos": null, "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": "2021-11-24T06:44:05.000Z", "action_id": "241", "action_name": "日期时间格式调整", "error": null, "description": "调整其他步骤中日期时间字段格式以便用于后续步骤中与其他系统对接", "action_type": "action", "app": null, "template": null }, { "id": 2721, "key": null, "published_at": "2022-07-25T08:33:21.000Z", "created_at": "2022-07-25T08:33:21.000Z", "updated_at": "2022-07-25T08:33:21.000Z", "action_id": "2444", "action_name": "当有满足条件的数据新增或更新时", "error": null, "description": "当有满足条件的数据新增或更新时同步数据并触发流程", "action_type": "trigger", "app": null, "template": null }, { "id": 364, "key": null, "published_at": "2021-11-29T10:03:16.000Z", "created_at": "2021-11-29T10:03:15.000Z", "updated_at": "2021-11-29T10:03:16.000Z", "action_id": "404", "action_name": " 根据员工手机号查询员工ID", "error": null, "description": "钉钉(自建应用)根据员工手机号查询员工ID", "action_type": "action", "app": null, "template": null }, { "id": 365, "key": null, "published_at": "2021-11-29T10:03:35.000Z", "created_at": "2021-11-29T10:03:34.000Z", "updated_at": "2021-11-29T10:03:35.000Z", "action_id": "405", "action_name": "发起待办事项", "error": null, "description": "钉钉(自建应用)发起待办事项", "action_type": "action", "app": null, "template": null }, { "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 } ] [ { "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+ 56