Displaying Records Which Meet Multiple Conditions

In the view, you can filter records by specifying multiple conditions.

This section describes how to specify conditions such as "the orders made by A Company and B Inc." and "the scheduled sales of this month", and then show only records that meet the specified conditions in an order management app.

Example of filter conditions:

  • Customer name equals to "A Company" or "B Inc.".
  • Month of sales equals to "This Month".
  • The above two conditions are met
    A Text field is used for customer name and a Date field is used for the month of sales.

To set filter conditions, use the following steps.

  1. On the View screen of the order management app, click filter button Image. Filter button

  2. Select "Customer Name" for the first condition. Selecting a customer name

  3. In order to display records of "A Company" or "B Inc.", select "includes any of", and then enter "A Company" and "B Inc".
    You should enter customer names which exactly match the registered names.
    Specifying filter conditions

  4. Click add button Image to add a condition field, and then select "Month of Sales" for the second condition. Selecting month of sales

  5. In order to display the scheduled sales for this month, select "= (equal to)", and then select "This Month" and "All". Specifying additional conditions

  6. In order to display records which meet both conditions, select "All conditions are met". "All conditions are met" checkbox

  7. Specify the display order of the records with "Sort by".

  8. Click "Apply" or "Save".
    If you click "Apply", records will be filtered under the specified condition. In an app where you have management permission, you can click "Save" to save the filter condition within the app. Apply button Records will be filtered under the specified conditions.