Airtable Sync App

Daily Completion Sync

Pulls completed jobs from OptimoRoute and writes the service date into the selected week field in Airtable.

Service Date

Airtable Week Field (auto-selected from date — override if needed)

Auto-calculated: week 17 2026-mowing

Weed & Feed Field (MW&F and W&F stops — leave unset to skip)

Written to MW&F (mowing + W&F) and W&F (W&F only) stops. LM updates the mowing field only.

Seeding Field (only MS stops — leave unset to skip)

Written to MS (mowing + seeding) stops — they also get the mowing field. Leave unset and MS stops update mowing only.

Target Airtable Base

Sandbox (safe for testing) Production (live data)

Status Completed

Started Aug 27, 2026 — 01:32 AM

Completed Aug 27, 2026 — 01:32 AM

Last Run Summary

pulled=203 matched=203 updated=203 wf=0 seeding=0 failed=0 skipped=0 wf_skipped=0 seeding_skipped=0 unmatched=0