Location Filters with Excel

Locations represent the specific sites or points within a project where field data is collected. You can manage all your project locations from the Locations tab inside your project on the web portal.

To get started, log in at https://app.qnopy.com/portal/en/login, go to My Projects, and open the project you want to manage. Click the Locations tab.

Setting up location filters

1. Inside your project, click the Locations tab and then click Location Filters.
2. If no filters exist yet, you'll be prompted to download the template. Click Upload to trigger the download prompt.
3. Fill in the template using the following structure:

• The first column must be Field Point and should contain your location names exactly as they appear in QNOPY. 

• Each additional column is a filter. Name the column with your filter name (e.g. Q1, Q2, Gauge, Sample). 

• Set the value for each location under the relevant filter column. Values can be simple Y/N flags or more descriptive labels like "gauge" or "sample". 

4. Save the completed template and return to the web portal. 

5. Click Upload, select your file, and hit Save. Your location filters will appear on the screen and become available to field users in the mobile app. 

Example: If you want to track which locations need sampling vs gauge readings each quarter, your filter columns might be Q1, Q2, Q3, Q4 with values of "sample" or "gauge" for each location. 

Need help?

If you have questions about managing locations or setting up filters, contact our support team:

• Email: [e-mail]
• Phone: [phone]