Mobile-first field activity tracking app for:
- Distributor Visits
- Retailer Visits
- Farmer Visits
- Flutter Android app
- Google Sheets + Google Apps Script backend
- Offline-first local queue
- GPS capture using
geolocator - HTTP sync to Apps Script
- No paid backend required for the V1 pilot
This package is source code, not an APK. The current build environment does not contain Flutter/Android SDK.
Login → Home → Start Activity → Distributor/Retailer/Farmer → Existing/New → Start Visit → GPS + time → Complete → Save locally → Sync to Google Sheets
- Open the supplied Field Activity App V1 Backend workbook.
- Add an Apps Script project from Extensions → Apps Script.
- Copy
backend/Code.gsinto the Apps Script project. - Update
SPREADSHEET_IDinCode.gs. - Deploy as Web App:
- Execute as: Me
- Who has access: Anyone with the link
- Copy the Web App URL into
lib/config/app_config.dart.
For an internal pilot, access is controlled by the Users sheet and Status = Active. Before a broad production rollout, replace email-only pilot authentication with Google Sign-In / Google Workspace authentication.
Users Distributor_Master Retailer_Master Farmer_Master Activities Follow_ups Geography Audit_Log README
- Distributor: existing master only.
- Retailer: existing master + field user can create.
- Farmer: existing master + field user can create.
- Existing entity visit creates a new Activity row.
- New entity gets a unique ID and then immediately opens a visit.
- New entity inherits the logged-in user's geography.
- Activities capture start/end timestamps and GPS.
Install Flutter stable, then: flutter pub get flutter run
For Android release: flutter build apk --release