Google Drive, GIS & Appsheet

Maps

Forms

Images

Mobile GIS & Data Collection

Why Appsheet?

  • Simple (Google Drive Add-on)
  • Freemium
  • Advanced Capabilities

Google Drive as a Database?

  • No Servers to Manage
  • Synced to Desktop
  • Relies on Google API (Known to change)
  • Also Supports Box, Dropbox
    Office365 & Smartsheet

Setup Spreadsheet

  • Unique ID Field is Helpful
    • Will use Row ID which will change if sorted 
  • Location Field
    • Lat/Long or Address (Appsheet will Geocode)
  • Image Field (public url to .jpg)
  • URL Field for External Link

Appsheet Examples

Google Sheet: Hydrants 

Appsheet: City Guide

Appsheet: Realtor

Appsheet: Project Plan

Hydrant Inspections 

Google Sheet: Hydrants 

Google Sheet: Inspections 

Questions?

More Information

Made with Slides.com