We use Airtable as the central operational system for a construction company. Approximately 20–25 users work in the base throughout the day, and it manages more than 60 active projects.
Our site managers need a user-friendly mobile app, including the ability to update project information and upload photos from their phones. We originally connected Glide directly to our main Airtable base, but the volume of API activity significantly slowed down the base.
To reduce the load, we created a second Airtable base:
Main operational base → Airtable synced base → Glide
We enabled two-way sync between the main base and the synced base. However, edits made through Glide do not update the synced Airtable fields.
For example, a user checks a checkbox in Glide. It appears checked temporarily, but Airtable never receives the update. The original unchecked value then syncs back to Glide and reverses the change.
We understand that Airtable’s two-way sync may not support edits made through the API, which would explain this behavior because Glide connects through Airtable’s API.
Has anyone successfully built a similar setup?
Would the best architecture be:
- Keep the operational data synced one-way into the secondary base;
- Have Glide write changes to regular, non-synced fields or a separate “Mobile Updates” table; and
- Use Make.com or an Airtable automation to update the corresponding record in the main base?
- Use another app other than Glide?
We would also be interested in hearing whether Airtable’s native mobile interfaces would be a better option for this use case.
Our main requirements are reliable mobile editing, photo uploads, good performance, and avoiding excessive API activity on the main operational base.
Thank you!
