Comparables Database – Grouping and Sorting

.

List Grouping

  1. In ClickFORMS, click the Lists menu and selct Show Comparables List...
List Grouping
  1. Click the List tab, then click on any column heading, i.e. address, city, state etc. and drag and drop that heading item into the grouping area as shown below.
List Grouping
  1. In this example "City" has been dragged in to the grouping area and you see the cities displayed below the grouping area in the grid. You can click on the [+] next to each city to view all comparables in that city.
List Grouping

List Undo Grouping

  1. You can ungroup your list by using your mouse to drag and drop the heading item (City) from the grouping area back into the list area. Make sure to drop your heading item back into the grid only when you see the GREEN ARROWS.  Alternatively, you can click the List Options menu item and select Undo Grouping.
List Grouping
List Grouping

List Sorting

  1. In ClickFORMS, click the Lists menu and selct Show Comparables List...
List Sorting
  1. Click the center of any column header to sort by alpha-numeric sequence of the column. The example below shows the StreetName clicked and the records sorted in alphabetical order by street name.
List Sorting

Custom List Sorting

  1. In ClickFORMS, click the Lists menu and selct Show Comparables List...
List Sorting
  1. Sort by entering a custom search string which will only find and display records in the column that contains the numeric and/or alphabetic characters you enter. First, click the down-arrow in the column heading you wish to sort to display the drop-down menu, then select [Custom...].
List Sorting
  1. The Custom AutoFilter window will open. Type in your search word in ALL CAPS (TARES CIR as example below), then click the OK button. In addition, you are able to select other search phrases other than 'equals'.
List Sorting
  1. The comparable record grid will now show only records that contain the search word.
List Sorting

List Undo Sorting

  1. You can unsort your list by clicking the down-arrow in the column heading you wish to unsort to display the drop-down menu, then select [ALL].  Alternatively, you can click the List Options menu item and select Undo Sorting.
List Sorting
List Sorting