Skip to main content

Record Search/Filter/Sort/Statistics

In the worksheet, users can quickly find the required records by searching, filtering, sorting, and generating statistics.

Search is the most commonly used method to locate records. Enter keywords to view the list of matching records.

Fields that support search:

  • Only text-type fields that can be entered support search, such as Text fields, Telephone fields, Email fields, ID Number fields, Relationship fields (single row), and Foreign fields (data storage only). Rich text fields are excluded.

  • Clickable/selection-type fields can be quickly located through filters, such as Date/Time fields, Members fields, Department fields, Region/City fields, Single-select fields, and Multi-select fields.

  • Number fields and Currency fields do not support search but can be filtered.

Filter​

Each user can create their custom filters and save them for easy use next time.

Filtering records is based on records visible to the operator in the current view.

1. Create a Filter​

Choose the filter field and set the corresponding conditions to complete the filter setup.

When multiple conditions are needed, you must first choose whether the conditions between the two should be an AND or OR relationship.

Conditions groups allow both AND and OR conditions to exist simultaneously.

Filter by different fields

Save as a filter.

  • Set a name for the filter.
  • Set the scope of the filter (Personal/Public).
  • Save the current filter conditions.

2. Filter Types​

  • Public

    Filters created by the application administrator are visible to all worksheet members. Worksheet members can modify or edit these filters and can convert public filters into personal filters (after conversion, they are only visible to the creator).

  • Personal

    Members can create their own filters, which are only visible to the creator. Only application administrators can convert personal filters into public filters.

3. Filter Operations (Delete/Rename/Modify/Copy/Sort)​

Sort​

Temporary sorting of records is only supported in table view.

Click the column name (field) to sort by that column’s content, and click again to reverse the sort. Sorting will be reset upon page refresh.

Statistics​

Statistics can be generated on columns (fields) of visible records in the current view. The statistics method will be remembered and remain unchanged after a refresh.

For Number and Currency fields: Sum, average, maximum value, etc.

For other field types: Number of records with data entered, number of records with no data.

Statistics are only supported in table view; other views do not support statistics.