Skip to content
FormclickDocs
DatabasesWork with data

Filter, sort and search

Find records with filters (including relative dates), sorting and search across a database.

Each table opens in its Table view, where you can filter, sort and search its records.

Filters

  • Combine conditions with and / or, and group them.
  • Text: is, is not, contains, does not contain, is empty, is not empty.
  • Numbers: equal, not equal, greater or less than, between.
  • Selects: is any of, has all of, has none of.
  • Dates: before, after, on or before, on or after, and relative dates such as past week, this month or next year.

Sorting

Sort by any field, ascending or descending.

Search a whole database at once: table names, field names and record values.

Still need help? Contact support or email support@formclick.io.