# 同じアプリ内にサブテーブル⇒サブテーブルでコピーする

**URL:** <https://community.cybozu.dev/t/topic/5259>\
**Category:** kintone 開発相談\
**Created:** [2021 年 9 月 10 日午前 7:10 UTC](https://community.cybozu.dev/t/topic/5259 "2021-09-10T07:10:49Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Legacy\_Account2783](https://avatars.discourse-cdn.com/v4/letter/l/f475e1/32.png) [@Legacy\_Account2783](https://community.cybozu.dev/u/Legacy_Account2783)\
**Post date:** [2021 年 9 月 10 日午前 7:10 UTC](https://community.cybozu.dev/t/topic/5259/1 "2021-09-10T07:10:49Z")

</div>

お世話になります。

1つのアプリに入力用のテーブルがあります。  
レコードの保存時に、テーブル行数に合わせ同じアプリ内の別テーブルに、  
その内容をコピーしたいと考えております。  
下記コードで作成してみたのですが、うまく動きません。

エラーコードは  
Uncaught TypeError: Cannot read properties of undefined (reading ‘value’)  
が出ます。

また入力用のTable1の中身が変わった場合も、Table2、Table3も同様に変更される  
にしたいと考えております。どのようにすべきでしょうか。  
アドバイス頂きたく、よろしくお願いいたします。

```
(function() {
"use strict";
var event1 = [
'app.record.create.submit',
'app.record.create.change.Table1',
'app.record.edit.submit',
'app.record.edit.change.Table1'
];
kintone.events.on(event1, function(event) {
var record = event.record;
var rowNo = record.Table1.value.length;
record.Table1No.value = rowNo;
return event;
});

var event2 = [
'app.record.create.submit',
'app.record.edit.submit',
];
kintone.events.on(event2, function(event) {
var record = event.record;

record.Table2.value = [];
for (var i = 0; i < 3; i++){
record.Table2.value.push({
"value": {
"No2":{
"type":"SINGLE_LINE_TEXT",
"value":record.Table1.value[i].value.No1.value
},
"Text2":{
"type":"SINGLE_LINE_TEXT",
"value":record.Table1.value[i].value.Text1.value
}
}
});
}

record.Table3.value = [];
for (var j = 4;j < 7; j++){
record.Table3.value.push({
"value": {
"No3":{
"type":"SINGLE_LINE_TEXT",
"value":record.Table1.value[j].value.No1.value
},
"Text3":{
"type":"SINGLE_LINE_TEXT",
"value":record.Table1.value[j].value.Text1.value
}
}
});
}
return event;
});
})();

```

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2783](https://avatars.discourse-cdn.com/v4/letter/l/f475e1/32.png) [@Legacy\_Account2783](https://community.cybozu.dev/u/Legacy_Account2783)\
**Post date:** [2021 年 9 月 10 日午前 8:31 UTC](https://community.cybozu.dev/t/topic/5259/2 "2021-09-10T08:31:26Z")

</div>

すみません、解決できてしまったのでコード貼り付けておきます。

更新も何も常に[]で空になるので更新も問題はなさそうです。

```
var event2 = [
'app.record.create.submit',
'app.record.edit.submit',
];
kintone.events.on(event2, function(event) {
var record = event.record;
var rowNo = record.Table1.value.length;
var table1 = record.Table1.value;

record.Table2.value = [];
record.Table3.value = [];
if (rowNo<4){
for (var i = 0; i < rowNo; i++){
var No1 = record.Table1.value[i].value.No1.value;
var Text1 = record.Table1.value[i].value.Text1.value;
record.Table2.value.push({
"value": {
"No2":{
"type":"SINGLE_LINE_TEXT",
"value":No1
},
"Text2":{
"type":"SINGLE_LINE_TEXT",
"value":Text1
}
}
});
}
} else if (rowNo<7){
for (var j = 0; j < 3; j++){
var No2 = record.Table1.value[j].value.No1.value;
var Text2 = record.Table1.value[j].value.Text1.value;
record.Table2.value.push({
"value": {
"No2":{
"type":"SINGLE_LINE_TEXT",
"value":No2
},
"Text2":{
"type":"SINGLE_LINE_TEXT",
"value":Text2
}
}
});
}
for (var k = 3;k < rowNo; k++){
var No3 = record.Table1.value[k].value.No1.value;
var Text3 = record.Table1.value[k].value.Text1.value;
record.Table3.value.push({
"value": {
"No3":{
"type":"SINGLE_LINE_TEXT",
"value":No3
},
"Text3":{
"type":"SINGLE_LINE_TEXT",
"value":Text3
}
}
});
}
}
return event;
});

```

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2651](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Legacy\_Account2651](https://community.cybozu.dev/u/Legacy_Account2651)\
**Post date:** [2022 年 5 月 5 日午前 5:11 UTC](https://community.cybozu.dev/t/topic/5259/3 "2022-05-05T05:11:57Z")

</div>

こんにちは。

ご記入通りを試しましたら、コピーができませんでした。

event1が必要でしょうか。

教えて頂ければ、幸甚です。

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2783](https://avatars.discourse-cdn.com/v4/letter/l/f475e1/32.png) [@Legacy\_Account2783](https://community.cybozu.dev/u/Legacy_Account2783)\
**Post date:** [2022 年 5 月 9 日午前 12:54 UTC](https://community.cybozu.dev/t/topic/5259/4 "2022-05-09T00:54:44Z")

</div>

TL様

こんにちは

event1は必要ないです。

event1では、Table1Noというフィールドコードに

Table1の行数を入れているだけですので…

&nbsp;

event2 ⇒ eventになおしてコード作り直しました。

尚テーブル内のNo1(2,3)、Text1(2,3)どちらも文字列(1行)です。

```
(function() {
    "use strict";
    
    var event = [
        'app.record.create.submit',
        'app.record.edit.submit',
        ];
    kintone.events.on(event, function(event) {
        var record = event.record;
        var rowNo = record.Table1.value.length;
        var table1 = record.Table1.value;
        
        record.Table2.value = [];
        record.Table3.value = [];
        if (rowNo<4){
            for (var i = 0; i < rowNo; i++){
                var No1 = record.Table1.value[i].value.No1.value;
                var Text1 = record.Table1.value[i].value.Text1.value;
                record.Table2.value.push({
                    "value": {
                        "No2":{
                            "type":"SINGLE_LINE_TEXT",
                            "value":No1
                        },
                        "Text2":{
                            "type":"SINGLE_LINE_TEXT",
                            "value":Text1
                        }
                    }
                });
            }
        } else if (rowNo<7){
            for (var j = 0; j < 3; j++){
                var No2 = record.Table1.value[j].value.No1.value;
                var Text2 = record.Table1.value[j].value.Text1.value;
                record.Table2.value.push({
                    "value": {
                        "No2":{
                            "type":"SINGLE_LINE_TEXT",
                            "value":No2
                        },
                        "Text2":{
                            "type":"SINGLE_LINE_TEXT",
                            "value":Text2
                        }
                    }
                });
            }
            for (var k = 3;k < rowNo; k++){
                var No3 = record.Table1.value[k].value.No1.value;
                var Text3 = record.Table1.value[k].value.Text1.value;
                record.Table3.value.push({
                    "value": {
                        "No3":{
                            "type":"SINGLE_LINE_TEXT",
                            "value":No3
                        },
                        "Text3":{
                            "type":"SINGLE_LINE_TEXT",
                            "value":Text3
                        }
                    }
                });
            }
        }
        return event;
   });
})();

```

&nbsp;

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2651](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Legacy\_Account2651](https://community.cybozu.dev/u/Legacy_Account2651)\
**Post date:** [2022 年 5 月 11 日午前 12:46 UTC](https://community.cybozu.dev/t/topic/5259/5 "2022-05-11T00:46:34Z")

</div>

Tofu様

成功しました！

ご指導、ありがとうございます。

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2783](https://avatars.discourse-cdn.com/v4/letter/l/f475e1/32.png) [@Legacy\_Account2783](https://community.cybozu.dev/u/Legacy_Account2783)\
**Post date:** [2022 年 5 月 11 日午前 12:52 UTC](https://community.cybozu.dev/t/topic/5259/6 "2022-05-11T00:52:04Z")

</div>

TL様

うまくいったようで、良かったです。

初めて自分のコードを使ってもらったので、出来なかったらどうしようと

思っておりました。安心しました。

それでは。

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2651](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Legacy\_Account2651](https://community.cybozu.dev/u/Legacy_Account2651)\
**Post date:** [2022 年 5 月 11 日午前 3:56 UTC](https://community.cybozu.dev/t/topic/5259/7 "2022-05-11T03:56:08Z")

</div>

Tofu様

使わせて頂き、本当に感謝しています。

少し欲を出して、３列があるのテーブルをコピーしょうと思い、Table1に"Text\_1",Table2に"Text\_2",Table1に"Text\_3"を追加し、コードは下記のように書き換えしましたが、うまくいきませんでした。コードの書き換え方は間違えっていますか。

ご教授頂けませんでしょうか。

(function() {  
&nbsp; &nbsp; “use strict”;  
&nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; var event = [  
&nbsp; &nbsp; &nbsp; &nbsp; ‘app.record.create.submit’,  
&nbsp; &nbsp; &nbsp; &nbsp; ‘app.record.edit.submit’,  
&nbsp; &nbsp; &nbsp; &nbsp; ];  
&nbsp; &nbsp; kintone.events.on(event, function(event) {  
&nbsp; &nbsp; &nbsp; &nbsp; var record = event.record;  
&nbsp; &nbsp; &nbsp; &nbsp; var rowNo = record.Table1.value.length;  
&nbsp; &nbsp; &nbsp; &nbsp; var table1 = record.Table1.value;  
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; record.Table2.value = [];  
&nbsp; &nbsp; &nbsp; &nbsp; record.Table3.value = [];  
&nbsp; &nbsp; &nbsp; &nbsp; if (rowNo\<4){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (var i = 0; i \< rowNo; i++){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var No1 = record.Table1.value[i].value.No1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Text1 = record.Table1.value[i].value.Text1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; var Text\_1 = record.Table1.value[i].value.Text\_1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record.Table2.value.push({  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “No2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:No1  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text1  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text\_2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text\_1  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; } else if (rowNo\<7){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (var j = 0; j \< 3; j++){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var No2 = record.Table1.value[j].value.No1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Text2 = record.Table1.value[j].value.Text1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; var Text\_2 = record.Table1.value[j].value.Text\_1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record.Table2.value.push({  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “No2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:No2  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text2  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text\_2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text\_2  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (var k = 3;k \< rowNo; k++){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var No3 = record.Table1.value[k].value.No1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Text3 = record.Table1.value[k].value.Text1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; var Text\_3 = record.Table1.value[k].value.Text\_1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record.Table3.value.push({  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “No3”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:No3  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text3”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text3  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text\_3”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text\_3  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; return event;  
&nbsp; &nbsp;});  
})();

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2783](https://avatars.discourse-cdn.com/v4/letter/l/f475e1/32.png) [@Legacy\_Account2783](https://community.cybozu.dev/u/Legacy_Account2783)\
**Post date:** [2022 年 5 月 11 日午前 5:51 UTC](https://community.cybozu.dev/t/topic/5259/8 "2022-05-11T05:51:28Z")

</div>

TL様

拝見しましたが、valueを定義していないからではないかと思います。

for (var i = 0; i \< rowNo; i++){  
&nbsp; &nbsp; var No1 = record.Table1.value[i].value.No1.value;  
&nbsp; &nbsp; var Text1 = record.Table1.value[i].value.Text1.value;  
の下に  
var Text\_1 = record.Table1.value[i].value.Text\_1.value;  
を追加すればいいかと思います。追加で、  
&nbsp; &nbsp; var Text\_2 = record.Table1.value[j].value.Text\_1.value;  
&nbsp; &nbsp; var Text\_3 = record.Table1.value[k].value.Text\_1.value;  
もそれぞれの下に加えれば問題ないと思います。

---

<div class="post-metadata">

**Author:** ![Legacy\_Account2651](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Legacy\_Account2651](https://community.cybozu.dev/u/Legacy_Account2651)\
**Post date:** [2022 年 5 月 11 日午前 6:46 UTC](https://community.cybozu.dev/t/topic/5259/9 "2022-05-11T06:46:40Z")

</div>

ご指摘通り、下記のようにしました。成功でした。ありがとうございました！

(function() {  
&nbsp; &nbsp; “use strict”;  
&nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; var event = [  
&nbsp; &nbsp; &nbsp; &nbsp; ‘app.record.create.submit’,  
&nbsp; &nbsp; &nbsp; &nbsp; ‘app.record.edit.submit’,  
&nbsp; &nbsp; &nbsp; &nbsp; ];  
&nbsp; &nbsp; kintone.events.on(event, function(event) {  
&nbsp; &nbsp; &nbsp; &nbsp; var record = event.record;  
&nbsp; &nbsp; &nbsp; &nbsp; var rowNo = record.Table1.value.length;  
&nbsp; &nbsp; &nbsp; &nbsp; var table1 = record.Table1.value;  
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;  
&nbsp; &nbsp; &nbsp; &nbsp; record.Table2.value = [];  
&nbsp; &nbsp; &nbsp; &nbsp; record.Table3.value = [];  
&nbsp; &nbsp; &nbsp; &nbsp; if (rowNo\<4){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (var i = 0; i \< rowNo; i++){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var No1 = record.Table1.value[i].value.No1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Text1 = record.Table1.value[i].value.Text1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; var Text\_1 = record.Table1.value[i].value.Text\_1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record.Table2.value.push({  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “No2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:No1  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text1  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text\_2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text\_1  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; } else if (rowNo\<7){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (var j = 0; j \< 3; j++){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var No2 = record.Table1.value[j].value.No1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Text2 = record.Table1.value[j].value.Text1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; var Text\_2 = record.Table1.value[j].value.Text\_1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record.Table2.value.push({  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “No2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:No2  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text2  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text\_2”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text\_2  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (var k = 3;k \< rowNo; k++){  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var No3 = record.Table1.value[k].value.No1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var Text3 = record.Table1.value[k].value.Text1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; var Text\_3 = record.Table1.value[k].value.Text\_1.value;  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; record.Table3.value.push({  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”: {  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “No3”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:No3  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text3”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text3  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “Text\_3”:{  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “type”:“SINGLE\_LINE\_TEXT”,  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “value”:Text\_3  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });  
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; }  
&nbsp; &nbsp; &nbsp; &nbsp; return event;  
&nbsp; &nbsp;});  
})();

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/cybozu/original/1X/d5c841c3c5a6cb66eed514001c1b45147c9e1f4f.png) [@system](https://community.cybozu.dev/u/system)\
**Post date:** [2025 年 8 月 20 日午前 5:08 UTC](https://community.cybozu.dev/t/topic/5259/10 "2025-08-20T05:08:20Z")

</div>

このトピックはベストアンサーに選ばれた返信から 3 日が経過したので自動的にクローズされました。新たに返信することはできません。