Users can search for dataset records in numerous places, such as in the top right search box of Slate or on a form using an autosuggest list for its dataset. By default, users can find dataset records by their:
|
|
Users may want to make dataset records searchable by values, in addition to showing information for other values. Users can customize this search using a dataset index/header rule. For instance, the above example demonstrates how Slate can show additional attributes about the dataset record, like its location and former name (which is a custom field).
The index/header information also appears when users click "Continued..." in an autosuggest list. The information is displayed in the "data" column: |
|
We've outlined an example below for organization records.
Organization Record Example
In this example, we are looking to:- Show address information. If the organization is in the United States, we want to output its city and state. If the organization is not in the United States, we want to output its city and country.
- Show its former name. We've created an organization-scoped field that allows us to enter the former name of an institution. By showing this, users can more easily find their school. Instead of using a field for storing an organization's former name, you can also store and use something like its aliases; for instance, allowing users to find George Washington University by storing "George Washington, GW, GWU" in this field
1. Join from "Organization" to "Address by Rank Overall" and enter "1" for the "Rank" setting. This will grab the overall rank 1 address for the dataset record. 2. Add a subquery export. 3. Specify a "Name", like "Index and Header". 4. Select the "Output" setting of "Concatenate". 5. Add the "City" export from the "Field Values" join. 6. Add a literal export with the "Name" and "Literal" settings of ", ". 7. We want to output the address' state if it is in the United States; otherwise, we want to output the country. To do that we:
|
|
8. We want to output a new line that contains the former name of an organization if the organization has one. In our example, we are storing the former name of a school using a custom organization-scoped field. To do that we:
|
|
9. Reference the "Index and Header" subquery export in the formula. 10. Save the rule. |
|
- Activate the rule.
- Perform a Retroactive Refresh.
Tip On the Tables
Slate stores the person index on the [dataset.row] table in the [index] column, [dataset.row].[index].
Comments
Please sign in to leave a comment.