Need Architectural Review: Data Sync Drops & Rate Limits under Weak Network (3G/4G)

Hello Glide Community!

I live in Uzbekistan and have built a complex ERP and time-tracking system on Glide Tables. This app is a custom frontend mobile replacement for our 1C accounting system. Working in 1C directly is way too difficult for retail staff, so I built this beautiful Glide app as a bridge — I collect all data here and then manually input it into 1C.

The app has been running successfully for 6 months for 20 employees across multiple markets, handling employee clock-ins, inventory, stock movements, and wholesale tracking. Because the official location components are paid, I bypassed this constraint by building my own custom trigonometric formula inside a Math column to check if workers are within a 300-meter radius of the store.

The Problem: Inside dense brick store buildings, mobile internet (3G/4G) is highly unstable. I am constantly getting [Track once] 'ERROR_RATE_LIMIT' and ERROR_PERMISSIONS in my app logs. When 1-2 specific workers hit ‘Check-in’ (Add Row via compound actions) and instantly close the app, the session fails to sync to the server, and I have to fix their hours manually.

I don’t have a budget for paid consultations, but I really need a community expert to review my logic and help me optimize the database architecture.

Also, I would love to hear your honest feedback and an evaluation of my project. Hearing what professional builders think about my workaround and app setup would be a huge motivation for me to keep developing!

Note for community users: The app requires staff authentication. If needed, I can share screenshots or a short video of my Data Editor tables and Compound Actions here in the comments upon request.

How can I rebuild my compound action or relation logic to make it bulletproof against data loss when the network freezes? Thank you in advance!