What would you like to know more about?

Create a New Personal View

Instructions to add a new personal view on any page in the Platform.

You can build a new personal view by selecting the fields and filters you want to see on any page or sub-page. The page you start on is the table your view pulls records from.

  1. Go to the page you want to add the view to.
  2. From the view drop-down menu, click New/Copy View.
    The view drop-down list expanded, with a red rectangle around the New/Copy View button at the bottom of the list
  3. Enter a title for your view. This is the name that displays in the view drop-down list. You can also add a description to help your future self and staff you share this with understand the view's purpose.
  4. Double-click or drag and drop the fields you want in your view to the space on the right.
    • Fields with the paper with the top right corner ear marked icon are in the table associated with the page you're on.
    • Fields with the gray folder icon represent relationships to other tables. Expand these folders to add fields from other tables, up to six levels.
    • View columns display in the order that they display in this window. To reorder columns, use the three stacked horizontal lines icon to drag and drop them to the appropriate location.
    Young Adults View with the fields Display Name, Date of Birth, and Contact Status selected
  5. Each field in your view becomes a column. If needed, you can change the Column Name.
  6. Views must have criteria that limits the resulting list, otherwise known as a filter. To create filters, set comparisons and search values on the fields you selected. See SQL Comparisons for more details.
    Young Adults View with field Age selected, Comparison of "Between", and Search Terms "18" and "29"
    Tip: If you want to filter on a field but not show it as a column in your view, clear the checkbox beside the column name. For example, you can filter on Contact Status ID of 1 without showing a column full of 1s.
  7. Click Save Query.

Your view displays in the views drop-down list.

Seeing too many records? Add a filter to narrow the list. Not seeing the records you expected? Check the comparison and search term you used in the view.