# Delay with new records being synced from Airtable to Glide

**URL:** <https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803>\
**Category:** Ask for Help\
**Created:** [February 11, 2023, 6:41pm UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803 "2023-02-11T18:41:19Z")\
**Posts on this page:** 10\
**Page:** 2

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 6, 2024, 12:18am UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/21 "2024-01-06T00:18:03Z")

</div>

> [@Kellar](#):
>
> For example, if the record being created is a “Clock IN” type, the Airtable automation creates a new record in the HOURS TRACKER table, which is then looked up and rolled up into the user’s record in the EMPLOYEES table as the “Current Clock Session.”
> 
> Or, if the record is being created as a “Start Assignment” type, the automation creates a new record in the ASSIGNMENTS table, which is then looked up and rolled up into the user’s record in the EMPLOYEES table as the “Current Assignment”.

For this, do you mean your “Clock in” form will write to the Hours Tracker table, and your “Start Assignment” form will write to the Assignments table? Do you collect any further info that the user has to fill in for those forms?

---

<div class="post-metadata">

**Author:** ![Kellar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kellar/32/69515_2.png) [@Kellar](https://community.glideapps.com/u/Kellar)\
**Post date:** [January 6, 2024, 12:27am UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/22 "2024-01-06T00:27:22Z")

</div>

@ThinhDinh Yep, that’s exactly it. I’m basically creating a timestamped “clock session” and a timestamped “assignment” record that will be closed out when the user either clocks out or ends the assignment. Everything goes through the FORMS table.

I’ve started working something with the Actions, which seem to be similar to the airtable automations; when I posted earlier I hadn’t messed with them at all yet, so now I’m starting to see how I can make it work.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 6, 2024, 12:30am UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/23 "2024-01-06T00:30:34Z")

</div>

If you don’t need the user to fill in anything else, the button can use the “Add row” action to the destination table with the info you need. For “rolling up” to get “current clock session” or “current assignment”, you can explore a combination of query columns to get the list of “Clock in” and “Clock out” rows of a user, and then a single value column \> last to get the rowID of the latest row, if that’s what you need.

---

<div class="post-metadata">

**Author:** ![Faris\_Ben\_Saad](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/faris_ben_saad/32/69822_2.png) [@Faris\_Ben\_Saad](https://community.glideapps.com/u/Faris_Ben_Saad)\
**Post date:** [June 27, 2024, 8:25am UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/24 "2024-06-27T08:25:15Z")

</div>

**Does anyone know the status of the Glide - Airtable back sync issue?**

The number one dealbreaker for us right now is: With an Airtable backend users need to wait between 30secs to 5+minutes after they created a record to finally do sth. with the record in Glide.

**Example scenarios**  
**Scenario #1** : User creates Record A \> After that User sets a new status (e.g. “publish”) for the record by clicking a button \> everything works in the Frontend \> some minutes later Airtable syncs back to Glide with the old status, i.e. overwrites Glide changes

**Scenario #2** : User creates sth. in Glide \> User reloads page (because users sometimes just do weird things) \> information are lost in Glide - in the best case they already landed in Airtable and are available several minutes later again after the back sync.

**Scenario #3** : User creates a new record A (e.g. Worker) \> User needs to create another record B (e.g. Document) on top of A \> Since Airtable hasn’t synced back yet the record/relation A doesn’t really exist even though we made it visible in the Frontend for the user \> A isn’t linked to B

@david

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [June 27, 2024, 1:39pm UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/25 "2024-06-27T13:39:38Z")

</div>

We know Airtable sync is slow and we’ve tried to improve it for a few quarters. At this point we’ve paused work on Airtable sync to focus on improving Big Tables first, which will host the data in the next version of Airtable sync.

Apologies, but tl;dr: we don’t expect that we will improve Airtable sync this year, and we recommend using Glide Tables or Big Tables instead.

---

<div class="post-metadata">

**Author:** ![Faris\_Ben\_Saad](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/faris_ben_saad/32/69822_2.png) [@Faris\_Ben\_Saad](https://community.glideapps.com/u/Faris_Ben_Saad)\
**Post date:** [June 27, 2024, 2:19pm UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/26 "2024-06-27T14:19:29Z")

</div>

Ok, thanks for the fast response and info!

---

<div class="post-metadata">

**Author:** ![Connor\_Finlayson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/connor_finlayson/32/79079_2.png) [@Connor\_Finlayson](https://community.glideapps.com/u/Connor_Finlayson)\
**Post date:** [June 28, 2024, 12:42pm UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/27 "2024-06-28T12:42:38Z")

</div>

I actually think this is the best option. I think maybe a partnership with a tool like Whalesync could be a great option for syncing Glide Tables and Airtable.

I personally would prefer using Big Tables at this point, there are just some dependencies I have with Airtable that won’t allow me to shift.

Whalesync is a YC company and they specialize in database syncing, I.e Webflow to Airtable, Airtable to Notion, etc.

A good Glide Big Tables integration would be a great solution I think, and would allow you to not have to worry about this ongoing Airtable sync stuff.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [June 28, 2024, 8:43pm UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/28 "2024-06-28T20:43:50Z")

</div>

Yes, we met with Whalesync last week and are looking at adding a Big Tables integration.

---

<div class="post-metadata">

**Author:** ![Faris\_Ben\_Saad](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/faris_ben_saad/32/69822_2.png) [@Faris\_Ben\_Saad](https://community.glideapps.com/u/Faris_Ben_Saad)\
**Post date:** [September 4, 2024, 2:50pm UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/29 "2024-09-04T14:50:44Z")

</div>

1. What is the status with Whalesync?

2. Airtable’s Back Sync will therefore still not work for basic GlideTables - only Big Tables. Right? Or will it be possible to convert GlideTables and Airtable with the frontend logic to Glide Big Tables?

3. So there is no solution at all to access Glide’s internal tables to push an Airtable record into Glide or trigger the fetching (sync) automatically? Glide won’t provide any API endpoint to trigger a manual fetch (sync) or immediate data sync from Airtable?

---

<div class="post-metadata">

**Author:** ![Faris\_Ben\_Saad](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/faris_ben_saad/32/69822_2.png) [@Faris\_Ben\_Saad](https://community.glideapps.com/u/Faris_Ben_Saad)\
**Post date:** [September 12, 2024, 7:47am UTC](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803/30 "2024-09-12T07:47:12Z")

</div>

@david

[Previous page](https://community.glideapps.com/t/delay-with-new-records-being-synced-from-airtable-to-glide/57803.md?page=1)
