Multi-select fill sub-table in associated form

JS 动作面板 - 前端代码开放 | 钉钉宜搭·帮助中心

能力免费版轻享版专业版专属版页面JS代码不支持不支持支持支持1. 功能概述用户可以通过宜搭中的「动作面板」去写 JS 代码，从而实现自己的业务逻辑或逻辑判断。通过动作面板，您可以「更加方便的组织和复用代码」、「实现复杂交互」。JS 面板注意：通过JS面板编写的逻辑一般情况下是不会对历史数据生效...

https://docs.aliwork.com/docs/yida_support/lbtl0t/ocmxyv

This case is from Peng, a three-party developer 」

1. Usage scenarios

This example describes how to implement multi-select padding subtables for associated forms on the YIDA forms page.

2. Implement functions

2.1. Create payment order page

2.2. Create form page

2.3. Configure associated form components

Note that the multi-select mode of the associated form is enabled.

2.4. Function configuration

2.4.1. Configure a data source

Reference documents:Query Form instance details based on form instance ID

`/${window.pageConfig.appType || window.g_config.appKey}/v1/form/getFormDataById.json`

The interface configuration is as follows:

2.4.2. Associate form components with the following events

export async function onAssociationFormChange({ value }) {
  if (value.length) {
    const batchFetchResult = []; // 请求结果
    const failedInstId = []; // 请求失败的实例ID
    const batchFetchLoading = this.utils.toast({
      title: `处理中，请不要关闭浏览器，预计需要 ${value.length / 5} 秒`,
      type: 'loading'
    });
    for (let i = 0; i < value.length; i++) {
      const delay = i === 0 ? 0 : 200;
      const formInstId = value[i].instanceId;
      await new Promise((resolve => {
        // 注意节流，每次请求间隔 200 ms
        setTimeout(async () => {
          await this.dataSourceMap.getDataById.load({
            // 数据源参数
            formInstId,
          }).then(res => {
            // 处理每次返回的结果
            if (!res) { return };
            batchFetchResult.push(res || {});
          }).catch(error => {
            // 处理错误，收集错误的实例ID
            failedInstId.push(formInstId);
          });
          resolve();
        }, delay);
      }));
    };
    batchFetchLoading();
    if (failedInstId.length > 0) {
      let content = (
        <div>
          {failedInstId.map((instId) => {
            return <p>{instId}</p>
          })}
        </div>
      );
      this.utils.dialog({
        method: 'alert',
        title: `处理完成，失败 ${failedInstId.length} 条`,
        content,
        onOk: () => { },
        onCancel: () => { },
      });
    };
    // 上述代码均不需要修改
    // 下述代码按照实际情况修改字段映射即可
    const tableData = batchFetchResult.map(item => {
      const { formData = {} } = item;
      return {
        textField_l9pa49io: formData.textField_l9p9znox || '', // 付款说明
        numberField_l9pa49ip: formData.numberField_l9p9znoy || 0 // 付款金额
      }
    });
    this.$('tableField_l9pa49in').setValue(tableData);
  } else {
    // 初始化子表单
    this.$('tableField_l9pa49in').setValue([]);
  };
}

2.4.3. Bind the following events to the subform component

Modify the unique identifier according to the actual situation. If you do not need this function, you can ignore this step.

export function onTableFieldChange({ value, actionType }) {
  if (actionType === "setValue") {
    const sum = value.reduce((partialSum, item) => partialSum + item.numberField_l9pa49ip, 0);
    this.$('numberField_l9pa49iq').setValue(sum);
  };
}

3. Effect

4. Try it online

示例中心 | 开发者赋能平台

AI智能体时代，全新宜搭。业务创新，一搭就行。

https://www.aliwork.com/o/coc?tplUuid=TPL_TG002FTSTE8Q0SGHD6SQ&from=yuque_subject

5. Upgrade the associated form function

2023.10.30 版本更新-基础产品力升级 | 钉钉宜搭·帮助中心

能力发布新增：子表单默认值整体支持数据联动新增：关联表单数据填充升级支持设置子表筛选条件及批量添加数据新增：关联表单数据源支持子表且支持子表填充新增：自动化更新流程数据新增：导入/导出整体功能升级数据导入链路优化及Excel模板更新适配更多高频场景的导入组件支持多种导出数据展示方式及批量查看图...

https://docs.aliwork.com/docs/yida_updates/augw2gdkfco8glqq#mZa14