Generating a Product Catalog PDF from Table Images Using Customine

Article Overview

In this article, I will explain how to output a product catalog-like PDF using Customine, based on the contents of a table with multiple rows registered. The key point is to output to Excel with one sheet per table row and then generate that as a PDF.

What I want to achieve is shown in the figure below.

If you are interested in implementing the content of this article in your own company, please contact us via the kintone Spot Development Free Consultation Form.

Basic Flow

1. App and test data preparation
2. Template preparation
3. Customine configuration

App/Test Data Preparation

It looks like the image below.

Prepare a product name, product description, and image for each line item.

Template Preparation

It looks like the image below.

Key Points

• To ensure a sheet is added for each table row, set the sheet name in the following format:

#(カタログ明細)$(商品名)

• To reference only the first file in the attachment for the image field, set it as follows:

$IMG(画像)(0)

• Other items are set normally, such as $STR(商品名).
• Adjust the layout carefully so that it fits neatly on a single page in the template. If page breaks do not work correctly when converted to PDF, it might be an option to output it as an Excel file instead.

Customine Configuration

There are no special notes for the Customine settings. Place a button, reference the template, and output it to PDF.

Results

It was output correctly.

I hope this is of some help.

If you are interested in implementing the content of this article in your own company, please contact us using the link below. We are available for consultations regarding kintone spot development.

Contact us via the form here: kintone Spot Development Free Consultation Form