Sign in
Language
日本語 English

Articles in this section

  • Docutone Download Page
  • [TECH COLUMN] Output an Excel Form with docutone
  • [TECH COLUMN] Output a Word Form with docutone
  • [TECH COLUMN] Insert Charts in a PowerPoint File (Docutone)

[TECH COLUMN] Output a Word Form with docutone

Avatar
OPRO Support staff
  • 7 months ago
  • Updated
Not yet followed by anyone

Hi, everyone!

This time, we would like to introduce how to output a Word form from kintone using Docutone.

 

The Process of Setup

The setup task to output forms with Docutone includes the following processes.
* Where you perform tasks is represented inside brackets.

En_Word_1.pngEn_Word_2.pngEn_Word_3.pngEn_Word_4.pngEn_Word_5.png

  1. Install Docutone app and plug-in (kintone)
  2. Design form appearance and set up form fields with "Document Designer for Office" add-in (Word)
  3. Upload the form design using OPROARTS Designer (OPROARTS Designer)
  4. Perform settings to link kintone app fields to a form template with Docutone app (kintone)
  5. Place a button to output forms with Docutone plug-in (kintone)

 

Install Docutone App and Plug-in

You need to install "Docutone" app and plug-in in kintone environment to use functions of Docutone.

Download template ZIP files for both of app and plug-in from this page.

docutone_download.png

 

Use those ZIP files to install app and plug-in in kintone environment.

App
app_plus_button.png
create_from_template_link.png
create_app_from_template.png

Plug-in
kintone_administration.png
others_plugins_link.png
import_button.png
import_plugin.png

 

"Estimate" app, which can be downloaded from this page, is used in this article. Download a ZIP file from the download link that is described as "Sample App" and use it to install "Estimate" app in kintone environment.

You can install "Estimate" app in the same way as "Docutone" app.

quote_app.PNG

 

After that, add 2 records to Docutone app.
Open Docutone app and register records for each of LAD license and LA license.

* LAD is a license for form design and LA is for form output. You perform settings for form template mapping and document output in a LAD license record.

click_docutone_app.png
add_docutone_record_button.png

 

LAD
create_lad_record.png

LA
create_la_record.png

 

2 records are added to the Docutone app.

opproarts_connector_records.png

 

Design Form Template

To begin with, design form appearance with Office add-in "Document Designer for Office" in Word.

Word files that include form designs are attached at the bottom of this page.

We prepared two types of Word files.

  • "template_en.docx" is the one that is designed but no add-in is installed and no CSV field is defined in it.
  • "template-csv-defined_en.docx" is the one in which an add-in is already installed and all required CSV fields are defined.

template_designs_word.PNG

 * If you want to try CSV defining from the beginning, use "template_en.docx".

 

The design of the Word file is like this.

design_word.PNG

 

Define CSV fields as follows.
* You can perform auto-mapping in Docutone app's setting screen if you name field names the same names as field codes of the kintone app.

Header/Footer

csv_header.PNG

Line Item

csv_lineitem.PNG

 

For "Subtotal" in the form design, you need to insert a tag to output the sum of prices.

Click [Σ] tab in the add-in, then adjust the cursor to the point where you want to insert the sum value and click a pencil-button next to "Price", and a tag will be inserted.

insert_total_tag.png

* Click the pencil-button after confirming that the value of the select list is "Total".

 

Use the formulae below for "Tax" and "Total (including tax)" in the template design.

Tax

Formula:

 =B1*0.1

Display Format:

 #,##0

 

Total (including tax)

Formula:

 =B1+B2

Display Format:

 #,##0

 

The Word file edited in the procedure above looks like this.

design_with_tags_word.PNG

 

Next, upload the form design to OPROARTS Designer.

Click [Start] button in a "LAD" record's page of Docutone app to open OPROARTS Designer.

click_docutone_app.png
click_lad_record.png
open_oproarts_designer_button.png

 

Click [Create New].

live_screen_new.PNG

* Although you only upload the design of a form, click "Create New".

 

Select "Upload" in [Word] tab.

select_template_type.PNG

 

Specify CSV for Input, enter a template name, select the Word file in which you designed a template for Word document and click [Create].

new_template.PNG

 

Click [Deploy], click [Deployment] in Template Deployment Wizard and template deployment is complete.

deploy_button.PNGtemplate_deployment_wizard.PNG

 

Set Up Docutone in kintone

In Docutone app, open a "LAD" record and perform settings for output process.

click_docutone_app.png
click_lad_record.png

 

Clicking [Assign] in [App Settings] opens a dialog box in which you specify the app on which you place the button, so enter the app ID and click [Assign].

assign_app_settings_button.png
assign_app_id.png

 

 

Check "Enable", select the template you created for "Template" and select "DDO Word" for "Operation".

setup_document_generation.png

 

After specifying the template and the operation instruction to use, perform mappings for "Page Mapping" and "Repeatable Mapping".

mapping_buttons.PNG

 

Click [Mapping] of "Page Mapping" and link the kintone app's fields to CSV fields of a form.

* If the app's field codes are the same as the field names of CSV fields, just clicking [Auto Mapping] finishes mapping.

mapping_header.PNG

 

For "Repeatable Mapping", perform mapping in the same way.

mapping_repeatable.PNG

 

Whereas a sub table is used here, you can also use another app for repeatable mapping by checking [Use Related Records], clicking [Settings] and filling out setup fields.

 

After finishing mapping, click [Save].

save_button_word.png

 

Place An Output Button

Place a button to output forms based on the settings you performed in Docutone app.

Click Settings of the app where you want to place a button > Plug-ins > New, check "Docutone" and click [Add].

estimate_app_settings_button.png
estimate_plugin_link.png
new_plugin_button.png
add_plugin_button.png

 

Click the gear icon of "Docutone" plug-in and go to the plug-in settings screen.

gear_icon.png

 

Select a Docutone app to use.

select_docutone_app.png

 

Click [Add] in "Button Placement Settings" and select the output action you set up in Docutone app.

button_placement_settings.png

 

Click [Add] to add the button.

button_select_dialog.png

 

Click [Save] and update the app.

save_plugin.png
estimate_app_settings_button.png
update_app_button.png

 

An output button is displayed in a record detail page.

output_button.PNG

 

Click it and an Word form will be output.

output_word.PNG

 

In Case of Changing Design of A Form

 If you want to change the design of a form after uploading it to OPROARTS Designer, click "Upload" button in OPROARTS Designer's template detail screen.

upload_button_word.png

 

Select the Word file where you changed a sheet's appearance and click "Upload" to update the form template.

select_design_to_upload_word.png

 

Besides, if you also changed CSV definition of the form template, follow the mapping procedure of Set up Docutone in kintone again.

 

 

Docutone enables you to output Word forms from kintone with ease.

We hope that this article will help you output Word forms from kintone using Docutone.

 

Return to top

Related articles

  • Docutone Download Page
  • [TECH COLUMN] Output an Excel Form with docutone
OPRO Co., Ltd.