A search view is used to search and display multiple records from your database.
How Searches Work
Searches display multiple records from an object in your database using rows and columns.
Any of the fields from that object can be used as columns in the search.
The following example is a search for Contacts records:
Each record in a search result can be linked to a child page to edit or view more details about that record.
You can add a search to any page by selecting the Search option from the views toolbar at the top of the page:
Select the object you want to display records from, and click the "Add search" button:
Then you can select additional options to add links to view or edit each record in a new page. Last, click the "Add view" button:
You can add links to edit each record with a form or view more details about each record.
You'll also have options to display any connected records. In the example above each company is connected to many contacts, so options are available to display those connected contacts or add a new one.
New searches will include search fields for the first six fields of the object by default.
Click directly on a search in your pages to edit it:
The search will open in "edit" mode where you can use the menu on the left to edit different aspects of the search.
The Data Source section is used to control the records the search will display:
Data: the table will display all the object's records by default. Use the data section to add rules to limit which records will be displayed.
Sort: control the default sort order of which records will be displayed first.
Limit: show all of the available records or limit to a specific number.
The Search Fields section determines which fields the user will be able to search by:
A title and description are listed above the search fields, and you can click on each to add or edit. These are optional and will display at the top of the search if added.
Add Search Fields
All of the object's fields will be available to add from the menu on the left. Clicking on a field will add it to the list of search fields:
Keyword Search is a special option. While each search field will just search that field in each record, the keyword search will search every field in the entire record.
- Keyword searches must contain at least two characters and neither can be a special character.
- "is" and "is not": will return ANY record with an exact match, tokenized (segmented) by word.
- "is apples" will return "apples" and "oranges and apples" but will not return "orangeapples" or "apples123".
- Using the same available records, "IS oranges and apples" will only return "oranges and apples".
- "contains" and "does not contain": will return any record with a partial match within the entire string being searched.
- "contains apples" will return "apples" and "oranges and apples" and "orangeapples" and "apples123".
- Email addresses: Searching on email addresses is currently an outlier and does not obey "is" filters.
Each new search defaults to having a keyword search. If you need to add one, click on the Special tab above the list of available fields to add a keyword search:
If the table object is connected to a parent object, you can also add fields from that connected object. You'll see a menu above the list of fields you can use to select other connected objects:
Edit Search Fields
You can edit each search field by hovering over it and clicking the "pencil" icon:
A window is displayed to edit that search field:
Label: the text identifying the field that will display before the search input.
Advanced Filters: when set to No, the field will have a simple input to search by. When set to Yes, advanced filters can be added to further specify the search for that field. Each field type has specific filter options like "is", "is not", "is higher than", etc.
Match Type: when the Advanced Filters are set to No, you can define what the match type is. Any will act more like a "fuzzy" search where any part of the field can contain the search value. Exact will require an exact match.
Required: a value will need to be entered for this search field in order to submit the search.
Instructions: add instructional text if you want to offer more context or instructions for searching on that field. The text will display in a smaller font below the search field.
If the "Advanced Filters" is set to "No" then you can set the default for that search field by selecting an advanced filter drop-down and value. For example, here the default for Industry can be set to Tech:
Change the order of the search fields by dragging any search field and dropping it into a new location.
Delete a search field by hovering over it and clicking the "trash can" icon.
The search results will display based on the search results setting in the Options section below. This defaults to a table format:
Editing these options are identical to the table and list views, depending on your settings.
The Options section provides additional options for formatting your search results:
Show the results of the search in a table or list. Changing this will automatically update your "Search Results" option from the left menu. Changing to a list will provide an additional option to display the results in 1, 2, or 3 columns.
Show results to start
By default a search will start with no returned results; only the search fields will be visible. Check this if you want to also display an initial page of records.
Pagination determines how many records will show at one time. If the total number of records exceeds the pagination number, then links will be added to the list to navigate all the pages. Here's an example of a list displaying pagination links in the top right:
You can set how many table rows to show at a time, as well as allowing the user to change this number if desired.
Exporting allows the user to export all the data from the table into another format. An export link will appear in the top left, with options for downloading in a CSV, Text, or JSON format:
Note: the exported data will always reflect the exact data the table is displaying, including any sorting and filters.