Register a template

Created: Updated: Estimated time: 10 min

Register a template in this order: "テンプレ追加" (Add template) → ID and output format → upload the xlsx → accept and edit the AI's mapping suggestions → file-name rule → save. Allow about 10 minutes per template. AI mapping needs a Gemini API key registered first.

Steps

Screenshots are taken from the real PRING plugin (v6) with sample data; the surrounding kintone screen is simplified. Your kintone and plugin version may differ in details. The plugin UI is in Japanese.

  1. 1. Press "テンプレ追加" (Add template)

    On the Templates tab of the settings screen, press "テンプレ追加". The template editor opens.

    The Add template button at the top right of the template list
  2. 2. Enter the template ID, button name and output format

    In "1. 基本" (Basics), type a name in "テンプレ ID" using letters, digits and underscores (for example Invoice_2026), a name users will see in "ボタン名" (button name, for example 請求書), and choose the type and output format (PDF / xlsx / both). The button name is what appears on the export buttons in the record view.

    Template ID field and output format selector in the basic information section
  3. 3. Choose and upload the Excel file (xlsx)

    In "2. Excel ファイル", use "ファイルを選択" (Choose file) to pick the Excel file to fill and press "アップロード" (Upload). Only .xlsx, up to 32 MB. After the upload the cell layout appears in "3. セルの対応付け" (Cell mapping).

    The box for selecting an xlsx file
  4. 4. Press "AI で候補を出す" (AI suggestions)

    Press "AI で候補を出す" below the cell mapping grid. If no Gemini API key is saved on the AI 設定 tab, a link to that tab appears here instead.

    The Generate mapping suggestions with AI button in the mapping section
  5. 5. Review the suggestions and add them to the table

    Check each suggested cell-to-field pair and its confidence (high / medium / low), then press the add button. Verify medium and low items in the next step.

    The AI suggestions dialog and its add-to-table button
  6. 6. Correct cells and fields in the table

    Mapped cells are coloured in the cell grid, and "対応付け一覧" (mapping list) below shows each cell (for example B3) with its kintone field. Click a cell in the grid to choose the field for it or remove the mapping. For line items, click the first cell and choose the subtable field (see [Set up the subtable layout](/en/help/admin/subtable)).

    The cell grid with mapped cells coloured, and the mapping list
  7. 7. Enter the file-name rule (NameRule)

    Type the output file name in "ファイル名規則" (file-name rule). The buttons below it (record number, output date, output date-time, output user and each field) insert {{RecordID}}, {{CreateDate}}, {{CreateDateTime}}, {{CreateUser}} and {{FieldCode}}. The extension (.pdf / .xlsx) is added automatically; if left empty the name is the template ID plus the date and time. Example: 請求書_{{Customer}}_{{CreateDate}}

    The file-name rule field and the buttons that insert items
  8. 8. Press "保存" (Save)

    Press "保存" at the bottom of the screen. While "未保存の変更があります" (unsaved changes) shows on the left, nothing is saved yet. After saving the screen says the export buttons now appear on the record view.

    The Save button in the bottom bar
  9. 9. Edit or delete from the list

    Each row in the template list has "編集" (Edit) and "削除" (Delete). Deletion cannot be undone; confirm the template name in the dialog first.

    Edit and Delete buttons on a template list row

Template design tips

  • One template = one document type (do not combine quote, invoice and delivery note in one file).
  • Leave spare rows in areas where a subtable will expand.
  • Set the print area and page breaks in Excel so the PDF layout is stable.
  • Use standard Excel fonts (Yu Gothic, MS Mincho, Arial). Environment-specific fonts may be substituted in the PDF.

Frequently asked questions

Do Excel formulas and pivot tables survive?

Yes. Formulas such as =SUM and =VLOOKUP are recalculated after the data is filled in, and pivot tables, charts, merged cells and conditional formatting are kept in the output.

Can I add mappings by hand?

Yes. Click a cell in the grid of "3. セルの対応付け", choose the field in "入れるフィールド" and press "この内容で対応付ける" (apply). You do not need the AI suggestions.

Can I change the template ID later?

No, it is fixed once saved. Use letters, digits and - _ . up to 64 characters. The name users see is the button name, which you can change at any time.