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

    教学视频

    案例文章

推荐的的流程模板
请稍后...
自定义您的业务流程
选择的触发与执行动作,建立自动化的业务流程。
当这个情况发生时触发动作
  • 当接收到邮件时
    当接收到邮件时流程触发
  • 当有满足条件的数据新增或更新时
    当有满足条件的数据新增或更新时同步数据并触发流程
  • 当有数据更新时(按自定义字段排序)
    当有数据更新时同步数据并触发流程
做这件事情执行动作
  • 添加记录
    向维格表中添加数据
  • 修改数据
    修改维格表的数据
  • 上传附件
    像维格表中上传附件
  • 查询数据
    查询维格表中的数据
  • 公式搜索数据
    公式搜索数据
  • 将文本转换为数组
    手动输入或继承变量生成数组
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 数组聚合
    将数组-对象类的数据按照规则进行提取
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 嵌套数组聚合
    将包含多层数据嵌套结构的数组按照指定字段进行聚合并输出聚合数组
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 数组聚合
    将数组-对象类的数据按照规则进行提取
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 嵌套数组聚合
    将包含多层数据嵌套结构的数组按照指定字段进行聚合并输出聚合数组
  • 按索引查询
    按照索引查询列表的元素值
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 数组聚合
    将数组-对象类的数据按照规则进行提取
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 嵌套数组聚合
    将包含多层数据嵌套结构的数组按照指定字段进行聚合并输出聚合数组
  • 按索引查询
    按照索引查询列表的元素值
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 数组聚合
    将数组-对象类的数据按照规则进行提取
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 嵌套数组聚合
    将包含多层数据嵌套结构的数组按照指定字段进行聚合并输出聚合数组
  • 按索引查询
    按照索引查询列表的元素值
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 数组聚合
    将数组-对象类的数据按照规则进行提取
  • 将数组转换为文本
    将数组中的元素按照指定的符号连接成一个字符串
  • 将文本转换为数组
    将文本内容手动输入或引用上面步骤继承变量生成一组数组
  • 嵌套数组聚合
    将包含多层数据嵌套结构的数组按照指定字段进行聚合并输出聚合数组
  • 按索引查询
    按照索引查询列表的元素值
  • 复制元素生成数组
    将输入的值按照设定的个数进行复制
  • 数组计算
    对数组内对象进行计算处理
  • 汇总数据
    选择多个数组合并为一条数据(可以在数组间添加文本、换行符等)
  • 数组替换
    将字符串源数据包含的替换前字符串转换成目标数据字符串
  • 数组聚合
    将数组-对象类的数据按照规则进行提取
  • 文本分隔
    对一整段文本进行分隔,分隔后的字段可以作为字段参数用于后续的步骤中,比如换行分隔,英文逗号分隔等
  • 字段空值替换
    使用空值替换动作可以将空值替换为默认的字段值,以避免字段为空值导致的流程问题。
  • 公式计算
    公式计算动作支持使用Excel函数公式对文本进行处理,计算结果可以用于后续步骤中使用。
  • HTML文本转换为Markdown文本
    将HTML转换为Markdown格式的文本
  • Markdown文本转换为HTML文本
    将Markdown格式文本转换为HTML文本
  • URL编码
    URL 编码会将字符转换为可通过网络传输的格式
  • URL解码
    将已经编程的符号还原成各种符号
  • 表格公式转文本
    将表格公式转化为文本格式
  • 日期时间比较
    用于日期时间比较
  • 删除HTML标签
    删除HTML标签
  • 数字转换为中文数字
    将数字转换为中文数字
  • 搜索并计数
    在表格中搜索并计数
  • 提取URL链接
    提取URL链接
  • 提取文本中数字
    提取文本中数字
  • 文本长度限制
    将文本长度进行限制
  • 校验信息有效性
    设置验证方法,校验信息有效性
  • 转换为数字
    将表单、字符等转换为数字
  • Base64编码
    将文本内容进行Base64编码
  • Base64解码
    将文本内容进行Base64解码
  • 提取文本中汉字
    提取文本中汉字
  • 删除空格
    删除单词或字符间多余的空格
  • 删除换行
    删除文本中的换行
  • 删除非打印文本
    删除文本中不会打印的转义符
  • 文本分隔-自定义分隔符
    根据自定义分隔符进行文本分隔
  • 汉字转换成拼音
    根据汉字转换成拼音
  • 字符串转换JSON
    可以将未拆分处理的字符串转换成JSON以便于后续步骤引用该变量
  • 批量公式计算
    使用Excel函数公式对文本进行处理
  • 将CSV文件转换为JSONLines
    将CSV文件转换为可以训练ChatGPT模型的JSONLines文件链接
  • 通过文本分隔符拆分并循环执行
    当外部系统有查询任务时,通过循环执行汇总查询信息
  • 通过数组拆分并循环执行
    通过数组拆分并循环执行
  • 通过数字拆分并执行流程
    按照用户设定的数字控制后续循环次数依次执行流程
  • 汇总循环内数据
    将循环内的数据按照每次循环任务执行的结果进行汇总输出为一个数组 可以在后续步骤中插入数组使用
开始创建吧
立即创建使用
相关文章
查看更多>
  • week 100+
  • month 68
  • quarter 45
  • year 45
  • user_name 谢晓鸣
  • used_count 2
  • shared_tem_count 70
  • Code 1581 邮件接收到表格内容,将表格内数据同步到维格表 <p>邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。</p> zh-Hans 2022-09-20T03:45:33.000Z 2022-09-20T03:45:33.000Z 2023-03-07T04:50:00.000Z ay4830az 邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。 anyone 68ZG0OTgxCLy official pc1265 passed 谢晓鸣 ay4830az 谢晓鸣 [ { "desc": "向之前生成的邮件地址发送邮件,接收到邮件时同步数据并触发流程", "app_id": 125, "action_type": "1", "sort": "1", "action_id": 477, "note": null }, { "desc": "删除单词或字符间多余的空格", "app_id": 108, "action_type": "2", "sort": "2", "action_id": 1681, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "3", "action_id": 334, "note": null }, { "desc": "手动输入或继承变量生成数组", "app_id": 1000454, "action_type": "2", "sort": "4", "action_id": 1001703, "note": null }, { "desc": "通过文本字符对字段值进行拆分,拆分后的字段值将进行逐个执行", "app_id": 131, "action_type": "2", "sort": "5", "action_id": 501, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "6", "action_id": 334, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "7", "action_id": 364, "note": null } ] 2 false { "1": [], "2": [ { "key": "text", "label": "文本内容", "required": true, "multiples": false, "type": "text" }, { "key": "is_keep_one", "label": "是否保留1个空格", "required": false, "type": "string", "dropdown": true, "defaulttext": "1", "choices": [ { "key": "0", "label": "否" }, { "key": "1", "label": "是" } ] } ], "3": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "4": [], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": ",", "dropdown": false, "help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤", "label": "分隔符", "type": "string", "dynamic": false, "key": "separator", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "7": [ { "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": [] } ] } [] [] [ { "id": 86, "name": "邮件触发", "description": "<p>邮件触发是集简云的内置应用,通过创建集简云邮件账户,并向此邮件账户发送邮件,即可触发流程,并可以将邮件中的正文内容,邮件发送人,接收人,发送时间等信息作为变量在后续步骤中使用。</p>", "popular": 103, "published_at": "2021-10-25T05:36:52.000Z", "created_at": "2021-10-25T05:36:50.000Z", "updated_at": "2023-02-20T11:20:24.000Z", "app_id": "125", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "发送邮件触发流程", "available": true, "appid": null, "website": null, "video": null, "videos": 97, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3469, "name": "email-trigger.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "email_trigger_ec28d8c23c", "ext": ".svg", "mime": "image/svg+xml", "size": 1.32, "url": "/uploads/email_trigger_ec28d8c23c.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:43:54.000Z", "updated_at": "2022-04-21T08:43:55.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "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": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "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": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "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": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } }, { "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": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 3150, "key": null, "published_at": "2022-08-26T10:11:02.000Z", "created_at": "2022-08-26T10:11:02.000Z", "updated_at": "2022-08-26T10:11:02.000Z", "action_id": "1001703", "action_name": "将文本转换为数组", "error": null, "description": "手动输入或继承变量生成数组", "action_type": "action", "app": null, "template": null }, { "id": 1596, "key": null, "published_at": "2022-04-28T11:08:45.000Z", "created_at": "2022-04-28T11:08:45.000Z", "updated_at": "2022-04-28T11:08:45.000Z", "action_id": "1681", "action_name": "删除空格", "error": null, "description": "删除单词或字符间多余的空格", "action_type": "action", "app": null, "template": null }, { "id": 2716, "key": null, "published_at": "2022-07-25T08:33:20.000Z", "created_at": "2022-07-25T08:33:20.000Z", "updated_at": "2022-07-25T08:33:20.000Z", "action_id": "2431", "action_name": "添加记录", "error": null, "description": "向维格表中添加数据", "action_type": "action", "app": null, "template": null }, { "id": 226, "key": null, "published_at": "2021-11-26T05:39:45.000Z", "created_at": "2021-11-26T05:39:44.000Z", "updated_at": "2021-11-26T05:39:46.000Z", "action_id": "334", "action_name": "文本分隔", "error": null, "description": "对一整段文本进行分隔,分隔后的字段可以作为字段参数用于后续的步骤中,比如换行分隔,英文逗号分隔等", "action_type": "action", "app": null, "template": null }, { "id": 402, "key": null, "published_at": "2021-11-30T05:39:51.000Z", "created_at": "2021-11-30T05:39:49.000Z", "updated_at": "2021-11-30T06:11:18.000Z", "action_id": "477", "action_name": "当接收到邮件时", "error": null, "description": "当接收到邮件时流程触发", "action_type": "trigger", "app": null, "template": null }, { "id": 422, "key": null, "published_at": "2021-11-30T06:25:32.000Z", "created_at": "2021-11-30T06:25:29.000Z", "updated_at": "2021-11-30T06:25:32.000Z", "action_id": "501", "action_name": "通过文本分隔符拆分并循环执行", "error": null, "description": "当外部系统有查询任务时,通过循环执行汇总查询信息", "action_type": "action", "app": null, "template": null } ] [ { "id": 42, "title": "内容同步", "sort": 1, "scene": 10, "published_at": "2022-12-08T09:27:27.000Z", "created_at": "2022-12-08T09:27:26.000Z", "updated_at": "2022-12-12T08:29:32.000Z", "template": 1692, "seo": [] } ] [] 100+ 68 45 45 70
  • Msg 1581 邮件接收到表格内容,将表格内数据同步到维格表 <p>邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。</p> zh-Hans 2022-09-20T03:45:33.000Z 2022-09-20T03:45:33.000Z 2023-03-07T04:50:00.000Z ay4830az 邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。 anyone 68ZG0OTgxCLy official pc1265 passed 谢晓鸣 ay4830az 谢晓鸣 [ { "desc": "向之前生成的邮件地址发送邮件,接收到邮件时同步数据并触发流程", "app_id": 125, "action_type": "1", "sort": "1", "action_id": 477, "note": null }, { "desc": "删除单词或字符间多余的空格", "app_id": 108, "action_type": "2", "sort": "2", "action_id": 1681, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "3", "action_id": 334, "note": null }, { "desc": "手动输入或继承变量生成数组", "app_id": 1000454, "action_type": "2", "sort": "4", "action_id": 1001703, "note": null }, { "desc": "通过文本字符对字段值进行拆分,拆分后的字段值将进行逐个执行", "app_id": 131, "action_type": "2", "sort": "5", "action_id": 501, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "6", "action_id": 334, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "7", "action_id": 364, "note": null } ] 2 false { "1": [], "2": [ { "key": "text", "label": "文本内容", "required": true, "multiples": false, "type": "text" }, { "key": "is_keep_one", "label": "是否保留1个空格", "required": false, "type": "string", "dropdown": true, "defaulttext": "1", "choices": [ { "key": "0", "label": "否" }, { "key": "1", "label": "是" } ] } ], "3": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "4": [], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": ",", "dropdown": false, "help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤", "label": "分隔符", "type": "string", "dynamic": false, "key": "separator", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "7": [ { "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": [] } ] } [] [] [ { "id": 86, "name": "邮件触发", "description": "<p>邮件触发是集简云的内置应用,通过创建集简云邮件账户,并向此邮件账户发送邮件,即可触发流程,并可以将邮件中的正文内容,邮件发送人,接收人,发送时间等信息作为变量在后续步骤中使用。</p>", "popular": 103, "published_at": "2021-10-25T05:36:52.000Z", "created_at": "2021-10-25T05:36:50.000Z", "updated_at": "2023-02-20T11:20:24.000Z", "app_id": "125", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "发送邮件触发流程", "available": true, "appid": null, "website": null, "video": null, "videos": 97, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3469, "name": "email-trigger.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "email_trigger_ec28d8c23c", "ext": ".svg", "mime": "image/svg+xml", "size": 1.32, "url": "/uploads/email_trigger_ec28d8c23c.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:43:54.000Z", "updated_at": "2022-04-21T08:43:55.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "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": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "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": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "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": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } }, { "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": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 3150, "key": null, "published_at": "2022-08-26T10:11:02.000Z", "created_at": "2022-08-26T10:11:02.000Z", "updated_at": "2022-08-26T10:11:02.000Z", "action_id": "1001703", "action_name": "将文本转换为数组", "error": null, "description": "手动输入或继承变量生成数组", "action_type": "action", "app": null, "template": null }, { "id": 1596, "key": null, "published_at": "2022-04-28T11:08:45.000Z", "created_at": "2022-04-28T11:08:45.000Z", "updated_at": "2022-04-28T11:08:45.000Z", "action_id": "1681", "action_name": "删除空格", "error": null, "description": "删除单词或字符间多余的空格", "action_type": "action", "app": null, "template": null }, { "id": 2716, "key": null, "published_at": "2022-07-25T08:33:20.000Z", "created_at": "2022-07-25T08:33:20.000Z", "updated_at": "2022-07-25T08:33:20.000Z", "action_id": "2431", "action_name": "添加记录", "error": null, "description": "向维格表中添加数据", "action_type": "action", "app": null, "template": null }, { "id": 226, "key": null, "published_at": "2021-11-26T05:39:45.000Z", "created_at": "2021-11-26T05:39:44.000Z", "updated_at": "2021-11-26T05:39:46.000Z", "action_id": "334", "action_name": "文本分隔", "error": null, "description": "对一整段文本进行分隔,分隔后的字段可以作为字段参数用于后续的步骤中,比如换行分隔,英文逗号分隔等", "action_type": "action", "app": null, "template": null }, { "id": 402, "key": null, "published_at": "2021-11-30T05:39:51.000Z", "created_at": "2021-11-30T05:39:49.000Z", "updated_at": "2021-11-30T06:11:18.000Z", "action_id": "477", "action_name": "当接收到邮件时", "error": null, "description": "当接收到邮件时流程触发", "action_type": "trigger", "app": null, "template": null }, { "id": 422, "key": null, "published_at": "2021-11-30T06:25:32.000Z", "created_at": "2021-11-30T06:25:29.000Z", "updated_at": "2021-11-30T06:25:32.000Z", "action_id": "501", "action_name": "通过文本分隔符拆分并循环执行", "error": null, "description": "当外部系统有查询任务时,通过循环执行汇总查询信息", "action_type": "action", "app": null, "template": null } ] [ { "id": 42, "title": "内容同步", "sort": 1, "scene": 10, "published_at": "2022-12-08T09:27:27.000Z", "created_at": "2022-12-08T09:27:26.000Z", "updated_at": "2022-12-12T08:29:32.000Z", "template": 1692, "seo": [] } ] [] 100+ 68 45 45 70
  • Data 1581 邮件接收到表格内容,将表格内数据同步到维格表 <p>邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。</p> zh-Hans 2022-09-20T03:45:33.000Z 2022-09-20T03:45:33.000Z 2023-03-07T04:50:00.000Z ay4830az 邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。 anyone 68ZG0OTgxCLy official pc1265 passed 谢晓鸣 ay4830az 谢晓鸣 [ { "desc": "向之前生成的邮件地址发送邮件,接收到邮件时同步数据并触发流程", "app_id": 125, "action_type": "1", "sort": "1", "action_id": 477, "note": null }, { "desc": "删除单词或字符间多余的空格", "app_id": 108, "action_type": "2", "sort": "2", "action_id": 1681, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "3", "action_id": 334, "note": null }, { "desc": "手动输入或继承变量生成数组", "app_id": 1000454, "action_type": "2", "sort": "4", "action_id": 1001703, "note": null }, { "desc": "通过文本字符对字段值进行拆分,拆分后的字段值将进行逐个执行", "app_id": 131, "action_type": "2", "sort": "5", "action_id": 501, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "6", "action_id": 334, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "7", "action_id": 364, "note": null } ] 2 false { "1": [], "2": [ { "key": "text", "label": "文本内容", "required": true, "multiples": false, "type": "text" }, { "key": "is_keep_one", "label": "是否保留1个空格", "required": false, "type": "string", "dropdown": true, "defaulttext": "1", "choices": [ { "key": "0", "label": "否" }, { "key": "1", "label": "是" } ] } ], "3": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "4": [], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": ",", "dropdown": false, "help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤", "label": "分隔符", "type": "string", "dynamic": false, "key": "separator", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "7": [ { "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": [] } ] } [] [] [ { "id": 86, "name": "邮件触发", "description": "<p>邮件触发是集简云的内置应用,通过创建集简云邮件账户,并向此邮件账户发送邮件,即可触发流程,并可以将邮件中的正文内容,邮件发送人,接收人,发送时间等信息作为变量在后续步骤中使用。</p>", "popular": 103, "published_at": "2021-10-25T05:36:52.000Z", "created_at": "2021-10-25T05:36:50.000Z", "updated_at": "2023-02-20T11:20:24.000Z", "app_id": "125", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "发送邮件触发流程", "available": true, "appid": null, "website": null, "video": null, "videos": 97, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3469, "name": "email-trigger.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "email_trigger_ec28d8c23c", "ext": ".svg", "mime": "image/svg+xml", "size": 1.32, "url": "/uploads/email_trigger_ec28d8c23c.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:43:54.000Z", "updated_at": "2022-04-21T08:43:55.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "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": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "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": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "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": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } }, { "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": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 3150, "key": null, "published_at": "2022-08-26T10:11:02.000Z", "created_at": "2022-08-26T10:11:02.000Z", "updated_at": "2022-08-26T10:11:02.000Z", "action_id": "1001703", "action_name": "将文本转换为数组", "error": null, "description": "手动输入或继承变量生成数组", "action_type": "action", "app": null, "template": null }, { "id": 1596, "key": null, "published_at": "2022-04-28T11:08:45.000Z", "created_at": "2022-04-28T11:08:45.000Z", "updated_at": "2022-04-28T11:08:45.000Z", "action_id": "1681", "action_name": "删除空格", "error": null, "description": "删除单词或字符间多余的空格", "action_type": "action", "app": null, "template": null }, { "id": 2716, "key": null, "published_at": "2022-07-25T08:33:20.000Z", "created_at": "2022-07-25T08:33:20.000Z", "updated_at": "2022-07-25T08:33:20.000Z", "action_id": "2431", "action_name": "添加记录", "error": null, "description": "向维格表中添加数据", "action_type": "action", "app": null, "template": null }, { "id": 226, "key": null, "published_at": "2021-11-26T05:39:45.000Z", "created_at": "2021-11-26T05:39:44.000Z", "updated_at": "2021-11-26T05:39:46.000Z", "action_id": "334", "action_name": "文本分隔", "error": null, "description": "对一整段文本进行分隔,分隔后的字段可以作为字段参数用于后续的步骤中,比如换行分隔,英文逗号分隔等", "action_type": "action", "app": null, "template": null }, { "id": 402, "key": null, "published_at": "2021-11-30T05:39:51.000Z", "created_at": "2021-11-30T05:39:49.000Z", "updated_at": "2021-11-30T06:11:18.000Z", "action_id": "477", "action_name": "当接收到邮件时", "error": null, "description": "当接收到邮件时流程触发", "action_type": "trigger", "app": null, "template": null }, { "id": 422, "key": null, "published_at": "2021-11-30T06:25:32.000Z", "created_at": "2021-11-30T06:25:29.000Z", "updated_at": "2021-11-30T06:25:32.000Z", "action_id": "501", "action_name": "通过文本分隔符拆分并循环执行", "error": null, "description": "当外部系统有查询任务时,通过循环执行汇总查询信息", "action_type": "action", "app": null, "template": null } ] [ { "id": 42, "title": "内容同步", "sort": 1, "scene": 10, "published_at": "2022-12-08T09:27:27.000Z", "created_at": "2022-12-08T09:27:26.000Z", "updated_at": "2022-12-12T08:29:32.000Z", "template": 1692, "seo": [] } ] [] 100+ 68 45 45 70
  • permission 1581 邮件接收到表格内容,将表格内数据同步到维格表 <p>邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。</p> zh-Hans 2022-09-20T03:45:33.000Z 2022-09-20T03:45:33.000Z 2023-03-07T04:50:00.000Z ay4830az 邮件触发当接收到还有表格内容的邮件时,通过使用文本处理删除空格,文本处理文本分隔,数组处理将文本转换为数组,循环执行通过文本分隔符拆分并循环执行,文本处理文本分隔,最终将数据逐一添加到维格表。 anyone 68ZG0OTgxCLy official pc1265 passed 谢晓鸣 ay4830az 谢晓鸣 [ { "desc": "向之前生成的邮件地址发送邮件,接收到邮件时同步数据并触发流程", "app_id": 125, "action_type": "1", "sort": "1", "action_id": 477, "note": null }, { "desc": "删除单词或字符间多余的空格", "app_id": 108, "action_type": "2", "sort": "2", "action_id": 1681, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "3", "action_id": 334, "note": null }, { "desc": "手动输入或继承变量生成数组", "app_id": 1000454, "action_type": "2", "sort": "4", "action_id": 1001703, "note": null }, { "desc": "通过文本字符对字段值进行拆分,拆分后的字段值将进行逐个执行", "app_id": 131, "action_type": "2", "sort": "5", "action_id": 501, "note": null }, { "desc": "将文本内容根据分隔方式(英文逗号,空格,换行,英文分号等)进行文本分隔", "app_id": 108, "action_type": "2", "sort": "6", "action_id": 334, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "7", "action_id": 364, "note": null } ] 2 false { "1": [], "2": [ { "key": "text", "label": "文本内容", "required": true, "multiples": false, "type": "text" }, { "key": "is_keep_one", "label": "是否保留1个空格", "required": false, "type": "string", "dropdown": true, "defaulttext": "1", "choices": [ { "key": "0", "label": "否" }, { "key": "1", "label": "是" } ] } ], "3": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "4": [], "5": [ { "dropdown": false, "help_txt": "循环执行可以将一组包含多个数据字段分隔开,并逐个推送到后续的流程步骤中,更多内容请查看<a href=\"https://www.jijyun.cn/help/detail/68\">(帮助中心)</a>", "required": false, "dynamic": false, "label": "帮助说明", "key": "help_instro", "multiples": false, "type": "copy" }, { "dropdown": false, "help_txt": "左边字段为字段的唯一识别ID,例如:key1,key2,key3,右边为待循环执行的字段值,可以插入变量值.", "required": true, "dynamic": false, "label": "循环执行字段设置", "key": "field_name", "multiples": false, "type": "dict" }, { "multiples": false, "defaulttext": ",", "dropdown": false, "help_txt": "分隔符用于分隔多个字段值以逐个推送到后续步骤", "label": "分隔符", "type": "string", "dynamic": false, "key": "separator", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "如果拆分字段值后有包含空格,是否自动移除空格,默认为是", "label": "是否自动移除空格", "type": "boolean", "dynamic": false, "key": "whether_trim", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例:10,如果不填写则循环全部,如果填写则循环指定次数", "label": "循环次数", "type": "int", "dynamic": false, "key": "loop_count", "required": false }, { "multiples": false, "defaulttext": false, "dropdown": false, "help_txt": "示例10,单位为秒。若不设置则不进行延迟", "label": "循环延迟时间", "type": "int", "dynamic": false, "key": "loop_delay", "required": false } ], "6": [ { "label": "需要分隔的文本内容", "key": "text", "help_txt": "请求选择要文本内容,分隔后将自动变成字段key与字段值的格式,以便后续步骤中使用", "required": true, "multiples": false, "type": "text" }, { "label": "选择分隔方式", "key": "separated", "help_txt": "设置以什么方式进行分隔,例如如果选择使用以英文逗号分隔则: \"字段1,字段2\"会被替换为\"key1:字段1, key2:字段2\"的格式,以便后续步骤中使用。", "type": "string", "required": true, "default": ",", "dropdown": true, "choices": [ { "key": ",", "label": "英文逗号分隔" }, { "key": " ", "label": "空格分隔" }, { "key": ";", "label": "英文分号分隔" }, { "key": "\n", "label": "换行分隔" } ] } ], "7": [ { "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": [] } ] } [] [] [ { "id": 86, "name": "邮件触发", "description": "<p>邮件触发是集简云的内置应用,通过创建集简云邮件账户,并向此邮件账户发送邮件,即可触发流程,并可以将邮件中的正文内容,邮件发送人,接收人,发送时间等信息作为变量在后续步骤中使用。</p>", "popular": 103, "published_at": "2021-10-25T05:36:52.000Z", "created_at": "2021-10-25T05:36:50.000Z", "updated_at": "2023-02-20T11:20:24.000Z", "app_id": "125", "category": "Jijianyun", "locale": "zh-Hans", "short_description": "发送邮件触发流程", "available": true, "appid": null, "website": null, "video": null, "videos": 97, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 3469, "name": "email-trigger.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "email_trigger_ec28d8c23c", "ext": ".svg", "mime": "image/svg+xml", "size": 1.32, "url": "/uploads/email_trigger_ec28d8c23c.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:43:54.000Z", "updated_at": "2022-04-21T08:43:55.000Z" } }, { "id": 71, "name": "文本处理", "description": "<p>文本处理是集简云内置应用,用于对文字内容的格式进行调整,以便在后续的流程中更好的使用。</p>", "popular": -13, "published_at": "2021-10-25T03:47:29.000Z", "created_at": "2021-10-25T03:47:27.000Z", "updated_at": "2022-04-21T08:49:18.000Z", "app_id": "108", "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": 3476, "name": "wenbenzhuanhuan.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "wenbenzhuanhuan_0a62076317", "ext": ".svg", "mime": "image/svg+xml", "size": 2.96, "url": "/uploads/wenbenzhuanhuan_0a62076317.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:49:15.000Z", "updated_at": "2022-04-21T08:49:15.000Z" } }, { "id": 631, "name": "数组处理", "description": "<p>数组处理是集简云的一款内置应用,用于将文本变量内容生成一组数组或者将一组数组转换成文本内容,以便用于后续的流程步骤中。</p>", "popular": -1, "published_at": "2022-08-25T05:54:52.000Z", "created_at": "2022-08-25T05:39:49.000Z", "updated_at": "2022-08-25T06:16:51.000Z", "app_id": "1000454", "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": 5862, "name": "shuzuchuli.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "shuzuchuli_114ea035f2", "ext": ".svg", "mime": "image/svg+xml", "size": 2.71, "url": "/uploads/shuzuchuli_114ea035f2.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-08-25T05:54:16.000Z", "updated_at": "2022-08-25T05:54:16.000Z" } }, { "id": 92, "name": "循环执行", "description": "<p>循环执行可以将步骤中的多条数据逐条推送到后续步骤中进行处理,一般常用于对查询搜索动作中获取的多个记录进行处理。</p>", "popular": -23, "published_at": "2021-10-25T05:41:11.000Z", "created_at": "2021-10-25T05:41:08.000Z", "updated_at": "2022-04-21T08:51:48.000Z", "app_id": "131", "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": 3481, "name": "loop.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "loop_1424a992b7", "ext": ".svg", "mime": "image/svg+xml", "size": 1.01, "url": "/uploads/loop_1424a992b7.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-04-21T08:51:46.000Z", "updated_at": "2022-04-21T08:51:46.000Z" } }, { "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": 6, "name": "个人效率", "locale": "zh-Hans", "published_at": "2022-05-30T07:29:23.000Z", "created_at": "2022-05-20T08:13:08.000Z", "updated_at": "2022-05-30T07:29:23.000Z", "sort": 6 } ] [ { "id": 3150, "key": null, "published_at": "2022-08-26T10:11:02.000Z", "created_at": "2022-08-26T10:11:02.000Z", "updated_at": "2022-08-26T10:11:02.000Z", "action_id": "1001703", "action_name": "将文本转换为数组", "error": null, "description": "手动输入或继承变量生成数组", "action_type": "action", "app": null, "template": null }, { "id": 1596, "key": null, "published_at": "2022-04-28T11:08:45.000Z", "created_at": "2022-04-28T11:08:45.000Z", "updated_at": "2022-04-28T11:08:45.000Z", "action_id": "1681", "action_name": "删除空格", "error": null, "description": "删除单词或字符间多余的空格", "action_type": "action", "app": null, "template": null }, { "id": 2716, "key": null, "published_at": "2022-07-25T08:33:20.000Z", "created_at": "2022-07-25T08:33:20.000Z", "updated_at": "2022-07-25T08:33:20.000Z", "action_id": "2431", "action_name": "添加记录", "error": null, "description": "向维格表中添加数据", "action_type": "action", "app": null, "template": null }, { "id": 226, "key": null, "published_at": "2021-11-26T05:39:45.000Z", "created_at": "2021-11-26T05:39:44.000Z", "updated_at": "2021-11-26T05:39:46.000Z", "action_id": "334", "action_name": "文本分隔", "error": null, "description": "对一整段文本进行分隔,分隔后的字段可以作为字段参数用于后续的步骤中,比如换行分隔,英文逗号分隔等", "action_type": "action", "app": null, "template": null }, { "id": 402, "key": null, "published_at": "2021-11-30T05:39:51.000Z", "created_at": "2021-11-30T05:39:49.000Z", "updated_at": "2021-11-30T06:11:18.000Z", "action_id": "477", "action_name": "当接收到邮件时", "error": null, "description": "当接收到邮件时流程触发", "action_type": "trigger", "app": null, "template": null }, { "id": 422, "key": null, "published_at": "2021-11-30T06:25:32.000Z", "created_at": "2021-11-30T06:25:29.000Z", "updated_at": "2021-11-30T06:25:32.000Z", "action_id": "501", "action_name": "通过文本分隔符拆分并循环执行", "error": null, "description": "当外部系统有查询任务时,通过循环执行汇总查询信息", "action_type": "action", "app": null, "template": null } ] [ { "id": 42, "title": "内容同步", "sort": 1, "scene": 10, "published_at": "2022-12-08T09:27:27.000Z", "created_at": "2022-12-08T09:27:26.000Z", "updated_at": "2022-12-12T08:29:32.000Z", "template": 1692, "seo": [] } ] [] 100+ 68 45 45 70