If you enable "partial match search", you can filter records more flexibly when using a Lookup field.
For example, you can filter records containing "林浩一" by entering just one character "林", or you can filter records containing "kintone202602" by entering a partial string, such as "kin" or "2026".

This page describes how the filtering results for records change depending on whether this feature is enabled or disabled.

• You can filter records containing words of two or more characters by entering just one character. For example, you can filter records containing "kintone" by entering the single character "k".
• For alphanumeric strings, you can filter records by entering a partial string. For example, you can filter a record containing "kintoneAbc-01234" by entering a keyword such as "kintone", "abc", or "123".

For other filtering examples, refer to the following section:
Examples of filtering results

This feature is recommended because it allows you to filter records from a large number of candidates. However, depending on the keywords, records with low relevance may appear as suggestions.

• To filter records containing words of two or more characters, you must enter at least two characters.
• For alphanumeric strings, you must filter by entering whole words. For example, a record containing "kintoneAbc-01234" can be filtered by entering keywords like "kintoneabc" or "01234", but not by entering partial strings like "kintone", "abc", or "123".

For other filtering examples, refer to the following section:
Examples of filtering results

Depending on the values and keywords in the record, highly relevant records may not appear as suggestions.

The following table shows how the filtering results for records change depending on whether the partial match search is enabled or disabled.

• ✔: Displayed as a suggestion for matching records
• Blank: Not displayed as a suggestion for matching records