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

    教学视频

    案例文章

推荐的的流程模板
请稍后...
自定义您的业务流程
选择的触发与执行动作,建立自动化的业务流程。
当这个情况发生时触发动作
  • mysql有数据新增时
    当MySQL数据库中有新数据添加时触发流程并同步数据
  • mysql有符合条件的数据新增时
    当有符合自定义SQL命令搜索的数据新增时触发流程并同步数据
  • 当有满足条件的数据新增或更新时
    当有满足条件的数据新增或更新时同步数据并触发流程
  • 当有数据更新时(按自定义字段排序)
    当有数据更新时同步数据并触发流程
做这件事情执行动作
  • 新增数据到指定数据表
    添加数据到指定MySQL数据表中
  • 更新指定数据表中的数据
    修改MySQL数据表中的指定数据
  • 查询指定数据表中的数据
    查询MySQL数据表中的数据信息
  • 批量查询指定数据表中的数据
    批量查询MySQL数据表中的数据信息
  • 执行SQL语句
    在数据库中执行自定义的SQL语句
  • 添加记录
    向维格表中添加数据
  • 修改数据
    修改维格表的数据
  • 上传附件
    像维格表中上传附件
  • 查询数据
    查询维格表中的数据
  • 公式搜索数据
    公式搜索数据
开始创建吧
立即创建使用
相关文章
查看更多>
  • week 100+
  • month 100+
  • quarter 35
  • year 35
  • user_name 冯寻
  • used_count 2
  • shared_tem_count 50
  • Code 1644 MySql新增数据同步到维格表 <p>员工需要把数据库中的订单录入到维格表中时,我们可以用这个流程当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间</p> zh-Hans 2022-09-28T06:27:08.000Z 2022-09-28T06:27:08.000Z 2023-01-31T03:00:21.000Z kn6409vk MySql当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间 anyone u8GxIp18WE1C official pc1265 passed 冯寻 fi4139zv 冯寻 [ { "desc": "当MySQL数据库中有新数据添加时触发流程并同步数据", "app_id": 59, "action_type": "1", "sort": "1", "action_id": 196, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "2", "action_id": 364, "note": null } ] 2 false 1 { "1": [ { "key": "key_field", "label": "选择唯一识别字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "唯一识别字段用于排重数据,例如ID字段等" }, { "key": "sort_field", "label": "排序字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "以此字段排序判断是否由新增或者修改,支持数值和日期字段,数值字段由大到排序,日期字段由近到远排序。" } ], "2": [ { "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": 23, "name": "MySql", "description": "<p>MySQL是使用最常用的数据库管理语言之一。通过添加MySQL应用,企业可以将数据流程中的数据存储在MySQL中由于数据分析或者程序调用与开发,此外MySQL也可以用于做为流程触发条件自动触发数据流程。</p>", "popular": 179, "published_at": "2021-10-25T03:00:15.000Z", "created_at": "2021-10-25T03:00:13.000Z", "updated_at": "2023-01-28T09:04:07.000Z", "app_id": "59", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库系统", "available": true, "appid": null, "website": "https://www.mysql.com/", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1843, "name": "Mysql.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Mysql_0a25c1f2b0", "ext": ".svg", "mime": "image/svg+xml", "size": 55.86, "url": "/uploads/Mysql_0a25c1f2b0.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:57:10.000Z", "updated_at": "2022-01-26T02:57:10.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": 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": 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": 11, "name": "产品研发", "locale": "zh-Hans", "published_at": "2022-06-01T03:32:31.000Z", "created_at": "2022-06-01T03:31:22.000Z", "updated_at": "2022-06-01T03:32:31.000Z", "sort": 10 } ] [ { "id": 300, "key": null, "published_at": "2021-11-29T09:03:43.000Z", "created_at": "2021-11-29T09:03:41.000Z", "updated_at": "2021-11-29T09:03:43.000Z", "action_id": "196", "action_name": "mysql有数据新增时", "error": null, "description": "当MySQL数据库中有新数据添加时触发流程并同步数据", "action_type": "trigger", "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": 49, "title": "数据库同步", "sort": 4, "scene": 11, "published_at": "2022-12-08T09:29:07.000Z", "created_at": "2022-12-08T09:29:06.000Z", "updated_at": "2022-12-14T03:27:34.000Z", "template": 765, "seo": [] } ] [] 100+ 100+ 35 35 50
  • Msg 1644 MySql新增数据同步到维格表 <p>员工需要把数据库中的订单录入到维格表中时,我们可以用这个流程当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间</p> zh-Hans 2022-09-28T06:27:08.000Z 2022-09-28T06:27:08.000Z 2023-01-31T03:00:21.000Z kn6409vk MySql当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间 anyone u8GxIp18WE1C official pc1265 passed 冯寻 fi4139zv 冯寻 [ { "desc": "当MySQL数据库中有新数据添加时触发流程并同步数据", "app_id": 59, "action_type": "1", "sort": "1", "action_id": 196, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "2", "action_id": 364, "note": null } ] 2 false 1 { "1": [ { "key": "key_field", "label": "选择唯一识别字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "唯一识别字段用于排重数据,例如ID字段等" }, { "key": "sort_field", "label": "排序字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "以此字段排序判断是否由新增或者修改,支持数值和日期字段,数值字段由大到排序,日期字段由近到远排序。" } ], "2": [ { "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": 23, "name": "MySql", "description": "<p>MySQL是使用最常用的数据库管理语言之一。通过添加MySQL应用,企业可以将数据流程中的数据存储在MySQL中由于数据分析或者程序调用与开发,此外MySQL也可以用于做为流程触发条件自动触发数据流程。</p>", "popular": 179, "published_at": "2021-10-25T03:00:15.000Z", "created_at": "2021-10-25T03:00:13.000Z", "updated_at": "2023-01-28T09:04:07.000Z", "app_id": "59", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库系统", "available": true, "appid": null, "website": "https://www.mysql.com/", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1843, "name": "Mysql.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Mysql_0a25c1f2b0", "ext": ".svg", "mime": "image/svg+xml", "size": 55.86, "url": "/uploads/Mysql_0a25c1f2b0.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:57:10.000Z", "updated_at": "2022-01-26T02:57:10.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": 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": 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": 11, "name": "产品研发", "locale": "zh-Hans", "published_at": "2022-06-01T03:32:31.000Z", "created_at": "2022-06-01T03:31:22.000Z", "updated_at": "2022-06-01T03:32:31.000Z", "sort": 10 } ] [ { "id": 300, "key": null, "published_at": "2021-11-29T09:03:43.000Z", "created_at": "2021-11-29T09:03:41.000Z", "updated_at": "2021-11-29T09:03:43.000Z", "action_id": "196", "action_name": "mysql有数据新增时", "error": null, "description": "当MySQL数据库中有新数据添加时触发流程并同步数据", "action_type": "trigger", "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": 49, "title": "数据库同步", "sort": 4, "scene": 11, "published_at": "2022-12-08T09:29:07.000Z", "created_at": "2022-12-08T09:29:06.000Z", "updated_at": "2022-12-14T03:27:34.000Z", "template": 765, "seo": [] } ] [] 100+ 100+ 35 35 50
  • Data 1644 MySql新增数据同步到维格表 <p>员工需要把数据库中的订单录入到维格表中时,我们可以用这个流程当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间</p> zh-Hans 2022-09-28T06:27:08.000Z 2022-09-28T06:27:08.000Z 2023-01-31T03:00:21.000Z kn6409vk MySql当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间 anyone u8GxIp18WE1C official pc1265 passed 冯寻 fi4139zv 冯寻 [ { "desc": "当MySQL数据库中有新数据添加时触发流程并同步数据", "app_id": 59, "action_type": "1", "sort": "1", "action_id": 196, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "2", "action_id": 364, "note": null } ] 2 false 1 { "1": [ { "key": "key_field", "label": "选择唯一识别字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "唯一识别字段用于排重数据,例如ID字段等" }, { "key": "sort_field", "label": "排序字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "以此字段排序判断是否由新增或者修改,支持数值和日期字段,数值字段由大到排序,日期字段由近到远排序。" } ], "2": [ { "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": 23, "name": "MySql", "description": "<p>MySQL是使用最常用的数据库管理语言之一。通过添加MySQL应用,企业可以将数据流程中的数据存储在MySQL中由于数据分析或者程序调用与开发,此外MySQL也可以用于做为流程触发条件自动触发数据流程。</p>", "popular": 179, "published_at": "2021-10-25T03:00:15.000Z", "created_at": "2021-10-25T03:00:13.000Z", "updated_at": "2023-01-28T09:04:07.000Z", "app_id": "59", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库系统", "available": true, "appid": null, "website": "https://www.mysql.com/", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1843, "name": "Mysql.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Mysql_0a25c1f2b0", "ext": ".svg", "mime": "image/svg+xml", "size": 55.86, "url": "/uploads/Mysql_0a25c1f2b0.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:57:10.000Z", "updated_at": "2022-01-26T02:57:10.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": 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": 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": 11, "name": "产品研发", "locale": "zh-Hans", "published_at": "2022-06-01T03:32:31.000Z", "created_at": "2022-06-01T03:31:22.000Z", "updated_at": "2022-06-01T03:32:31.000Z", "sort": 10 } ] [ { "id": 300, "key": null, "published_at": "2021-11-29T09:03:43.000Z", "created_at": "2021-11-29T09:03:41.000Z", "updated_at": "2021-11-29T09:03:43.000Z", "action_id": "196", "action_name": "mysql有数据新增时", "error": null, "description": "当MySQL数据库中有新数据添加时触发流程并同步数据", "action_type": "trigger", "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": 49, "title": "数据库同步", "sort": 4, "scene": 11, "published_at": "2022-12-08T09:29:07.000Z", "created_at": "2022-12-08T09:29:06.000Z", "updated_at": "2022-12-14T03:27:34.000Z", "template": 765, "seo": [] } ] [] 100+ 100+ 35 35 50
  • permission 1644 MySql新增数据同步到维格表 <p>员工需要把数据库中的订单录入到维格表中时,我们可以用这个流程当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间</p> zh-Hans 2022-09-28T06:27:08.000Z 2022-09-28T06:27:08.000Z 2023-01-31T03:00:21.000Z kn6409vk MySql当mysql数据库表中有订单数据新增时,那么自动写入维格表同步数据,可以节省员工手动录入的时间 anyone u8GxIp18WE1C official pc1265 passed 冯寻 fi4139zv 冯寻 [ { "desc": "当MySQL数据库中有新数据添加时触发流程并同步数据", "app_id": 59, "action_type": "1", "sort": "1", "action_id": 196, "note": null }, { "desc": "向维格表中添加数据", "app_id": 310, "action_type": "2", "sort": "2", "action_id": 364, "note": null } ] 2 false 1 { "1": [ { "key": "key_field", "label": "选择唯一识别字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "唯一识别字段用于排重数据,例如ID字段等" }, { "key": "sort_field", "label": "排序字段", "dropdown": true, "required": true, "choices": [ { "label": "updatetime", "key": "updatetime" }, { "label": "sn", "key": "sn" }, { "label": "liushuihao", "key": "liushuihao" }, { "label": "chehao", "key": "chehao" }, { "label": "weightype", "key": "weightype" }, { "label": "fahuodanwei", "key": "fahuodanwei" }, { "label": "fahuodanweibianma", "key": "fahuodanweibianma" }, { "label": "shouhuodanwei", "key": "shouhuodanwei" }, { "label": "shouhuodanweibianma", "key": "shouhuodanweibianma" }, { "label": "huoming", "key": "huoming" }, { "label": "huopinbianma", "key": "huopinbianma" }, { "label": "guige", "key": "guige" }, { "label": "maozhong", "key": "maozhong" }, { "label": "pizhong", "key": "pizhong" }, { "label": "jingzhong", "key": "jingzhong" }, { "label": "kouzhong", "key": "kouzhong" }, { "label": "shizhong", "key": "shizhong" }, { "label": "danjia", "key": "danjia" }, { "label": "amount", "key": "amount" }, { "label": "zhefangxishu", "key": "zhefangxishu" }, { "label": "fangliang", "key": "fangliang" }, { "label": "guobangfei", "key": "guobangfei" }, { "label": "maozhongsibangyuan", "key": "maozhongsibangyuan" }, { "label": "pizhongsibangyuan", "key": "pizhongsibangyuan" }, { "label": "maozhongbanghao", "key": "maozhongbanghao" }, { "label": "pizhongbanghao", "key": "pizhongbanghao" }, { "label": "pizhongshijian", "key": "pizhongshijian" }, { "label": "maozhongshijian", "key": "maozhongshijian" }, { "label": "yiciguobangshijian", "key": "yiciguobangshijian" }, { "label": "erciguobangshijian", "key": "erciguobangshijian" }, { "label": "gengxinren", "key": "gengxinren" }, { "label": "gengxinshijian", "key": "gengxinshijian" }, { "label": "noteinf", "key": "noteinf" }, { "label": "printcount", "key": "printcount" }, { "label": "uploadflag1", "key": "uploadflag1" }, { "label": "note1", "key": "note1" }, { "label": "note2", "key": "note2" }, { "label": "note3", "key": "note3" }, { "label": "note4", "key": "note4" }, { "label": "note5", "key": "note5" }, { "label": "note6", "key": "note6" }, { "label": "note7", "key": "note7" }, { "label": "note8", "key": "note8" }, { "label": "note9", "key": "note9" }, { "label": "note10", "key": "note10" }, { "label": "note11", "key": "note11" }, { "label": "note12", "key": "note12" }, { "label": "note13", "key": "note13" }, { "label": "note14", "key": "note14" }, { "label": "note15", "key": "note15" }, { "label": "note16", "key": "note16" }, { "label": "note17", "key": "note17" } ], "help_txt": "以此字段排序判断是否由新增或者修改,支持数值和日期字段,数值字段由大到排序,日期字段由近到远排序。" } ], "2": [ { "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": 23, "name": "MySql", "description": "<p>MySQL是使用最常用的数据库管理语言之一。通过添加MySQL应用,企业可以将数据流程中的数据存储在MySQL中由于数据分析或者程序调用与开发,此外MySQL也可以用于做为流程触发条件自动触发数据流程。</p>", "popular": 179, "published_at": "2021-10-25T03:00:15.000Z", "created_at": "2021-10-25T03:00:13.000Z", "updated_at": "2023-01-28T09:04:07.000Z", "app_id": "59", "category": "Developer", "locale": "zh-Hans", "short_description": "数据库系统", "available": true, "appid": null, "website": "https://www.mysql.com/", "video": null, "videos": null, "app_version": "1.0.0", "key_words": null, "qr_code": null, "qr": null, "sharelink": null, "seo": null, "icon": { "id": 1843, "name": "Mysql.svg", "alternativeText": "", "caption": "", "width": 50, "height": 50, "formats": null, "hash": "Mysql_0a25c1f2b0", "ext": ".svg", "mime": "image/svg+xml", "size": 55.86, "url": "/uploads/Mysql_0a25c1f2b0.svg", "previewUrl": null, "provider": "local", "provider_metadata": null, "created_at": "2022-01-26T02:57:10.000Z", "updated_at": "2022-01-26T02:57:10.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": 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": 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": 11, "name": "产品研发", "locale": "zh-Hans", "published_at": "2022-06-01T03:32:31.000Z", "created_at": "2022-06-01T03:31:22.000Z", "updated_at": "2022-06-01T03:32:31.000Z", "sort": 10 } ] [ { "id": 300, "key": null, "published_at": "2021-11-29T09:03:43.000Z", "created_at": "2021-11-29T09:03:41.000Z", "updated_at": "2021-11-29T09:03:43.000Z", "action_id": "196", "action_name": "mysql有数据新增时", "error": null, "description": "当MySQL数据库中有新数据添加时触发流程并同步数据", "action_type": "trigger", "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": 49, "title": "数据库同步", "sort": 4, "scene": 11, "published_at": "2022-12-08T09:29:07.000Z", "created_at": "2022-12-08T09:29:06.000Z", "updated_at": "2022-12-14T03:27:34.000Z", "template": 765, "seo": [] } ] [] 100+ 100+ 35 35 50