In Kintone, when searching using the value of a string field, you cannot perform a “single character search in Japanese” or a “partial match for alphanumeric characters.” To resolve this issue, you can create a search field that enables both “single character searches in Japanese” and “partial matches for alphanumeric characters” based on the values in the original field.
Before proceeding, create a dedicated dummy field for searching, separate from the actual field you want to search within the Kintone form. For example, if the field you need to search is “Customer Code,” create a field labeled “Customer Code (for search).”
In the customization settings of Customine, you can configure it to “Create String for Search” at your preferred timing, such as “Before Record Saved Excluding Deleted” or “When Fields Value Changed.” In this setup, specify “Customer Code” as the “Source Field” and “Customer Code (for search)” as the “Field to Set Search String.”
To utilize the created search field, you can, for instance, install “Put Keyword Search Form on List Page.” In this case, the search condition should specify “Customer Code (for search).”
Note that you cannot use the “Put Simple Search Form on List Page” method, as this approach only searches for an exact match.
Set Source Field and Field to Set Search String.
Specify the field that contains the value you want to search for.
Executing “Create String for Search” does not change the value of the source field.
This parameter accepts the following field types:
If you select a field that is inside a table, the Do will process all rows of that table. See *1 for exceptions to this behavior.
*1: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the value will be set only for those affected by that Condition.
Define the target field to assign values for single-character searches in Japanese and partial matches in alphanumeric characters based on the source field value.
Executing “Create String for Search” will overwrite the value of this field.
This parameter accepts the following field types:
If the “Source Field” is a field within the table, the “Field to Set Search String” must also be selected from the same table.
The number of characters in the value in the “Source Field” must be within 64 characters. If a value longer than 65 characters is entered, an error will be displayed during customization execution.
After version 1.61, released on September 5, 2019, you cannot set the same field as both the “Source Field” and the “Field to Set Search String.”
This action is designed to work seamlessly with krewSheet.
However, the following restrictions apply to the parameter “Search String Field”: