用表单外链来查询、修改数据,数据协同的速度变快了
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1. 应用场景</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">本案例适用于<span style="color: black;">经过</span>外链进行数据<span style="color: black;">查找</span>和修改的场景。<span style="color: black;">例如</span>团队<span style="color: black;">外边</span>人员的<span style="color: black;">基本</span>信息的收集和修改,常规<span style="color: black;">状况</span>下<span style="color: black;">能够</span><span style="color: black;">运用</span>公开链接的「数据外链」来进行数据的修改,但数据外链不适用于流程表单和<span style="color: black;">海量</span>数据修改的<span style="color: black;">状况</span>。本文将介绍一种的新<span style="color: black;">办法</span>,<span style="color: black;">能够</span>实现<span style="color: black;">外边</span>人员自主填写、<span style="color: black;">查找</span>和修改数据。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2. 设计思路</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">填写数据和修改数据分别在2个表单中进行,<span style="color: black;">而后</span><span style="color: black;">经过</span>设置智能助手来实现修改数据的同步。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">3. 新建表单</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>,打开简道云工作台,新建两张表单,一张数据上报表单,一张数据修改表单。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">【数据上报】:新建“数据上报”表单,并且开启表单填写链接和公开<span style="color: black;">查找</span>链接。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/956ab3e7ad70464daec2c433802c9b95~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=%2FGbK%2BsoriO9pdSTIUC8JvF8TS5o%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0fdafd34071b450d80082d36a864ae49~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=0%2F9CjDJieh7IKtiKg8TgpHpavIM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/d20fd24925bf426e814798c3981969ba~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=1AIQ%2BXHFqzsmxmzGZg5%2BQsB%2BXFs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">【数据修改】:新建“数据修改”表单,设置“姓名”用来输入<span style="color: black;">独一</span>值<span style="color: black;">而后</span><span style="color: black;">经过</span>关联<span style="color: black;">查找</span><span style="color: black;">查询</span>出原始数据进行展示,并且开启表单填写链接。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/e7c6c3a87ba44fb182b136af0e2c7ac4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=VzKQQlBUqDWqeEa4DhU%2BagfI5bk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/00fcdae6e35f41f3b68ae5db81ed5ef5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=g9YJpwLKRUh7lvO5POXtiYmN%2Bm4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在简道云工作台上再创建一个表单设计一个菜单导航栏。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">【菜单导航】:新建一个“菜单导航”的表单,用来<span style="color: black;">选取</span><span style="color: black;">详细</span>的操作,点击后实现界面<span style="color: black;">转</span>。添加1个“分割线”字段,里面<span style="color: black;">插进</span>超链接,填写、<span style="color: black;">查找</span>、修改对应的分别是“数据上报”的表单填写链接、“数据上报”的公开查询链接、“数据修改”的表单填写链接。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p9-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/40ad6941beb4463a95bf2de5ad8f0e28~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=Wm46PKfAyiR7T2TMc5hQ9nG6kSo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">为了避免成员在这个界面点击「提交」占用数据量,<span style="color: black;">能够</span>设置一个“提交校验辅助”字段,单行文本,设置<span style="color: black;">不可见</span>。提交校验设置为:</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">ISEMPTY(提交校验辅助)==</span><span style="color: black;">0</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/541bf48b5f814e888d35eda361613630~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=cag0m4ag5L%2BUDbYCcGgwP9bn0Zg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">4. 智能助手设置</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">设置一个智能助手,当数据修改表提交数据后,将同步修改数据上报表中的原始数据。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/5d478ccc65f34cdca2fe1f3dc8a2456b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1729524910&x-signature=Ovy7EuTOXdtLzz1t4hM9n3p9cds%3D" style="width: 50%; margin-bottom: 20px;"></div>
你的见解独到,让我受益匪浅,非常感谢。
页:
[1]