kintone plugin series
How to convert field data in a table into a multi-line string
Generating multiple lines of strings from field data in a table can be done using Boost! Action.
On this page, we introduce the method of generation using the "LOOP" function from the Boost! Original Functions.
Check the Form Settings
![](../static/image/article/en/table_to_field1.png)
There must be fields belonging to a table, and a multi-line text field that sets a string generated from those fields.
Plugin Settings
![](../static/image/article/en/table_to_field2.png)
Enter a formula using the LOOP function in the "Inserting fixed values or calculation results" section of Boost! Action.
For each row in the table with the field code "Table_1", perform value generation using the fields (field codes "String_1" and "Numeric_1") within the table, and return multiple lines of strings.
LOOP(%Table_1%,/*"Item: "+%String_1%+"\\nQuantity: "+TO_STRING(%Numeric_1%)+"\\n"*/)
For more details, please refer toBoost! Original Functions.
Execution of the plugin
![](../static/image/article/en/table_to_field3.png)
Please confirm that the generated output matches the configured settings.
Fee
While all plugins in the Boost! series can be downloaded and used for free, after a 3-month trial period, a message prompting you to purchase a license will be displayed once a day for each installed app. To use it without displaying this message, you will need to pay an annual fee of 10,000 JPY.
Boost! is based on a domain license, so there is no upper limit to the number of users.
The license and fee apply to the entire Boost! series, not on a per-product basis.
For your interest
This site introduces a series of plugins that extend the functionality of kintone. If you have tried using kintone but feel it does not fit well with your company's operations, we also offer a free open-source web application builder. This tool allows you to easily create a system tailored to your business processes, even without any knowledge of system development. If you are interested, please visit the following URL.
https://pandafirm.jp/en/kumaneko.html