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.
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.
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)
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?
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.