> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.metalocator.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Searching for ranges of values

When developing a search interface, sometimes allowing the user to select a range of values is appropriate.  This is often presented as a drop-down list as shown below:

[![](https://storage.crisp.chat/users/helpdesk/website/-/b/2/9/e/b29e429e4fd4e800/804ece72-6ca1-4497-ac14-1f628f_1sihtf0.png)](https://downloads.intercomcdn.com/i/o/631128443/c4c2a735d88cdbee548c40f9/image.png?expires=1794511800&signature=d9af34e91028f156ef6dc575606514af7f128f3f0c8582ebf039dd87dbefcb88&req=ciMmF8t2mYVcFb4f3HP0gFnR9QWMuBPAY6T5jDCs%2FOSLGDXJAxJlsf%2FN17lX%0AZBpeY2UQ4ZsgWx83JQ%3D%3D%0A)

This allows the user to select from a dropdown list instead of entering a value directly.  The expectation when choosing 1-1000 is that the system should return results for any records with values for "range test" between the user's chosen value, shown as 1-1000 above.

To create this type of field, go to Fields, and click New.  Choose Range under field type as shown here:

[![](https://storage.crisp.chat/users/helpdesk/website/-/9/e/f/6/9ef6a52a1972d800/1d452933-6b55-4596-a895-7cdaf4_i4m0ph.png)](https://downloads.intercomcdn.com/i/o/631128175/60c700dfc2d1ffa136962db7/image.png?expires=1794511800&signature=fd398e7781fe2b6c6aed330dc2265b207fd2a10644ca8377f7af97af15e46448&req=ciMmF8t2nIZaFb4f3HP0gBYKFJ61qV7BECYl4Fc0VdoEs2p7NL%2BS0CSA9ZtT%0At0Sw5O%2Fj4uOXKTPeKg%3D%3D%0A)

The Range Values option is used to build the search form drop-down list.  It should be provided in the following format

_Start Value-End Value, Label;Start Value-End Value, Label;Start Value-End Value, Label;_

For example, if we created a field called "SqFt" and entered the following values

1-100,Small;101-200,Medium;201-300,Large

This would produce a drop-down list with 3 values, Small, Medium and Large.  Users choosing those values would find rows in your database with values in the "sqft" column that fell within the chosen range.