Filter Records command filters the records according to the specified condition. It lets you specify the filtering conditions using filter or formula of kintone.
Settings
Filter
Settings of this filter is same as that of kintone filter. For detailed information about settings, see Filtering Records to Be Displayed of kintone documentation.
 |
If selection items are added or their order is changed in following field types by changing the app settings after the filtering conditions for target field has been set in the filter, items selection in filter might get changed. Hence, in such case, it is recommended to check the filter settings and change as required.
|
Formula
| Setting | Description |
|---|---|
| Formula | Click the Edit... button to open the Insert Function dialog and specify the formula. Formula is executed record-wise, hence filtering the records with result TRUE. |
Example
This example demonstrates how to filter the records which have "Travel" as value in Account field.
Input Data
Command Settings
In case of filter
| Field | Condition | Value |
|---|---|---|
| Account | [includes any of] | Select "Travel" |
Settings Page
In case of formula
| Formula |
|---|
| Account = "Travel" |
Settings Page
Execution Result
