1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

/*
 * Autofill number sample
 * Copyright (c) 2025 Cybozu
 *
 * Licensed under the MIT License
 * https://opensource.org/license/mit/
 */

(() => {
  'use strict';
  // レコード追加、編集画面の表示前処理
  const eventsShow = ['app.record.create.show', 'app.record.edit.show', 'app.record.index.edit.show'];
  kintone.events.on(eventsShow, (event) => {
    const record = event.record;
    if (('app.record.create.show').indexOf(event.type) >= 0) {
      record.見積番号.value = '';
    }
    record.見積番号.disabled = true;
    return event;
  });
  // レコード追加画面の保存前処理
  kintone.events.on('app.record.create.submit', async (event) => {
    let recNo = 1;
    const record = event.record;
    const date = luxon.DateTime.local();
    const params = {
      app: kintone.app.getId(),
      query: 'order by $id desc limit 1',
      fields: ['$id']
    };
    try {
      const resp = await kintone.api(kintone.api.url('/k/v1/records', true), 'GET', params);
      if (resp.records.length === 0) {
        recNo = 1;
      } else if (resp.records.length > 0) {
        recNo = parseInt(resp.records[0].$id.value, 10) + 1;
      }
      // 自動採番を見積番号に設定する
      const autoEstNo = `${date.toFormat('yyyyMMdd')}-E${('000' + recNo).slice(-3)}`;
      alert(`見積番号 ${autoEstNo} を登録します`);
      record.見積番号.value = autoEstNo;
      return event;
    } catch (err) {
      record.見積番号.error = '見積番号が取得できません。';
      return event;
    }
  });
})();