# The order of the rows is altered without explanation **URL:** \ **Category:** Ask for Help\ **Created:** [January 7, 2024, 7:53pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338 "2024-01-07T19:53:48Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Aldeano\_digital](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aldeano_digital/32/74530_2.png) [@Aldeano\_digital](https://community.glideapps.com/u/Aldeano_digital)\ **Post date:** [January 7, 2024, 7:53pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/1 "2024-01-07T19:53:48Z")
Hi I am generating a list of projects to which I assign an autonumeric code by querying all the IDs and a Search index, as I saw in a video of @Robert_Petitto . Apparently it works fine, but I have just seen that, shortly after creating some rows in the table, they change their order, thus changing the project numbering… It is not automatic, it is after a few seconds. I can not find the reason, nor how to avoid it. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 7, 2024, 8:04pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/2 "2024-01-07T20:04:57Z")
Strange. Are you using Google sheets or air table as your base? ---
**Author:** ![Aldeano\_digital](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aldeano_digital/32/74530_2.png) [@Aldeano\_digital](https://community.glideapps.com/u/Aldeano_digital)\ **Post date:** [January 7, 2024, 8:07pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/3 "2024-01-07T20:07:36Z")
Hi. I´m usin airtable. ![Captura de pantalla 2024-01-07 a las 21.06.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb4584c39faccef46e80bcad144ac5b1171dbb57.png) ![Captura de pantalla 2024-01-07 a las 21.06.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/5293cc075c685c79a4f15d74f2b7b5c73f616b42.png) in airtable, the rows do not modify their order. where it modifies it is in glide. I attach two screenshots from each application ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 7, 2024, 8:11pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/4 "2024-01-07T20:11:38Z")
I believe that’s a side effect of Airtable. The way I understand it, the Airtable API does not necessarily feed the rows to Glide in the same order that they are in Airtable. I’m not sure there is much that can be done about that short of using a different data source. ---
**Author:** ![Aldeano\_digital](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aldeano_digital/32/74530_2.png) [@Aldeano\_digital](https://community.glideapps.com/u/Aldeano_digital)\ **Post date:** [January 7, 2024, 8:14pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/5 "2024-01-07T20:14:22Z")
But the strange thing is that the change is not instantaneous. I create the orders sequentially, not at the same time, and it is after a while of having created it, and taking the order code with the autonumeric, that it changes and consequently changes the autonumeric code. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 7, 2024, 8:25pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/6 "2024-01-07T20:25:01Z")
Ya. That’s why I asked. Airtable doesn’t allow Glide to retain the same row order. It’s completely random as new rows get added to the base. Your best bet is to create the functionality in AT ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 7, 2024, 8:30pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/7 "2024-01-07T20:30:13Z")
I believe when data is synced from Airtable to Glide, it’s basically an entire replacement of what Glide has cached, and since Airtable spits out whatever order they want, that’s what Glide gets. Kind of is what it is. ---
**Author:** ![Aldeano\_digital](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aldeano_digital/32/74530_2.png) [@Aldeano\_digital](https://community.glideapps.com/u/Aldeano_digital)\ **Post date:** [January 7, 2024, 8:37pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/8 "2024-01-07T20:37:32Z")
I had not noticed these airtable details. To avoid the small delay that sometimes occurs when returning data from airtbable to glide, I have used the same system, but indexing by creation date with second, to avoid that two orders can be created within the same minute and have problems. Apparently it works. Thank you very much for your time, and @Robert_Petitto thank you very much for your videos. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 14, 2024, 8:37pm UTC](https://community.glideapps.com/t/the-order-of-the-rows-is-altered-without-explanation/69338/9 "2024-01-14T20:37:52Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.