KrewData Features / Commands / Filter Records
In This Topic
    Filter Records
    In This Topic

    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.

    • Radio button
    • Check box
    • Multi-choice
    • Drop-down

    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

     

     

    Copyright © 2023 MESCIUS inc. All rights reserved.