Filter & Replace Feature

How to: Use the filter & replace feature.

Environment: Comsense Advantage & Enterprise

In this article:

What is Filter & Replace?

Filter and replace is a feature that allows you to filter a list of line items to a smaller list and uniformly update all filtered line items with the same information. This feature is available in multiple windows across Comsense. The filter and replace feature increases the efficiency of updating multiple line items.

The three types of filter and replace are slightly different and are distinguished by their section of the software:

Door & Frame Scheduling (Advantage)

*Note: The Door and Frame scheduling windows save automatically, be attentive when using the filter and replace feature!

This section applies to the Door and Frame scheduling windows in the Estimating and Detailing sections of Advantage. In these windows:

  • You must manually turn on the filter and replace feature
  • Filter and replace are two separate line items when the feature is turned on
  • You must include the manufacturer in the filter and replace line items
    • The manufacturer determines the field options
  • Updates save automatically

The Filter line item is above the Replace line item.

Click image to enlarge
Door Scheduling window; shows the location of the Filter line item.
Image 1: Filter Line Item

The Replace line item is below the Filter line item. 

Click image to enlarge
Door Scheduling window; shows the location of the Replace line item.
Image 2: Replace Line Item

Filtering in the Door & Frame Scheduling Windows

*Note: To filter a list by empty fields, use the # symbol as your filter criteria.

In the Door or Frame window:

  1. Check the Filter checkbox
    • The Filter and Replace line items will appear
Click image to enlarge
Door Scheduling window; shows the location of the Filter checkbox
Image 3: Filter Checkbox

In the Filter line item:

  1. Enter the Mfg Code
  2. Enter the filter criteria
  3. Click the filter Checkmark
    • The list will filter according to the filter criteria
Click image to enlarge
Door Scheduling window; shows the filter criteria and the location of the filter checkmark button.
Image 4: Filter Criteria

Replacing in the Door & Frame Scheduling Windows

*Note: To clear fields using the replace feature, replace the fields with the # symbol.

In the Door or Frame window:

  1. Check the Replace checkbox
Click image to enlarge
Door Scheduling window; shows the location of the Replace checkbox.
Image 5: Replace Checkbox

In the Replace line item:

  1. Enter the Mfg Code
  2. Enter the replace information
Click image to enlarge
Door Scheduling window; shows the replace information and location of the replace checkmark button.
Image 6: Replace Information
  1. Click the replace Checkmark icon
Click image to enlarge
Door Scheduling window; shows the fields updated by the replace feature.
Image 7: Updated Fields

The filtered line items now include the Replace line item information.

Tip: Clear the Replace line item immediately after making your changes to prevent any accidental changes.

To clear the Replace line item, Click the icon.

Click image to enlarge
Door Scheduling window; shows the X icon.
Image 8: Clear Button

Advantage

This section applies to filter and replace in Advantage except the Door and Frame scheduling windows. In these windows:

  • There is one line item for both the Filter and Replace function
  • You must select Filter or Replace using the radio buttons
  • Filter is selected by default
  • Updates do not save automatically
Click image to enlarge
Inhouse Labor window; shows the location of the Filter and Replace radio buttons and line item.
Image 9: Filter & Replace Radio Buttons

Using Filter & Replace in Advantage

*Note: To filter a list by empty fields, use the # symbol as your filter criteria.

In the fillable line item:

  1. Enter the filter criteria
Click image to enlarge
Inhouse Labor window; shows filter criteria in the line item fields and the location of the checkmark icon.
Image 10: Filter Criteria
  1. Click the Checkmark icon
    • You can use the checkmark icon next to the radio buttons selections OR on the fillable line item
  2. Click the Replace radio button
    • The fillable line item will clear

In the fillable line item:

  1. Enter the replace information
Click image to enlarge
Inhouse Labor window; shows the replace information and the location of the checkmark icon.
Image 11: Replace Information
  1. Click the Checkmark Icon
    • The fields will update
Click image to enlarge
Inhouse Labor window; shows the fields updated by the replace feature.
Image 12: Updated Fields
  1. Click Save

The filtered line items now include the Replace line item information.

Tip: Save after each filter and replace is done correctly. 

Clearing Fields in Advantage

In the Advantage window:

  1. Click the Set Null radio button
Click image to enlarge
Hardware Options window; shows the location of the Set Null radio button.
Image 13: Set Null Radio Button

In the fillable line item:

  1. Check the checkbox above the column to clear
Click image to enlarge
Hardware Options window; shows an example of a checked checkbox in the Set Null line item.
Image 14: Column Checkbox
  1. Click the Checkmark icon
  2. Click Save

The fields in the checked column are now cleared.

Enterprise

This section applies to filter and replace in Enterprise. In these windows:

  • Filter and replace are two line items
  • The Filter line item is above the Replace line item
  • The Replace line item is below the Filter line item
  • Updates do not save automatically
Click image to enlarge
Customer Management window; shows the location of the Filter line item.
Image 15: Filter Line Item
Click image to enlarge
Customer Management window; shows the location of the Replace line item.
Image 16: Replace Line Item

Using Filter & Replace in Enterprise

In the Filter line item:

  1. Enter the filter criteria
    • The list will filter automatically
Click image to enlarge
Customer Management window; shows the filter criteria.
Image 17: Filter Criteria

In the Replace line item:

  1. Enter the replace information
Click image to enlarge
Customer Management window; shows the replace information and the location of the Replace icon.
Image 18: Replace Information
  1. Click the Replace icon
    • The fields will update
Click image to enlarge
Customer Management window; shows the fields updated by the replace feature.
Image 19: Updated Fields
  1. Click Save

The filtered line items now include the Replace line item information.

Filtering Empty Fields & Clearing Fields in Enterprise

The option to filter a list containing empty fields and to clear fields is included in the drop-down lists of the Filter and Replace line items.

To filter empty fields, Select (Blanks) in the drop-down lists in the Filter line item.

Click image to enlarge
Customer Management window; shows the (Blanks) option in the filter drop-down list.
Image 20: Filter Blanks Option

To clear fields, Select {Clear} in the drop-down lists in the Replace line item.

Click image to enlarge
Customer Management window; shows the {Clear} option in the replace drop-down list.
Image 21: Clear Option
Have more questions? Submit a request

Comments