Filtering on your map

Setting your filters in the Mapping Sheets add-on

In the add-on sidebar you must set the main Filter and also optionally (premium) define any additional filters. There are also optional filters you can configure in the add-on Preferences > Filters section

Main Filter

The main Filter would be the column header you choose in the add-on sidebar

The color of the location icons will depend on the values under that Filter column, either when using default or custom colors

Additional Filters

The number of additional filters is set under the add-on Preferences > Filters. It is zero by default, so you have to change that number before being able to use them.

  • After changing the number of additional filters, save the Preferences and reopen the add-on sidebar for it to take effect
  • Then in the sidebar, you can select the column header and the type of filter to use for each of them
  • The type of filter could be: check boxes, slider range left, slider range right, date, date range, select ... (some of them might not be available yet)

Optional Filters

Under the add-on Preferences > Filters there are a few other optional filters to choose and configure, like Find a place and others to come

Read more details under the Filter section from the Preferences support page

Using your filters in the Mapping web app

When viewing your map, you would have all your filters on the left, from top to bottom in several sections like: Find a place, Find me, Search, Main Filter and Additional Filters

The filtering logic works as follow

  • Within each section: an OR logic, meaning that any location that passes the filter test in one section, it would continue to the next section for validation
  • Across each section: an AND logic, meaning that when a location fails the filter test in one section, it would be excluded (hidden) from the map
  • That means that only the locations that passes the filter test in all the sections will be showing on the map

Assuming you have set all the possible filters, find some details below as how they would show in the Mapping web app Filters section on the left, from top to bottom and a screenshot at the end on how they work for a specific filters combination

Find a Place

It is a special text input where you can start typing and it would show a list with any matching places withing the current map view port. The list will be sorted as they best match what you are typing. This is a feature powered by Google Maps Api

The screenshot below is showing the best matches as just typing 'cn' in that input box.

  • You just need to pick your choice from that list and the Mapping app will center the map and draw a circle around the selected place
  • As well as filter out any locations outside that circle, if you set that option under Preferences > Filters
  • You can change the radius of that circle by clicking on the expanding-circle icon on the right.
  • The default radius value and units are set under Preferences > Filters
  • The circle and the Filter results would change as you modify the radius value

Find Me (my location)

This premium feature is still not available

It would work in a similar way as "Find a Place", just that Place will be the current user's location on the map.

  • It could be a good feature when going around

Search (text)

It is a text input box that filters the locations on the map, as you type there

  • It will look for matches across all the content in your datasheet
  • It ignores case (either lowercase or uppercase would be considered)

As suggested by some clients, we are considering some options under Preferences > Filters, around the Search filter

  • Disable the Search option
  • Restrict the filtering scope to a list of column headers instead of through all of them
  • Limit the number of characters to start filtering (currently 1)

Main Filter

The main filter will be a list of check-boxes with the unique values under the column you choose as Filter in the sidebar

  • Each unique value defines the color of your icons
  • For easier visualization, the specific icon for each value is shown right besides the check-box value
  • Avoid using too many unique values for better navigation and performance

Additional Filters

The additional filters could be of several types, as listed below (some of them might not be available yet)

  • Check-boxes: usually text with a few unique values, that allow for grouping your locations in a meaningful way
  • Slider [left]: numeric values in a range, where the filter would show locations with a value in the selected left range (non numeric values will pass the filter test)
  • Slider [right]: similar to above slider, but using the selected right range
  • Range: similar to above sliders, but with two knobs and using the selected center range
  • Date: it works only with values formatted as "Plain text" in your datasheet and following the date ISO format as YYYY-MM-DD, filtering the locations with the selected date
  • Date Range: similar to above Date, but two of them (from and to), filtering the locations with a date within the from-to dates
  • Select: it would show a sorted list of the unique values for that column, for you to choose one of them

Combining several Filters on your map

On below screenshot we are using several filter sections and the map is showing the locations (5 out of 32) that passes the specific filters combination:

  • within a circle of 13 km around the CN Tower in Toronto, Canada
  • with any Category values
  • with Status either as Escalated, Open or Pending
  • with Range values between 1 and 7
  • with any Company values

Background Notes (TL;DR)

required values and format, not too many unique values ...

how it works? async, debounce, order, etc