Improving refresh time Airtable<>Glide

I’m building a Glide page with Airtable as database. My application has a lot of user-inputted data via various forms. I have a big problem which is that the current sync time between Airtable and Glide is not great. So when I a user, for instance, creates a new row of data and submits a form, it shows up immediately in Airtable but does not display in Glide for sometimes several minutes.

I’m curious if anyone has any experience using Zapier or some other tool to sort of ‘force refresh’ Glide/Airtable when a user submits a form so that the data display is closer to real-time.

I know that one option is to move my database to Glide tables, but I looked into this and (a) it would take a lot of time to migrate and (b) from a quick test it seems like there are many things that Airtable does easily with data management that I cannot do easily in Glide. So I don’t think Glide tables is an option.

Hey @lawsonk, I believe we reload every 3 minutes. Can’t do it any other way at the moment. And yes, I’m sure there are workarounds using Zapier. Linking you with @Darren_Murphy @Robert_Petitto @ThinhDinh who are some of our top experts and may be able to help you with this.

I’ve noticed similar issue on my app, this is a problem that @david mentioned will be fixed by the end of year ?

i’d like a temporary solution if theres any

Thanks @iamtomgray ! Yes I’ve talked to @Robert_Petitto about this before. I know the general solution is to move to Glide Tables but I’m just curious if someone has experience fixing this without doing that.

1 Like

Per Glide’s description of when a data should be re-sync, I expect form submits to be immediately synced, per point 3.

However, it seems like the behaviour @lawsonk was talking about looks to be more in line with point 2, and caused a delay.

Don’t know if it’s a technical limitation, and I haven’t had any Airtables app, just my 2 cents.

6 Likes

Yes @ThinhDinh my problem is related to #2 – the 3 minute check delay via Glide. I do wonder how hard it would be for Glide to simply check more often. Maybe this is a question for @david . If Glide could check with Airtable every 10-15 seconds this problem would largely be solved for my users. I’m not a software engineer so maybe this is hard/expensive to do, but if not it would be a huge help.

(and I would pay more to Glide for the option of faster checking, btw)

1 Like

I’m leaning towards a limitation in the Airtable API.

David talked about this, but there’s no ETA.

1 Like

That makes sense. I get that part of it is an Airtable issue. But I do wonder if there’s anything Glide could do to make the sync faster or if it’s entirely an Airtable problem? @david maybe has the answer to that.

Because even though instant sync would be nice, I would be very happy with a sync every 10-15 seconds. Maybe that is possible now?

Just wanted to query what the things Airtable could do with data management that you couldn’t do in Glide, as I’m somewhat new to both and deciding which to go with for the data side! Cheers

It’s hard to summarize quickly but Airtable is able to do many things that Glide tables can’t do including certain integrations, automations, and overall just easier to manage and visualize your data. If you are building something pretty simple then I’d probably stay with Glide tables. But if it’s complex Airtable will probably end up being easier. @Robert_Petitto may have a more concise suggestion.

1 Like

:point_up_2:This.

If you need to have lots of functionality for people who are strictly working within the database all day, then AT makes sense.

1 Like