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
  • 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

Appsheet

By GIS OVRDC

Appsheet

OVRDC GIS User Group Presentation on Appsheet and Google Drive 2015-05-12

  • 3,405