Count Docs
How to let your users search and select from a list of results
In Count, single and multiple-select controls are limited to showing 1,000 values. If you would like to allow your readers to search for a value in a much larger list, you can implement a search function using a text control. Schematically, the process is:
  1. 1.
    Add a text control for a reader to enter free-form search text.
  2. 2.
    Use a SQL query to find similar results - hopefully fewer than 1,000.
  3. 3.
    Show the results in a single or multiple-select control
In the example below, the end result for the reader is a combination of a 'search box' and a 'select a result' option:
This example as viewed in published mode
To achieve this, the steps below are:
  1. 1.
    Create a text control called search.
  2. 2.
    In the matches cell, perform a 'fuzzy' search by ignoring the case of the search term, and allowing extra characters on either side (your database may have much more advanced search functionality!)
  3. 3.
    Showing the results of the search from the matches cell in a single-select cell.
This example as viewed in draft mode
Copy link