Apply

How to Filter Applications

When managing the applications of a program within your site you will be interested in following their progress, ensuring that they are completed correctly, locating patterns in incomplete applications, and more. This article explains how to apply filters to your Manage Applications page to view the applications that are important to you and the actions you are looking to complete.

Throughout this article, we will be referring to various icons and menus that are used to create, manage and apply filters to your applications. Below is a summary of these features as well as a brief description of what they do.

FilterDefinition
Status Filter MenuUsed to quickly toggle between active and inactive (archived, trashed) applications.
Active Application FilterDisplays active applications within a program. Active applications can be accessed from the Status Filter menu.
Inactive Application FiltersThe term used to describe inactive applications which includes both the archived and trashed status. Inactive applications can be accessed from the Status Filter menu.
Custom FiltersFilters created using the Custom Filter builder. Custom filters can be saved for later use and shared with other administrators.
Your Custom FiltersCustom filters that are saved for later use, but not shared with other administrators. Access Your Custom Filters by selecting the dropdown menu appended to the New Custom Filter icon.
Shared Custom FiltersCustom filters that are saved for later use and shared with other administrators. Access Shared Custom Filters by selecting the dropdown menu appended to the New Custom Filter icon.

Your status filter menu allows you to toggle between active and inactive applications. This filter applies in conjunction with any custom filters applied to the program's applications. Active applications will be shown by default when Manage Applications is accessed.

The Active Applications filter.

To toggle between active and inactive applications:

  1. Select the dropdown menu shown above.
  2. Select a new status.

Toggling between active and inactive filters will clear any existing custom filters applied to your applications. Be sure to save your custom filters before toggling this menu if you will be using the custom filter often going forward, but do not want to rebuild it.

Custom filters are used to filter results in a variety of areas throughout an SM Apply site. When applying a filter to the Manage Applications page the custom filter will display results that satisfy all applied conditions within the filter. A single filter can consist of multiple conditions to target specific applications.

There are three menus use to create a custom filter. The chart below provides a description of the terminology used to describe the custom filter builder within Manage Applications and references an example of a custom filter which would pull all applications that have not yet been declared awarded or rejected applications.

An image of the three filter menus: Condition, Value parameter, and Value/target.
Label NumberMenuExample
1ConditionDecision
2Matching parameterEquals
3Value/TargetUndecided

When viewing applications from Manage Applications page you may wish to apply a custom filter to your list of applications.

To add a custom filter:

  1. Select New Custom Filter.
  2. Choose your condition.
  3. Select your matching parameter.
  4. Set the required value.
  5. Select Apply.
An image of a custom filter. The condition is Submittal, the Value parameter is Equals, and the Value/target equals Submitted.

The example above demonstrates how to apply a custom filter to retrieve applications that have been submitted.

Once the filter has been applied, a banner will appear titled with a short summary of the filter below the Condition menu.

An image of a filter that's been applied.

TIP! Interested in saving your custom filter for future use? See How to Save/Manage Custom Filters for more details.

When a filter has been applied it will appear as a summarized banner directly below the custom filter builder. Removing a filter can be done by selecting the X within the banner of the filter(s) you would like to remove from the page.

In some cases, more than one filter will be needed in order to retrieve the desired applications in your results list.

To add multiple filters:

  1. Add your first filter following the steps in Add a Custom Filter or select a Saved Custom Filter.
  2. Select the Condition dropdown to begin creating the next filter.
  3. Select Apply.
  4. Repeat as necessary.

The following group of filters is selected in the condition portion of your custom filter. The value of the filter will vary depending on the filter selected. Many of these filters are site-specific including stage names, label titles, and application IDs.

FilterDescription
TitleFilter by the Application title
Application IDFilter by a value that is/is not found within the application ID. This is helpful when unique application ID prefixes are used for different cycles
Current StageRetrieve applications based on their current placement (stage) in the program workflow
LabelDisplay applications with/without specific labels
StatusFind applications with a specific status (withdrawn, active, rejected, etc.)
Submit DateSearch for applications submitted on a specific date or within a certain range
Has CollaboratorsFilter applications based on whether they are being completed by a team of applicants or a single applicant.
Date CreatedSearch for applications created on a specific date or within a certain range
DecisionRetrieve applications based on the final decision (awarded, declined, undecided)

Custom fields that target applications will be presented within the Application details category to assist in filtering applications. If a custom field is not appearing the Applicant Information category then it is not currently targeting the applicant role.

For more information regarding Custom Fields, please see our documentation on How to Create a Custom Field.

FilterDescription
First NameFilter for applications created by a user with a certain character sequence in the applicant's first name.
Last NameFilter for applications created by a user with a certain character sequence in the applicant's last name.
EmailFilter by a character sequence in the applicant's email address.
Helpful when searching for applications created by users with a certain email domain.
Applicant IDSearch for applications created by a specific applicant Id.
Applicant Ids are unique to each user.
Last active in the systemSearch for applications whose users have been active within a certain timeframe. For example: apply a filter to see applications whose owners have not been active in the site for over one year.
RolesPull applications of users who are associated with certain roles.
User statusFilter by user status to pull applications created by active, deactivated, invited, or unverified applicants.
Sign up dateFind applications created by applicants who registered for their profile on a specific date, within a date range, or before/after a specific date.
Language preferenceSearch for applications with owners who have set a specific language preference.
TimezoneSearch for applications created by users who have set a specific timezone with their profile.
Is a CollaboratorSearch for applications, where the owner of the application is also a collaborator on another application

Custom fields that target the applicant role will be presented within the Applicant Information category to assist in filtering applications. If a custom field is not appearing the Applicant Information category then it is not currently targeting the applicant role.

For more information regarding Custom Fields, please see our documentation on How to Create a Custom Field.

TIP! Interested in saving your custom filter for future use? See How to Save/Manage Custom Filters for more details.

The filters below are found in the Application Stage condition category when creating a new filter in the Manage Applications page.

An image of Application stage filters: Stage Completion, Task Completion, and Form responses.

These filters have additional choices required to complete a custom filter which are described later in this section.

FilterDescription
Stage CompletionFilters created from the stage completion source will verify the application against the completion of application stages within the program workflow. Unlike the Current Stage filter found within the Application Details category, only application stages can be selected. This filter is intended to check the completion of stages where applicants must complete tasks.
Task CompletionThese filters can refer to the completion status of an application task in any application stage in the workflow. Only applicant tasks within your program can be selected to complete this filter.
Form ResponsesThe variable filters section will allow you to filter applications based on their responses to forms within your site. The options available in this section will be dependent on the form types and questions in your site.

Multiple selections are required when applying a stage completion filter. As stated earlier, only application stages can be selected to complete this filter and verify whether an applicant has progressed to a certain stage in the program workflow.

To apply a stage completion filter:

  1. Create a New Custom Filter.
  2. Select Application stages from the conditions dropdown.
  3. Select Stage completion.
  4. Select one of the application stages in the program's workflow.
  5. Set the filter parameters.
  6. Select the stage completion status (Submitted, Re-Opened, or Initialized).
  7. Click Apply.
An image of the stage completion options when adding custom filters.

The example above will filter for applications that submitted applications in the Application Stage. This will not include applications that are currently in that stage unless they have submitted the application while within that stage.

The variable filters section will allow you to filter applications based on their responses to forms within your site.

These filters can refer to the completion status of an application task in any application stage in the workflow. Because the filters applied here are to filter the applications that appear in your results, only tasks that are completed by the applicant can be used for this filer.

TIP! If you are looking for applications that were given a certain score or were graded with a certain response from reviewers within a review form, use the Review Stages category filters to reference questions asked within one of your review forms.

An image of the task completion options when adding custom filters.

The filter applied above is used to filter for applications that have not completed the application task titled "Upload Task." The filter will check the current status of the task, meaning that if the applicant completed the "Upload Task" previously and then deleted the file, the application would be included in this filter because the current status would be considered "Not Started."

The options available in this section will be dependent on the form types and questions in your site. For most of the question types you will be given the criteria to select whether or not the question/variable has a response or has no response. This can be helpful when trying to determine a user's progress in the form, or perhaps if the question type is optional and you want to see who responded to it.

To apply a form response filter:

  1. Create a New Custom Filter.
  2. Select Application stages from the conditions dropdown.
  3. Select Form responses.
  4. Select one of the application stages in the program's workflow.
  5. Select one of the application form tasks.
  6. Select the question.
  7. Set the filter parameters.
  8. Select the response you wish to filter by.
  9. Click Apply.

The value/target to select when developing a form response filter will vary depending on the question type used in the form the question is presented. Below is an explanation of what will be presented in the value/target menu when a particular question type is selected.

Question TypeFilter Value OptionsDescription
Text ResponseOpen text fieldUse this filter to pull applications that provided a certain response to a question. This can be a text, character or number value.
Multiple ChoiceList of multiple choice optionsUse this filter to view applications that provided specific answers to a form question.
DropdownList of Dropdown optionsUse this filter to view applications that provided a specific answer to a dropdown form question.
CheckboxList of Checkbox options Use this filter to pull applications with specific checkbox choice(s) to a checkbox form question.With checkbox type questions it is common to select more than one choice, therefore you can choose between "Is one of" or "Equals". "Exactly" will look for responses that only have that choice (or those choices) selected.
Single ColumnA variety of question types can exist within a single column question (Text Response, Dropdown, Checkbox, Radio Buttons)Refer to the Text Response, Dropdown, Checkbox, and Multiple Choice (Radio Buttons) question types for more information on the selectable value/target.Each variable within the Single Column question can be selected as its own filter.
Multi-ColumnA variety of question types can exist within a Multi-column question (Text Response, Dropdown, Checkbox, Radio Buttons)Refer to the Text Response, Dropdown, Checkbox, and Multiple Choice (Radio Buttons) question types for more information on selectable values/targets.Similar to the Single Column question, each cell (row and column combination) will have its own filter.
Hidden FieldOpen text fieldUse this field to filter for applications based on the value within a Hidden Field of a form. This hidden field could be a text, character, or number value.
Date/TimeCalendar Field This field can be used if you have a Date/Time question in your form.
NOTE: Date/Time question types populate date parameters. When the "If before" or "If after" parameter is selected, applications with responses for the date selected will NOT be included in the application results. For example, if "Is after -- 03/04/2017" is selected then only responses with a date of 03/05/2017 and on will appear.
Datasource QuestionOpen text fieldAs the datasource list is housed externally from SM Apply you will be unable to select a response from a given list. However, when this question type is selected a text field will be displayed in the value/target menu that can be used to search for a text, character, or number value.
Drill DownList of each category and choice selectionUse this filter to view applications that provided specific answers to a form question.
TIP! To filter by applications that have chosen a specific category, use the criteria "Is one of" and select all choices for that Category.
Ranking QuestionList of the Choices in the question Use this if you wish to see how users ranked the variable in their response. Each variable will have its own filter.
Signature This filter can be used to validate that applications have completed signature requirements within a form.

There are also two question types which are not available to be filtered based on the format of the question. Those questions types are:

  • Section Heading
  • Javascript

TIP! Interested in saving your custom filter for future use? See How to Save/Manage Custom Filters for more details.

The filters below are found in the Review Stages condition category when creating a new filter in the Manage Applications page.

An image of Review Stage filters.
FilterDescription
Form ResponsesThe variable filters section will allow you to filter applications based on the responses the reviewers give to the review forms within your site. The options available in this section will be dependent on the review stage type and questions in your site.
Has reviewers assigned in StageThis will allow you to filter applications based on the reviewers that have been assigned to them in order to determine which applications are assigned to reviewers in which stage.

The options available in this section will be dependent on the review stage types and questions in your site. In an Advanced Review Form most of the question types you will be given the criteria to select whether or not the question/variable has a response or has no response. This can be helpful when trying to determine a user's progress in the form, or perhaps if the question type is optional and you want to see who responded to it.

To apply a form response filter:

  1. Create a New Custom Filter.
  2. Select Review stages from the conditions dropdown.
  3. Select Form responses.
  4. Select one of the Review stages in the program's workflow.
  5. Select Question.
  6. Set the filter parameters.
  7. Select the response you wish to filter by.
  8. Click Apply.

If you are looking to filter by one of your simply review stages. The responses available will depend on the setup of the simple review stage.

The value/target to select when developing a form response filter will vary depending on the question type used in the advanced review form the question is presented. Below is an explanation of what will be presented in the value/target menu when a particular question type is selected.

Question TypeFilter Value OptionsDescription
Text ResponseOpen text fieldUse this filter to pull applications that provided a certain response to a question. This can be a text, character or number value.
Multiple ChoiceList of multiple choice optionsUse this filter to view applications that provided specific answers to a form question.
DropdownList of Dropdown optionsUse this filter to view applications that provided a specific answer to a dropdown form question.
CheckboxList of Checkbox options Use this filter to pull applications with specific checkbox choice(s) to a checkbox form question.
TIP! With checkbox type questions it is common to select more than one choice, therefore you can choose between "Is one of" or "Equals". "Exactly" will look for responses that only have that choice (or those choices) selected.
Single ColumnA variety of question types can exist within a single column question (Text Response, Dropdown, Checkbox, Radio Buttons)Refer to the Text Response, Dropdown, Checkbox, and Multiple Choice (Radio Buttons) question types for more information on the selectable value/target.Each variable within the Single Column question can be selected as its own filter.
Multi-ColumnA variety of question types can exist within a Multi-column question (Text Response, Dropdown, Checkbox, Radio Buttons)Refer to the Text Response, Dropdown, Checkbox, and Multiple Choice (Radio Buttons) question types for more information on selectable values/targets.Similar to the Single Column question, each cell (row and column combination) will have its own filter.
Hidden FieldOpen text fieldUse this field to filter for applications based on the value within a Hidden Field of a form. This hidden field could be a text, character, or number value.
Date/TimeCalendar Field This field can be used if you have a Date/Time question in your form.
NOTE: Date/Time question types populate date parameters that. When the "If before" or "If after" parameter is selected, applications with responses for the date selected will NOT be included in the application results. For example, if "Is after -- 03/04/2017" is selected then only responses with a date of 03/05/2017 and on will appear.
Datasource QuestionOpen text fieldAs the datasource list is housed externally from SM Apply you will be unable to select a response from a given list. However, when this question type is selected a text field will be displayed in the value/target menu that can be used to search for a text, character, or number value.
Drill DownList of each category and choice selectionUse this filter to view applications that provided specific answers to a form question.
TIP! To filter by applications that have chosen a specific category, use the criteria "Is one of" and select all choices for that Category.
Ranking QuestionList of the Choices in the question Use this if you wish to see how users ranked the variable in their response. Each variable will have its own filter.
Signature This filter can be used to validate that applications have completed signature requirements within a form.

There are also two question types which are not available to be filtered based on the format of the question. Those questions types are:

  • Section Heading
  • Javascript

TIP! Interested in saving your custom filter for future use? See How to Save/Manage Custom Filters for more details.

The matching parameter (2) is used to specify under which circumstances applications will appear. It states the acceptable relationship between the value/target (3) and the selected condition (1). Available matching parameters are dependent on the condition selected.

The numbering above describes the location of the feature as shown in the example below.

An image of the three filter menus: Condition, Value parameter, and Value/target.
Parameter TypeParameters Given
Containment parameters- Equals
- Does not equal
- Contains
- Does not contain
Completion parameters- Equals
- Not Equals
- Is one of
- Is not one of
Date parameters- Is before
- Is after
- Is exactly