Customize

Put Multiple Fields Search Form on List Page

Summary

Put a keyword search form on the record list page. Use this form to search through multiple fields using just one keyword.

How to use

When executing “Put Multiple Fields Search Form on List Page”, the search form will be displayed on the record list page. When a user enters search criteria in this form and clicks the “Search” button, the displayed list of records will be filtered. The filtering condition now includes records containing specified keywords in any fields defined by the “Search Criteria Field” parameter.

Suppose the currently selected Kintone “View” has any filtering conditions applied. In that case, it will combine those conditions with the criteria entered by the user in the search form as the “AND” search. This means that the search results will be further refined based on both the original conditions of the “View” and the user-defined search criteria.

The position of the form will be next to the menu.

Next to the menu

Parameters

Set Search Criteria Field and Label.

Search Criteria Field

Select the fields to display in the search form criteria. You can select multiple fields.

This parameter accepts the following field types:

  • Text
  • Text area
  • Rich text
  • Attachment
  • Link
  • Lookup (Text)

For the Attachment field, both the file name and its content will be subject to judgment.

If there are fields for Related records in the app, you can also use the fields of the app that the Related records refers to as search criteria. In that case, the selectable field types are the same as above. However, it must be a field set in the “Datasource app fields to display” of the Related records field. If you select a field that is not included in the “Datasource app fields to display”, the following error will occur when executing the search:

Cannot read the record.
Failed to filter records. Field A is not found in the field that is referred from Related Records field Field B.
(GAIA_IQ17)

All fields will be searched under the condition of “Includes keywords entered as search criteria”.

Label

You can specify the label to attach to the search condition input field of the search form.

Information for advanced users

The HTML elements of the installed form will have an ID of customine-searchform-simple. The field input area and the search button are each enclosed in a div. With this element, you can customize the form style by registering a CSS file in the app.

The following example shows how to reduce the size of the search input field compared to the standard size.

#customine-searchform-simple div:first-child input {
  width: 80px;
}

Restrictions

  • The condition is fixed as “(Includes keywords entered as search criteria)”. It is not possible to search with the “=(equal)” condition.

  • You cannot install more than one “Put Multiple Fields Search Form on List Page”.

  • This action cannot be used in conjunction with “[Put Keyword Search Form on List Page[.”

  • You cannot change the layout of the search form by “Customize Search Form Layout.”

  • If there are duplicates in the view name in the app’s view settings, “Failed to retrieve or update the list. The view name is duplicated. Change the duplicate name to a unique name.” will appear.

  • If the currently logged-in user does not have permission to view the search target field, executing a search with the conditions for that field will result in Kintone saying “You do not have permission” error.